Why Does A Closed Requisition Record Show In Supply Demand Form (Doc ID 1584474.1)

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.

Goal

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.

Solution

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