Issue Passing Date Parameters from Oracle Forms to BI Publisher Report

Hi All,

I’ve developed a BI Publisher report that includes two date parameters: p11 (Start Date) and p12 (End Date). The report runs successfully in BI Publisher with manual input for the parameters. However, when I attempt to pass these parameters from Oracle Forms, the output is a blank report.

Here’s the code I’m using in Oracle Forms to pass the parameters:

SET_REPORT_OBJECT_PROPERTY(repid, BIP_REPORT_PARAMETERS, 'p11='||:p_fromdt);
SET_REPORT_OBJECT_PROPERTY(repid, BIP_REPORT_PARAMETERS, 'p12='||:p_todt);

Despite these efforts, the report output remains blank. Am I missing something in the way parameters are passed from Oracle Forms to BI Publisher? Any guidance would be greatly appreciated.