Oracle Alerts

Invoking On-Demand Alert from FND_REQUEST.SUBMIT_REQUEST

We can invoke the On-Demand Alerts from PL/SQL programs using the Concurrent Program submission API. Steps provided below:   Consider the below Periodic alert example Indexes near maximum extents  …

Read More

Oracle Periodic Alert Setup

Periodic Alert: Periodic alert, checks the database for information according to a schedule you define. In a periodic alert specify the following: • A SQL Select statement that retrieves specific…

Read More