Supply / Demand Form INVDVDSD Shows "Po In Receiving" Although Receiving is Complete (Doc ID 1432123.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Form:INVDVDSD.FMB - View Item Supply/Demand Information


Symptoms

Actual Behavior
Supply/Demand Form shows " PO in Receiving " although Receiving is complete for some transactions.

Another symptom is the " All Inventories Value Report " CSTRAIVR is showing some unexpected quantity in Receiving .

Expected Behavior
Supply/Demand Form should not show "PO in Receiving" when  Receiving is complete.

Steps
The issue can be reproduced at will with the following steps:
1. From the Inventory Super User Responsibility navigate to On Hand Availability / Supply Demand Form INVDVDSD
2. Enter item e.g. 80102
3. See records including
Date = 07.04.2011
Supply/Demand Type = PO in receiving
Identifier = 7407085
Quantity =,4

Generic datafix from <Note 1321193.1> Datafix to Remove Unwanted Supply From Supply Tables so to clean the mtl_supply table or <Note 601639.1> Generic Receiving Datafix Scripts and Root Cause Patches did not resolve this issue.

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