FRM-41223 BI PUBLISHER INTEGRATION ERROR
DECLARE repid REPORT_OBJECT; report_prop VARCHAR2(20); v_xmlpserver varchar2(100); v_rep varchar2(100); REP_STATUS VARCHAR2(500); BEGIN v_xmlpserver := 'http://machine:port/xmlpserver'; repid := find_report_object ('BI_EMP'); SET_REPORT_OBJECT_PROPERTY (repid, BIP_USER , 'weblogic'); SET_REPORT_OBJECT_PROPERTY (repid, BIP_PASSWORD , 'weblogic1'); 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 , '/~weblogic/_temp/UML_BREAD_DS.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 , '/~weblogic/_temp/UML_BREAD_DS'); v_rep := RUN_REPORT_OBJECT (repid); rep_status := report_object_status(v_rep); message(rep_status||'...... before connection'); END;