Scheduled report or a direct run report. How to identify?
Hi
A.
I want to identify the type of BIP execution(whether it is scheduled or direct run) in my database function that is called from a Before Data trigger.
Is there a way to identify this?
We have a requirement where in if the webdav link/url of scheduled report outputs must be saved to database.
B.
One solution we tried is..
To generate unique ID for all executions (scheduled and direct runs).
Then, for scheduled reports, save its unique ID in a table using scheduled trigger and trigger parameter.
Eg: SELECT pkg_bip_util.SetBIPScheduling(:QUEUE_ID) from dual
0