Core Workflow - EBS (MOSC)

MOSC Banner

Solution required to Include Audit tables in Oracle Alert

edited Feb 16, 2017 4:00AM in Core Workflow - EBS (MOSC) 1 commentAnswered ✓

Hi, we need to send alert email if anyone run Oracle Payroll Run delete.
Oracle Payroll run delete will delete records from table PAY_RUN_RESULTS.
Since Oracle Alert has no option to send alert on delete event, and only insert/update Alerts.
We created Audit Trail for PAY_RUN_RESULTS table. Audit Trail is inserting delete events related records into PAY_RUN_RESULTS_A audit table.
We need solution to how to include PAY_RUN_RESULTS_A audit table to Oracle Alert and send alert mails on insert events.

Thank you in advance for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Workflow Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center