Purge Excess Inventory Reservations
Use the Purge Excess Inventory Reservations scheduled process to purge the manually created reservations for sales orders and transfer orders which are in Oracle Fusion Cloud Order Management but not interfaced to Oracle Fusion Cloud Inventory Management or Oracle Shipping.
When to Use
The reservations for the unreleased sales orders and transfer orders that are manually reserved to available inventory, purchase orders, transfer orders, or work order supplies aren’t deleted when the sales order is canceled. The orders that are in Order Management, but not released to Inventory Management or Shipping can be termed as unreleased sales orders or transfer orders. The Cancel Order or Unschedule Change Management actions for such order lines don't clear the manually created reservations. These reservations can be deleted by using the Purge Excess Inventory Reservations scheduled process. Additionally, this process also purges any excess reservations that haven’t been cleared on a partial shipment for a sales order or transfer order.
Privileges Required
- Purge Excess Inventory Reservations Process (INV_PURGE_EXCESS_INVENTORY_RESERVATIONS_PROCESS_PRIV)
Specifications
Specification | Description |
---|---|
Job Type | Ad hoc job Scheduled |
Frequency | As required. You can schedule it to run monthly. |
Time of Day | Any time. |
Duration | The process should complete within a few minutes if there are few thousand records. |
Compatibility | You need to run this scheduled process for every inventory organization to purge the excess reservations. There can be multiple instances of the process running, but it’s recommended to schedule the process so that only one instance of the process is running at a time. |
Parameters
Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
---|---|---|---|---|---|
Organization | Required | Purge the reservation records for a specific inventory organization. | Inventory organization |
Organization must be entered. |
N/A |
Item | Optional | Purge excess reservation records for a specific item. | Item name |
Organization must be entered. |
N/A |
Order Type | Optional | Purge excess reservation records for sales orders and transfer orders. |
Sales order Transfer order |
Organization must be entered. |
N/A |
Order | Optional | Purge excess reservation records for a specific order number. | Sales order number |
Organization must be entered. |
When the order number in the order capture system is different than the sales order number in Order Management, search for the order number in the source system. This will return the sales order number in Oracle Fusion. |
Order Line | Optional | Purge excess reservation records for an order line. | Sales order line number |
Organization and Order must be entered. |
N/A |
Troubleshooting Information
- You can view the status of the Purge Excess Inventory Reservations process in the Scheduled Processes work area.