Using Oracle Alert in Oracle Purchasing
Several Oracle Applications products, including Purchasing, include the functionality of Oracle Alert to provide you with on-line exception reporting capability.
Oracle Alert is a customizable exception control application that:
- Notifies you automatically when a user performs a specific form transaction
- Notifies you automatically when a specific database transaction occurs
- Provides key information to you on a periodic basis
- Monitors critical activity in your Purchasing database
- Acts automatically according to your specifications
Purchasing supplies you with several pre-coded alerts that you can use with or without customizing. These alerts help you identify forecast overconsumption. See: Using Predefined Alerts.
You get the alerts described in the following pages if you have Oracle Alert. You can also create your own alerts to notify you when a user takes a specific action, or notify you about specific exceptions found in your Purchasing database. You can also create alerts that send messages about key indicators, according to a delivery schedule you define. See: Overview of Oracle Alert.
Expiration and Release Control Alerts
For planned purchase orders, blanket purchase agreements, and contracts, you can establish expiration and release control notification conditions and specify the number of days before the condition is met that you want to be notified. By selecting Notification Controls on the Special menu in the Purchase Orders window, you can specify the following notification conditions:
- Amount not released by date
When the notification conditions are met, Purchasing sends you one of the following Oracle Alerts so that you can take appropriate action:
Amount Not Released
| Alerts you that the total planned amount released to date against a planned purchase order, blanket purchase agreement, or contract purchase agreement is insufficient.
|
Amount Released
| Alerts you that the total amount released to date against a planned purchase order, blanket purchase agreement, or contract purchase agreement meets or exceeds specified amounts.
|
Expiration
| Alerts you that a planned purchase order, blanket purchase agreement, or contract purchase agreement is about to expire.
|
See Also
Entering Purchase Order Notification Controls
Oracle Alert supplies you with the following predefined alerts for Purchasing that you can use with or without customizing. For each pre-coded alert, we include:
- A brief explanation of what the alert does
- Information about the alert's periodicity, inputs, and distribution
- An example of the message Oracle Alert sends when you use the alert
Approved Standard Purchase Orders
This alert shows the number of approved purchase orders created by each buyer during the past N days.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| Number of days
|
Distribution
| User defined
|
Blanket Notification Expiration
This alert shows the blanket purchase agreements that are about to expire.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Blanket Notification Not Released
This alert shows the blanket purchase agreements for which an insufficient amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Blanket Notification Released
This alert shows the blanket purchase agreements for which the desired amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Blanket Purchase Releases over Threshold
This alert looks for blanket purchase releases that exceed a certain dollar amount.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| Number of days
|
| Dollar amount
|
Distribution
| User defined
|
Contract Notification Expiration
This alert shows the contract purchase agreements that are about to expire.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Contract Notification Not Released
This alert shows the contract purchase agreements for which an insufficient amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Contract Notification Released
This alert shows the contract purchase agreements for which the desired amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
No Receipt Required on Purchase Order Shipment
This alert looks for purchase order shipments where two-way matching is allowed.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| Number of days
|
Distribution
| User defined
|
Planned Notification Expiration
This alert shows the planned purchase orders that are about to expire.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Planned Notification Not Released
This alert shows the planned purchase orders for which an insufficient amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Planned Notification Released
This alert shows the planned purchase orders for which the desired amount has been released.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| Buyer
|
Small Business Suppliers
This alert shows your suppliers who are identified as small businesses.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| User defined
|
Standard Purchase Orders over Threshold
This alert looks for standard purchase orders created in the past N days that exceed a certain dollar amount.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| Number of days
|
| Dollar total
|
Distribution
| User defined
|
Suppliers on Hold
This alert shows the suppliers that you have placed on hold.
Alert Type
| Periodic
|
Periodicity
| On Demand
|
Inputs
| None
|
Distribution
| User defined
|