Item Supply/Demand Form INVDVDSD Does Not Show Supply For Some Purchase Orders (Doc ID 1504490.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Oracle Purchasing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

In some cases, the form INVDVDSD does not include supply for some purchase
orders although these POs are not closed and they have records in MTL_SUPPLY
table with Supply_Type_Code =PO.

The problem apparently occurs for some specific items.
 

Steps
The issue can be reproduced at will with the following steps: (Note: Data listed below are Customer specific)
 
1) Inventory / On Hand, Availability / Item Supply/Demand INVDVDSD form
On Find Supply Demand Item form
Search for
Item -> GBMN
Cutoff Date  -> Null
Include  -> All subinventories
 
Supply/Demand Details (WTS) form shows many Work Orders records but no records for Purchase Orders


2) Purchasing Purchase >Orders / Purchase Order Summary
Find Purchase Order form
Search for Item -> GBMN
There are many PO lines
for instance PO Number 3252 Line 1 Quantity 16
Promised date is 22.01.2013


3) Output of the Receiving Data Collection Script for the PO 3252 shows
 
PO_HEADERS_ALL
Po_Header_Id 68527
Segment_1 3252
Type_Lookup_Code STANDARD
Org_Id 82
Closed_Code OPEN
 
PO_LINES_ALL
Po_Line_Id 93771
Po_Header_Id 68527
Line_Num 1
Item_Id 1632463
Unit_Meas_Lookup_Code M
Quantity 16
 
PO_LINE_LOCATIONS_ALL
Line_Location_Id 105216
Po_Header_Id 68527
Po_Line_Id 93771
Quantity 16
Quantity_Received 0
Need_By_Date 02/01/2013 00:00
Promised_Date 01-22-2013 00:00
Last_Accept_Date 01-22-2013 00:00
Approved_Flag Y
Ship_To_Organization_Id 82
Shipment_Num 1
Closed_Code OPEN
 
PO_DISTRIBUTIONS_ALL
Po_Distribution_Id 107962
Po_Header_Id 68527
Po_Line_Id 93771
Line_Location_Id 105216
Quantity_Ordered 16
Quantity_Delivered 0
Destination_Type_Code INVENTORY
Destination_Organization_Id 82

MTL_SUPPLY
Supply_Type_Code PO
Supply_Source_Id 107962
Po_Header_Id 68527
Po_Line_Id 93771
Po_Line_Location_Id 105216
Po_Distribution_Id 107962
Item_Id 1632463
Quantity 16
Unit_Of_Measure M
Receipt_Date 01-22-2013 00:00
Need_By_Date 01-22-2013 00:00
Expected_Delivery_Date 01-22-2013 00:00
Destination_Type_Code INVENTORY
To_Organization_Id 82
 
so the supply should appear

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