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

Review the following before setting up this scheduled process:

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.