Remove Purged Purchase Order Stuck in Receiving Subinventory for WMS Enabled Org
(Doc ID 2787778.1)
Last updated on AUGUST 17, 2021
Applies to:Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Inventory Transactions
Purchase order is purged but material is stuck in receiving area
A- Go to Material Workbench (Onhand) form and query for the item. Make sure receiving checkbox is checked
B - Find that there is an item in Receiving area
C- Go to Supply-Demand workbench and query the item. Do not find any record
D- Query against the item in MTL_SUPPLY (Ex : SELECT * FROM MTL_SUPPLY WHERE item_id= &item_id) and find that there is a record
E- Note down the PO number and query the PO (Purchasing -> Purchase Orders). Find that the PO does not exist in the form.
Due to this issue, users are seeing unwanted records in material workbench under receiving area although corresponding Purchase order is purged from system.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document