Overview: Oracle Alert is your complete exception control solution. Oracle Alert facilitates the flow of information within your organization by letting you create entities called alerts to monitor your business information and to notify you of the information you want. You can define one of two types of alerts: an event alert or a periodic alert.
Periodic Alert checks the database for information according to a schedule you define. When you create a periodic alert, you specify the following:
- A SQL Select statement that retrieves specific database information.
- The frequency that you want the periodic alert to run the SQL statement.
- Actions that you want Oracle Alert to perform once it runs the SQL statement. An action can entail sending the retrieved information to someone in an electronic mail message, running a concurrent program, running an operating script, or running a
- SQL statement script.
Step1: Using Alert Manager responsibility, navigate to Alert > Define
Enter a simple alert as follows:

Note:
Select Statement: Example shown is to ensure to receive one row / exception.
Click ‘Run’ to see the expected number of rows.
Click ‘Verify’ to check the Select syntax.
Keep Days: Enter a number greater than zero to capture history / diagnosis information.
Last Checked: This will populate with a date when the Alert is successfully run.
Step2: Select Actions button

Note:
Enter a simple ‘an1’ action name, click ‘Action Details’.
Text: Display the variable &OUTPUT1 defined in the Select Statement.
Stpe3: Select Action Sets button:

Note:
Inputs tab will be empty.
Outputs tab will show &OUTPUT1.
Choose a different action set name than the action name to better distinguish between the two.
Do not select ‘Exit Action Set Successfully’.
Step4: Select Alert Details button:

Note:
Inputs tab will be empty.
Outputs tab will show &OUTPUT1.
‘APPS’ should only show for the Oracle ID. The Operating Unit is not needed for Periodic Alerts.
Done entering Alert, click ‘save’ and exit.
Step5: Navigate to Request > Check
Click Submit. Note Request ID.

Note:
Enter Application and Alert name from the definition.