I'm using sample code from the Oracle BI Publisher Integration section of the Oracle Forms 12c New Features white paper, which includes calling REPORT_OBJECT_STATUS to get the status of the report job from a BI Publisher server.
-- Ask BIP to run the report.
v_rep := RUN_REPORT_OBJECT(repid);
/* DO SOMETHING ABOUT CHECKING STATUS HERE The call to BIP is asynchronous. Therefore, it will be necessary to check on its status periodically if
notifying the user is desired. The report_object_status built-in can be used for that check.
Likely a timer would be used to periodically check the status. Using a loop is not recommended.
Example: rep_status := report_object_status(v_rep);
*/
This suggests that REPORT_OBJECT_STATUS should work similarly to the way it does for Oracle Reports. But when I call it for an OraBIP type report, it always returns the value "Scheduled". Whether called immediately after RUN_REPORT_OBJECT, or long after the report has been delivered and is showing a status of "Success" in the BI Publisher Report Job History display, REPORT_OBJECT_STATUS returns "Scheduled".
Is there something wrong on my side (code or configuration) or is this expected behavior for BI Publisher reports?
(Forms and BI Publisher version are both 12.2.1.3.0)