Get list of scheduled processes with the notifications configured for the process
Subject Area:
In Oracle, we can configure notifications for scheduled processes.
Problem Statement:
We need to extract the list of all scheduled processes with following requirements:
1. Name of process
2. If a notification is configured for the processes
3. If notification is configured, then it is send to which user
Requirement:
Need to find this list for audit purposes
Step taken so far:
1. Oracle does not provide any download option or any built in reports
2. Tried to create a custom report/ data model but the table only returns metadata for the scheduled process and nothing related to notifications configured
3. This Oracle document verifies point 2: