You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle Fusion

in Reporting and Analytics for HCM

Hi everyone,

I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion.

I also need to identify or retrieve deleted/removed BI report job history, if it is still available in any backend audit or history tables.

Could someone please advise:

  • Which tables/views can be used to retrieve BI report job execution history?
  • Is there a way to retrieve deleted BI report job/schedule history using SQL?
  • Are deleted job details stored in any audit, ESS, BI Publisher, or backend tables?
  • If possible, could you please share a sample SQL query?

Any guidance or references would be greatly appreciated. Thank you!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!