BI Publisher (MOSC)

MOSC Banner

Scheduled report or a direct run report. How to identify?

edited Nov 7, 2013 3:06AM in BI Publisher (MOSC) 3 commentsAnswered
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

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