Previous  Next          Contents  Index  Navigation  Glossary  Library

Using Oracle Alert for Exception Reporting

Several Oracle Applications products, including Payables, use Oracle Alert functionality to provide online exception reporting capability. You can integrate Oracle Alert with your electronic mail system.

Oracle Alert is a completely customizable exception control application that can:

Payables supplies you with several pre-coded alerts that you can use with or without customizing. These alerts help you:

If you install Oracle Alert, you can also create your own alerts to notify the appropriate people when a user takes a specific action, or when specific exceptions arise in your Payables database. You can also create alerts that send messages about key indicators, according to a delivery schedule you define.

See Also

Overview of Oracle Alert

Using Predefined Alerts

Invoices on Price Hold

This alert queries your database for invoices currently on Price hold and notifies the originating purchase agent for each held invoice. When a single purchasing agent has two or more invoices with Price holds, Oracle Alert sends only one message describing each held invoice.

Alert Type Periodic
Periodicity Weekly
Inputs None
Distribution Purchasing Agent for this invoice

Invoices on Quantity Received Hold

This alert looks for invoices on Quantity Received hold and notifies the originating Purchasing Agent for each held invoice. Oracle Alert sends to each responsible purchasing agent a summary message that describes each held invoice and asks the agent to resolve the hold.

Alert Type Periodic
Periodicity Weekly
Inputs None
Distribution Purchasing Agent for this invoice
Implementation Suggestion To send an alert message to a specific purchasing agent, you must define a descriptive flexfield on the HR_EMPLOYEES table to store an electronic mail name for each employee. Then, revise the alert's Select statement to refer to the appropriate descriptive flexfield segment.

Invoices on Quantity Ordered Hold

This alert looks for invoices on Quantity Ordered hold. If any exceptions occur, Oracle Alert sends a summary message to each responsible purchasing agent to resolve invoice holds caused by a difference between quantity billed and quantity ordered.

Alert Type Periodic
Periodicity Weekly
Input Variables None
Distribution List Purchasing Agent

Receipt Holds

This alert looks for overdue items that you have not received. If any exceptions occur, Oracle Alert sends a detail message to the original requestor asking for verification of receipt. If the requestor has received the item, the requestor can ask a designated receiver to enter receipt of the item into Purchasing. You may want to adjust the suppress duplicates option of the distribution list to limit repeat messages.

Alert Type Periodic
Periodicity Weekly
Input Variables None
Implementation Suggestion To send an alert message to a specific purchasing agent, you must define a descriptive flexfield on the HR_EMPLOYEES table to store an electronic mail name for each employee. Then adjust the alert SQL statement to reference the appropriate descriptive flexfield.
Distribution List Item Requestor

         Previous  Next          Contents  Index  Navigation  Glossary  Library