Orphan LCM Shipments In Completed Status Missing data in Receiving Tables (RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS_INTERFACE or RCV_TRANSACTIONS)
(Doc ID 2687478.1)
Last updated on DECEMBER 03, 2021
Applies to:
Oracle Inventory Management - Version 12.2.6 and later Information in this document applies to any platform.
Symptoms
On : 12.2.6 version, Receiving Functions
Few LCM shipments are duplicate / orphan ones and need to be deleted.
Case 1: LCM Shipment shows 'COMPLETED' but no records in RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS_INTERFACE or RCV_TRANSACTIONS Case 2: LCM Shipment shows 'COMPLETED', records present in RCV_SHIPMENT_HEADERS, but not in RCV_SHIPMENT_LINES, RCV_TRANSACTIONS_INTERFACE or RCV_TRANSACTIONS
STEPS ----------------------- The issue can be reproduced at will with the following steps: * Duplicate LCM shipments for single PO that cannot be received.
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!
