Duplicate PO Shipment (SHIPMENT_LINE_STATUS_CODE = FULLY RECEIVED) Is Created by Receipt Against ASN Shipment, ASN Shipment Remains EXPECTED (Doc ID 2674843.1)

Last updated on MAY 28, 2020

Applies to:

Symptoms

Actual Behavior
There are mass of quantity ASN shipment/receipt data interface by ROI(RCV_TRANSACTIONS_INTERFACE).
After receipt was received completely, check RCV_SHIPMENT_HEADER/RCV_SHIPMENT_LINES/RCV_TRANSACTIONS.
Then, three are duplicate shipment line(RCV_SHIPMENT_LINES) data for 1 receipt.
One shipment line status is expected, another shipment line status is fully receive.

Expected Behavior
Want to avoid dummy shipment line(RCV_SHIPMENT_LINES) for status is expected when receipt was received completely.

Steps to Reproduce

1. There are 2 PO. One PO for waiting receipt, Another PO for waiting to create new ASN shipment.
   PO Number 11 for receipt
   line 1 qty 1
   line 2 qty 1
   PO Number 22 for ASN shipment
   line 1 qty 1
2. Create ASN Shipment for PO Number 11, and run Receiving Transaction Processor,
   then there is RCV_SHIPMENT_HEADER/RCV_SHIPMENT_LINES data for SHIPMENT_NUM = 'DEMO-ASN-11'
3. Create Receiving interface data RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE for 1st PO Number 11 for 1st line.
4. Create Shipment interface data RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE for 2nd PO Number 22 for 1 line for SHIPMENT_NUM = 'DEMO-ASN-22'
5. Create Receiving inerface data RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE for 1st PO Number 11 for 2nd line.
   NOTE: When create this data need to match same GROUP_ID, HEADER_INTERFACE_ID for 1st PO Number 11 and 1st line.
   Finally below case data created in RCV_TRANSACTIONS_INTERFACE.
   
   

   RCV_HEADERS_INTERFACE

   HEADER_INTERFACE_ID	GROUP_ID	ASN_TYPE	TRANSACTION_TYPE	AUTO_TRANSACT_CODE	SHIPMENT_NUM	RECEIPT_HEADER_ID
   11	999		NEW	DELIVER	DEMO-ASN-11	12345
   22	111	ASN	NEW	SHIP	DEMO-ASN-22

   
   
   

   RCV_TRANSACTIONS_INTERFACE

   INTERFACE_TRANSACTION_ID	GROUP_ID	TRANSACTION_TYPE	HEADER_INTERFACE_ID	SHIPMENT_HEADER_ID	SHIPMENT_LINE_ID
   1	999	RECEIVE	11	123	1111
   2	111	SHIP	22
   3	999	RECEIVE	11	123	2222

6. To run Receiving Transaction Processor with Group ID is NULL
7. To check RCV_SHIPMENT_HEADER/RCV_SHIPMENT_LINES
   Then, there are there are duplicate PO shipment (SHIPMENT_LINE_STATUS_CODE = FULLY RECEIVED) is created by receipt against ASN shipment, ASN shipment remains EXPECTED.
   
   

   RCV_SHIPMENT_HEADERS

   SHIPMENT_HEADER_ID	SHIPMENT_NUM	RECEIPT_NUM
   123	DEMO-ASN-11	111111
   456	DEMO-ASN-22

   
   
   

   RCV_SHIPMENT_LINES

   SHIPMENT_LINE_ID	SHIPMENT_HEADER_ID	LINE_NUM	QUANTITY_RECEIVED	SHIPMENT_LINE_STATUS_CODE
   1111	123	1	1	FULLY RECEIVED
   2222	123	2	0	EXPECTED
   3333	123	3	1	FULLY RECEIVED
   4444	456	1	0	EXPECTED

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.