ASNs Have Active Supply In Mtl_supply No Data In RCV_shipment_headers, Rcv_shipment_lines
(Doc ID 2334216.1)
Last updated on NOVEMBER 30, 2017
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Receiving Functions
ACTUAL BEHAVIOR
---------------
ASNs have active supply in mtl_supply but no data in RCV_shipment_headers and rcv_shipment_lines
ASN records are deleted from RCV_shipment_headers (RSH) and rcv_shipment_lines(RSL), however the records still exists in mtl_supply having reference of Shipment_header_id and shipment_lines which are deleted from RSH and RSL.
EXPECTED BEHAVIOR
-----------------------
Records no longer exist in mtl_supply having reference of Shipment_header_id and shipment_lines after they are deleted from RSH and RSL.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create the receipt at this point and will process ASN (shipment number 645088).
2. Run the ASN import for the shipment number processed
3. Note the records are deleted from RCV_shipment_headers (RSH) and rcv_shipment_lines(RSL)
4. Note, however the records still exists in mtl_supply having reference of Shipment_header_id and shipment_lines which are deleted from RSH and RSL.
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 |