BI Publisher (MOSC)

MOSC Banner

FRM-41223 BI PUBLISHER INTEGRATION ERROR

edited Jul 29, 2019 11:23PM in BI Publisher (MOSC) 4 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center