Shipment Supply Data Exists After Full Correction to Over Received ASN (Data Fix) (Doc ID 1204303.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Form:INVDVDSD.FMB - View Item Supply/Demand Information
Report:CSTRITVR.RDF - Intransit Value Report


Symptoms

Intransit Shipments are still visible even though the associated Purchase Order has been Closed.
This occurs after a negative correction is performed against an ASN that was over-received.

Steps
The issue can be reproduced at will with the following steps:

1) Navigate to Receipt Transaction Summary form
For Receipt Num 123456 / PO Number 111050 see the following transactions
Receive   Quantity = 120
Receive   Quantity = 350
Correct    Quantity = -350 
Deliver    Quantity = 120

2) Navigate to Purchase Order Summary Shipments form
See for PO Number 111050
Quantity = 120
Quantity Due = 0
Quantity Received = 120

3) Navigate to Supply/Demand Detail form INVDVDSD
for  Item , still see 1 record
Date                  Supply / Demand Type   Identifier   Quantity
28-OCT-2014      Intransit Shipment         111050     350


4) Rcv11i output from <Note 402245.1> shows

RCV_SHIPMENT_HEADERS
Shipment_Header_Id 137939563
Receipt_Source_Code VENDOR
Shipment_Num 10166693
Receipt_Num 123456
Asn_Type ASN
Ship_To_Org_Id 142

RCV_SHIPMENT_LINES
Shipment_Line_Id 155143769
Shipment_Header_Id 137939563
Quantity_Shipped 120
Quantity_Received 120
Item_Id 4624639
Shipment_Line_Status_Code FULLY RECEIVED
Source_Document_Code PO
Po_Header_Id 46128 
Po_Line_Location_Id 2055133
To_Organization_Id 142
Asn_Line_Flag Y

RCV_TRANSACTIONS
Transaction_Id Transaction_Type Transaction_Date Quantity Unit_Of_Measure Shipment_Header_Id  Destination_Type_Code Parent_Transaction_Id Po_Header_Id 
231544277 RECEIVE                  10-21-2014           120      DB                     137939563              RECEIVING                    -1                             46128 
231544278 RECEIVE                  10-21-2014           350      DB                     137939563              RECEIVING                    -1                             46128
231544298 CORRECT                10-21-2014          -350      DB                     137939563              RECEIVING                    231544278                46128
231544550 DELIVER                  10-21-2014           120      DB                     137939563              INVENTORY                    231544277                46128

MTL_SUPPLY
Supply_Type_Code SHIPMENT
Supply_Source_Id 155143769
Po_Header_Id 46128 
Po_Line_Location_Id 2055133
Shipment_Header_Id 137939563
Shipment_Line_Id 155143769
Rcv_Transaction_Id
Item_Id 4624639
Quantity 350
Unit_Of_Measure DB
To_Organization_Id 142


PO_LINE_LOCATIONS_ALL
Line_Location_Id  2055133
Po_Header_Id 46128  
Quantity 120
Quantity_Received 120
Qty_Rcv_Tolerance 5
Qty_Rcv_Exception_Code NONE
Quantity_Shipped 350

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