How To Display BI Publisher Report From Oracle Forms Without Re-Authentication By Xmlpserver (Doc ID 2172769.1)

Last updated on MAY 24, 2023

Applies to:

Goal

Integrating Bi Publisher with Oracle Forms 12c (12.2.1.1.0).
Have successfully run a BI Publisher report using the following pl/sql block as an example from Oracle Forms.

DECLARE
 repid REPORT_OBJECT;
 report_prop VARCHAR2(20);
 v_xmlpserver varchar2(100);
 v_rep varchar2(100);
 
BEGIN
v_xmlpserver := 'http://hostname:port/xmlpserver';

repid := find_report_object ('REPORT10');

SET_REPORT_OBJECT_PROPERTY (repid, BIP_USER , 'username');
SET_REPORT_OBJECT_PROPERTY (repid, BIP_PASSWORD , 'password');
SET_REPORT_OBJECT_PROPERTY (repid, BIP_SSL_CONNECTION , OPTIONAL);
SET_REPORT_OBJECT_PROPERTY (repid, BIP_SERVICE_LOCATION , v_xmlpserver || '/services/v2/ReportService?wsdl');
SET_REPORT_OBJECT_PROPERTY (repid, BIP_REPORT_PATH , '/folder/Pivot Report.xdo' ) ;
SET_REPORT_OBJECT_PROPERTY (repid, BIP_REPORT_LOCALE , 'EN-us');
SET_REPORT_OBJECT_PROPERTY (repid, BIP_REPORT_FORMAT , 'pdf');
SET_REPORT_OBJECT_PROPERTY (repid, BIP_REPORT_TEMPLATE , 'Pivot word temp 2');

v_rep := RUN_REPORT_OBJECT (repid);
END;

Would like to display the generated pdf file without re-authenticating by xmlpserver. 
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.