Oracle Alert

Introduction:

Oracle Alerts is something that can be used to Notify/Alert to one or multiple persons about an activity or change that occurs in the system. The alerts can also be used to call a procedure, run some sql script etc.

There are 2 types of alert

1) Periodic Alert

2) Event Alert

Periodic Alerts:

Periodic alerts periodically report key information according to a schedule you define. You can modify our precoded alerts or simply create your own, and Oracle Alert will send messages or perform predefined actions from an action set according to the schedule you set.

You can define periodic alerts on any Oracle Financials, Oracle Manufacturing, Oracle Human Resources, or Oracle Public Sector Financials application as well as any custom Oracle application.

Periodic alerts can be set to run as often as you need during a 24-hour period, or they can be set to run once a month–the frequency is up to you. Used over time, periodic alerts can provide a regular and reliable measure of performance.

For example, you can define a periodic alert for Oracle Purchasing that sends a message to the Purchasing Manager listing the number of approved requisition lines that each purchasing agent placed on purchase orders. You can define this alert to run weekly, and provide performance measurement on a consistent and timely basis.

Example.

1) Daily alert to send notification on the sales order on which credit check hold is applied for a day

2) Hourly alert to send notification on all the concurrent request that completed with error

Event Alerts:

These Alerts are fired/triggered based on some change in data in the database. This is very similar to the triggers written on the table. Unlikely, event alerts can only fire on After Insert or After Update.

In other word, Event alerts immediately notify you of activity in your database as it happens. You define what a database event is–an insert or an update to a table–and Oracle Alert informs you when it happens. You can modify our precoded alert conditions or simply create your own, and Oracle Alert will send messages or perform predefined actions in an action set when important events occur.

Example.

1) An alert that sends notification when new item is created.

Business need:

Oracle Alert gives you the flexibility you need to monitor your business information the way you want. An exception reporting system should:

• Keep you informed of database exception conditions, as they occur.
• Let you specify the exception conditions you want to know about, as often as you want to know about them.
• Keep you informed of exception conditions through a single point–your electronic mail.
• Take predefined actions when it finds exceptions in your database, without user intervention.
• Take the actions you specify, depending upon your response to an alert message.
• Perform routine database tasks automatically, according to the schedule you define.
• Be fully integrated with your electronic mail system.
• Send electronic mail messages to a distribution list you define, so you avoid typing the same set of recipients for many messages.