BI Publisher Integration with forms 12c - Getting "BI Publisher integration error"

Hi All,

I am getting the error "FRM-41223: BI Publisher integration error." while calling BI Publisher report from forms 12c. Below is the sample code I am using which is called on a button press.

Can someone help me to fix this?

DECLARE

bi_username VARCHAR2(20);

bi_password VARCHAR2(20);

repid REPORT_OBJECT;

v_rep VARCHAR2(256);

rep_status VARCHAR2(256);

BEGIN--Server BI Publisher

v_xmlpserver: = 'http://server:port/xmlpserver';

--Identify the report

repid: = find_report_object ('CCFOR003');

-- Username & Password.

SET_REPORT_OBJECT_PROPERTY (repid, BIP_USER, bi_username);

SET_REPORT_OBJECT_PROPERTY (repid, BIP_PASSWORD, bi_password);

--

SET_REPORT_OBJECT_PROPERTY (repid, BIP_SSL_CONNECTION, OPTIONAL);