Request SQL to Extract All Agent Configuration Details

Hi Team,

We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion.

Currently, we can only see these details through the UI (Catalog > Agent > Edit), but for audit and reporting purposes we need a backend SQL to extract the following attributes for each Agent:

1. General Tab
   • Agent Name, Priority, Run As User, Owner, Description
2. Schedule Tab
   • Frequency (Daily/Weekly/Monthly)
   • Day/Time of run
   • Start/End Dates
   • Re-run frequency
3. Condition Tab
   • Condition used or “Always deliver content” flag
4. Delivery Content Tab
   • Subject line
   • Report Path / Content Path
   • Output format (Excel, PDF, etc.)