Feasibility of AI Agent Studio to identify terminated users in scheduled OTBI reports

When an employee is terminated in Oracle Fusion, we need a mechanism to identify all OTBI Agents where the user is referenced in the distribution list, either through Employee Name, Person Number, or Email Address. Additionally, we require visibility into the associated scheduling details to assess the impact and perform any necessary cleanup activities.

We would like to understand the feasibility and high-level design for implementing such a solution.

The solution should be able to:

Scan all available OTBI Agents across the Oracle Fusion HCM instance.

Retrieve and maintain metadata including Agent Name, Agent Owner, Folder Path, Schedule Details, and Distribution Lists/Recipients.