Delete Interface/Integrator/Component - Web ADI

--Delete an Interface/Integrator Details

SELECT biv.application_id

       ,biv.integrator_code

       ,biv.user_name

       ,bib.interface_code

   FROM bne_integrators_vl biv

       ,bne_interfaces_b   bib

  WHERE upper(user_name) like '%XXAK%'

    AND bib.integrator_code = biv.integrator_code ;

---------------------------------------------

--Delete an Interface

DECLARE

   vn_number   NUMBER;

BEGIN

   vn_number := bne_integrator_utils.delete_interface

                (p_application_id => 20003,

        p_interface_code  => 'XXAKTESTUPADI_XINTG_INTF1');

                

   DBMS_OUTPUT.put_line ('ADI Interface Deleted '||vn_number);

   COMMIT;

   --

EXCEPTION  

   WHEN OTHERS THEN

      DBMS_OUTPUT.put_line('Error: '||sqlerrm);

      ROLLBACK;

END;

----------------------------

--Delete an Intergrator

DECLARE

   vn_number number:=0;

BEGIN

   vn_number:= bne_integrator_utils.delete_integrator

               (p_application_id => 20003,

                p_integrator_code => 'XXAKTESTUPADI_XINTG');

               

   dbms_output.put_line(' ADI Deleted : '||vn_number);

   COMMIT;

   --

EXCEPTION  

   WHEN OTHERS THEN

      DBMS_OUTPUT.put_line('Error: '||sqlerrm);

      ROLLBACK;

END;

---------------------------

--Delete a Component

DECLARE

   vn_number number:=0;

BEGIN

   vn_number:=BNE_INTEGRATOR_UTILS.DELETE_COMPONENT(p_application_id => 200,

                p_COMPONENT_CODE => 'HUBINV_XINTG_INTF1_C9_COMP');

              

   dbms_output.put_line(' ADI Deleted : '||vn_number);

   COMMIT;

   --

EXCEPTION 

   WHEN OTHERS THEN

      DBMS_OUTPUT.put_line('Error: '||sqlerrm);

      ROLLBACK;

END;

How To Clear BNE Cache

https://dbissues.blogspot.com/2017/08/how-to-clear-bne-cache.html

To Clear BNE cache:

Using System Administrator responsibility:

Login to the application as a user with System Administrator Responsibility.

Select the System Administrator Responsibility.
Bring up the AdminServlet by changing the URL in the browser where you are logged into the applications keeping the appropriate hostname.domain and port number.

Release 11i:
http://hostname.domain:portnumber/oa_servlets/oracle.apps.bne.framework.BneAdminServlet
On the new web page that loads, scroll down and click the "clear-cache" link

Release 12:
http://hostname.domain:portnumber/OA_HTML/BneAdminServlet
On the new web page that loads, scroll down to the Cache Name section.
Clear the cache for the following by clicking the "(clear)" link:

Cache Name
============
Default Cache
Generic SQL Statements
Web ADI Repository Objects
Web ADI Parameter Lists
Web ADI Parameter Definitions


The BNE cache is now cleared.

PDF Output is being sent in .out format as mail attachment through Oracle

https://dbissues.blogspot.com/2017/08/pdf-output-is-being-sent-in-out-format.html

Attachment is being sent in .out format for PDF file

Currently, there is no such function in EBS to generate report output file extension in the mail as anything other than .out.

Workaround:

The delivery option is coming from xml publisher API , and if the report is generated by xml publisher, it will generate two output file, one is the output of the request, an .out file and the other one is generated by bi publisher, which may be a .pdf file or an .xls file. The API then attach  the correct file in the mail, but when the report is generated by oracle report, though it is a pdf file, it is an .out file in the file system and API attach it in the mail.

Simple is, If the report is generated by xml publisher , the pdf format output will have a output file as .pdf. In the case, the delivery API would send the pdf output in the email as the attachment with .pdf . So you may need to generate the report output from Oracle*Report by xml publisher.

----------------------------------

Register Report in XML Publisher in .rtf format and make Default Output view & Preview Format to PDF.

In concurrent Program, select Output Format as XML and run the Report. Email will be sent in .pdf format