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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to pull out all the notifications & alerts including details, body, subject, etc?

Summary: We have a need to audit our notifications. This includes both notifications & alerts. Is it possible to extract both notifications and alerts through SQL (analytics) including the subject line, body, who it is sent to and when?

Content (required): I'm trying to figure out which tables to use to extract both notifications and alerts so I can supply to the proper teams to review. There are multiple teams with this need. Could you please share which tables to use in SQL to include the alerts & the notifications details?


Version (include the version you are using, if applicable): 22D


Code Snippet (add any code snippets that support your topic, if applicable): N/A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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