Inventory Reservations Not Relieved for Closed or Canceled Sales Orders and Some are Orphaned: Clean up scripts for Releases 11i and 12 (Doc ID 1322105.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle Inventory Management - Version 11.5.9 and later
Oracle Materials Requirement Planning - Version 11.5.10 and later
Oracle Item Master - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
ConcurrentProgram:MRCSAL1 - Load/Copy/Merge MDS
Form:MRPSCPWB.FMB - Supply Chain Planner Workbench
Form:MSCFNSCW.FMB - Planner Workbench
Form:INVDVDSD.FMB - View Item Supply/Demand Information
Form:INVDVDSD.FMB - View Item Supply/Demand Information
Form:OEXOEORD.FMB - Sales Orders

This note combines archived notes:
1. How To Delete Reservations That Are Not Relieved When Order is Canceled or Closed ()
2. 11i/R12: Clean Up Scripts - Inventory Reservations Not Relieved for Closed Sales Orders ()
3. Cancelled Closed or Deleted Sales Orders or Lines or Forecast Entries Show in MDS MPS MRP or ASCP Plan ()
4. INVDVDSD - Clean Up Reservations Post Patchset G ()
5. Standard Cleanup Scripts for INVDVDSD - SUPPLY/DEMAND in 11.5.10.2, 12.0 and 12.1 ()




Symptoms

In Oracle Materials Requirement Planning, Oracle Order Management and Oracle Advanced Supply Chain Planning, you may be experiencing some or all of the following symptoms:

Canceled sales orders or order lines still show in MDS MPS MRP or ASCP
Closed sales orders or order lines still show in the MDS MPS MRP or ASCP
Order lines not connected to a sales order show in the MDS MPS MRP or ASCP
Non existent order lines show in the MDS MPS MRP or ASCP
Canceled purchase orders or requisitions show up in the MPS MRP or ASCP
Canceled Forecast Demand show up in the MPS MRP or ASCP
Pick released lines still show as demand in MPS MRP or ASCP

In Oracle Inventory Management, you may be experiencing some or all of the following symptoms:

Demand is incorrect for closed sales order lines
Reservations exist for sales order lines that have shipped
Demand exists for sales order lines that have shipped
Supply/Demand Screen shows records for a sales order, but the sales order is closed.

Steps to Reproduce in Oracle Inventory Management:
1. In Order Management Superuser navigate to Orders, Returns > Order Organizer.
2. Find a sales order with closed sales order lines (that were demanded or reserved).

How to tell if the Sales Order is reserved or demanded.
1. In Inventory Responsibility navigate to > On-Hand Availability > Supply/Demand
2. Select Organization.
3. Query the item.
4. Select All Subinventory Locations.
5. A detail row reveals that the item is reserved for a sales order and quantity (shown as a negative number).
6. Expected results: The demand/reservation should not appear.

Changes

Sales order or line is canceled, closed or deleted.
Forecast entry is canceled or deleted.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms