Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Saturday, December 22, 2012

Oracle Alert FAQ’s


 
  1. What are the event alerts?
Triggered off when a particular event occurs in the Database.
Event can be Insert or Update.
     
  1. What are Alert Action Level?
There are two levels of actions that can be performed
            Detail Action and Summary Action.

  1. What is a Summary Threshold?
Oracle Alerts automatically determine whether to perform a detail action or Summary action based on the number of exceptions in the database.

  1. What are the different actions that can be performed in Alerts?
    • Message Actions
    • Concurrent Program Actions
    • Operating Script Actions
    • SQL Statement Script Actions

  1. What are the steps involved in Creating Periodic alerts?
·         Write a select statement
·         Verify and Run the SQL
·         Specify Alert Inputs
·         Define Alert Outputs
·         Create Periodic alert actions
·         Define Periodic alert message actions
·         Create a periodic alert action set
·         Check your periodic alert.

  1. What is the Distribution List in Alerts?
A Pre-defined set of electronic mail ids and printer Instructions that you can use on message actions instead of re-entering all the recipient names each time.

  1. What are the Advance features available in alerts?
·         Distribution List
·         Periodic sets
·         Summary Thresholds
·         Action Set Checks

  1. What are the four implicit Inputs in Alerts?
Mailid, rowid, org_id, date_last_checked

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect