My Oracle Support Banner

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.

Symptoms

On : 12.2.6 version, Inventory Transactions

ACTUAL BEHAVIOR
---------------
Purchase order is purged but material is stuck in receiving area

STEPS

----------

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.

BUSINESS IMPACT
-----------------------
Due to this issue, users are seeing unwanted records in material workbench under receiving area although corresponding Purchase order is purged from system. 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.