How to run alert in oracle apps

Hi Friends, we are going to discuss about How to run alert in oracle apps. We will share the details steps to run the alerts in oracle apps. Alerts is an action based on some results or events in oracle apps. In this post , We are sharing the complete steps to create the alert in oracle apps and how we can run the alert in oracle apps. We will discuss how we can run the alerts in oracle apps. When we run the alert , then based on the action step we mentioned in the alert itself , alert trigger that action. If we have mentioned the action type 'message', then alert triggers the email notifications when we run that alert. If we have mentioned the action type 'Concurrent Program Definition' then it execute the Concurrent program request during run. We will be discuss more about how to run alert in oracle apps.

2 Types of Alert in Oracle apps

1.Periodic Alert

2.Event Alert

Periodic Alert:- Periodic Alert is called schedule alert. Periodic Alert we do schedule in the application itself. This alert execute based on the schedule we mentioned under that alert. Like once in a day or twice in a day.

Event Alert : Event alert executes when some event(Insert/Update) occur in the DB Table. We do create the Event alert for the DB table. It executes when any data will insert or update in the table.

Alert Action Types in Oracle apps

1.Message : Email Notification

2.Concurrent Program Definition : Triggers the Concurrent Program.

3.Script: Trigger the SQL Script.

Steps to run the Alert in Oracle Apps

Here below is the detail steps to run the alerts in Oracle Apps.

Step 1:-Here below we are creating the Alert

Name : XX Users With No Email Address

Periodic : Frequency : Every N Calendar Days ( Days 1) Means Once in day it will be run at 12.

Select Statement: We need to write the sql condition , and it should have some results or records if we want fire this alert. In the Select statement , there should be at least one record fetch to fire this alert on that schedule other if no record will be fetch the sql statement then this alert will not be fire or execute.

How to run alert in oracle apps

Step 2:- Now we need to go to the Actions Button and need to give the Action Name (Any Name).

Action Name: XX EMAIL ACTION.

Action Level : Summary

Action Level decide , how many times the action will be fire. For example ,If our sql statement of Alert will fetch 3 rows and we have decided the Action Level 'Detail' then action will be fire three times But if Action Level 'Summary' then action will be fire only once.