Periodic Alert in Oracle Application

Oracle Periodic Alert

Overview : This Alerts are triggered periodically like Hourly, Daily, Weekly, Monthly or On Demand.

We Will Define Periodic Alert which will notify us regarding if any responsibility of user is added/updated.

  

Steps to Creation of periodic Alert.

Step 1: Define Alert

Navigation: Alert Manager -> Alert -> Define

Define Oracle Alert

 Frequency: Select the frequency from the list of value.

Select Statement:  Enter the select statement which fetch all the data required for 

Query Should be in Below Format:

Select Columns (:input if needed)

into &output                                  

from Table                                     

Conditions                                    

Save the changes.

Check the SQL statement is successfully parsed in Alert or not using Verify Button.

 Step 2: Define Actions in oracle alert

 Navigation: Click on Actions Button to define the Actions.

You can define multiple actions for a single Alert.

Define Actions

Click on Action Details.

Below are the action types which we can define to execute once alert triggered. 

1. Concurrent Programs - you can call concurrent in oracle alert
2. SQL Statement Script
3. Message (Mail)
4. OS Script

Action Details

You can use output parameter here.

 Step 3: Define Action Sets in oracle alert

 Navigation: Click on Action Sets Button.

Here you can define set of actions which you want to execute once alert triggered. 

Click on Action Sets Button

Define Set of Actions

Define Action Set Details

Click on Action Set Details Button.

 Action Set Details window will pop up. You will find the input,output parameter which used in SQL statement.

Input Parameter Details

Output Parameter Details

In Members tab you can select the Action which we define in Step 2

Define the Action Name in Action Sets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 4: Define Alert Details

Define the Data Types,Default values, format for input and output parameters.

Define Data Types of Input Parameter

Same for Output Parameter.

Output Parameters

You can define the user and operating unit for which you are going to use Alert.

Define User and Operating Unit

In this way you can define the Periodic Alert. You can check the history of your Alert and also check for any exception occurred or not.

Check the History of Oracle Alert - 

You can check history of oracle alert using below navigation. 

Navigation: Alert Manager -> History 

History of Alert

Check all the actions,exception,checks of the Alert.

Exception if Any