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 later
Information 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

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