How to Schedule periodic alert in oracle apps

Hi friends, we are going to discuss about how to Schedule periodic alert in oracle apps. We will share the details steps to create the period alert and than schedule the period alert in oracle apps. Once we have created the periodic alert in oracle then we need to run it first time. We need to submit/run the periodic alert first time and then periodic alert schedule automatically. In this post , We will be create the periodic alert and then schedule the periodic alert in oracle apps. Please find below the detail steps to Schedule periodic alert in oracle apps.

Step by Step to Schedule periodic alert in oracle apps

1. First of all the most important thing to schedule the periodic alert is to check the 'Periodic Alert Scheduler'. It should be activated.

Step 2:- Here below , we need we can see this scheduler is 'Deactivated' we need to click on 'Activate' Button to activate this scheduler.

How to Schedule periodic alert in oracle apps

Step 3:- After activating the periodic alert scheduler , now we need to create the periodic alert.

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 Schedule periodic 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.

How to Schedule periodic alert in oracle apps

Step 3:- 

Here below we are defining the Action Type: 'Message'

To: test@email.com

Subject: Users no email address in user account.

&user_name is the output variable from sql statement and we are using to write the email/message body.

How to Schedule periodic alert in oracle apps

Step 4:- Now we need to click on the Action Sets button. We are giving the name Action Set Name 'Email Report'. Now Click on the Action Set Details.

How to Schedule periodic alert in oracle apps

Step 5:- Under Action set details, we need to set the Alert action created in the step 2.

Step 6:- Now our alert has been created and we are going to run the alert in oracle apps.

Go to Alert Manger Responsibility.

Alert : Request ==> Check.

How to Schedule periodic alert in oracle apps

Step 6:- Enter the Application which we have given to create the alert in step 1.

Now select the Alert Name which we created in Alert 1 and then submit the request.

Now our alert has been run and schedule automatically based on the schedule mentioned in the Alert itself.

How to Schedule periodic alert in oracle apps

How to Schedule periodic alert in oracle apps