My Oracle Support Banner

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 JULY 13, 2020

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!


In this Document
Symptoms
Cause
Solution
 1. Identification Query
 2. Datafix
 3. Root cause
References


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