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:
- General Tab
- Agent Name, Priority, Run As User, Owner, Description
- Schedule Tab
- Frequency (Daily/Weekly/Monthly)
- Day/Time of run
- Start/End Dates
- Re-run frequency
- Condition Tab
- Condition used or “Always deliver content” flag
- Delivery Content Tab
- Subject line
- Report Path / Content Path
- Output format (Excel, PDF, etc.)
0