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

Need SQL Query to Extract Seeded and Custom Audit Report Details

edited Nov 3, 2025 8:34PM in Reporting and Analytics for ERP 1 comment

Hi Team,

I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the following information:

  1. Report Name and Path
  2. Average Execution Duration (Maximum and Minimum Running Time)
  3. Frequency of Execution
  4. Associated ESS Job Names

Could anyone please help me with the SQL query or the tables involved to retrieve these details?

Thanks in advance for your guidance and support.

Regards,

Karthikeyan

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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