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 processed3. 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.