Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
How to remove orphan and negative quantities from the supply tables (MTL_SUPPLY & RCV_SUPPLY)?
This issue can occur due to cases such as: an Internal Requisition line being created for a quantity of 320 and the Sales Order being created for a quantity of 160 (as the ordered quantity which is subsequently shipped and the sales order having been closed). In this case the remaining quantity of 160 will show as REQ type supply in MTL_SUPPLY.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms