My Oracle Support Banner

In Pre Receiving LCM Org Ship Records Stuck In RHI / RTI RCV_DELIV_DATE_INVALID / RCV_SHIP_DATE_INVALID (Doc ID 1333933.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Landed Cost Management - Version 12.1.2 to 12.1.3 [Release 12.1]
Oracle Purchasing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In LCM Pre Receiving Organization

Find it is unable to receive in Inventory LCM Shipment for standard Purchase Order as LCM SHIP records are stuck in error in RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE tables.

After trying to reprocess stuck records following instructions of <Note 605300.1>, Rcv11i output  from <Note 402245.1> for the purchase order shows:

ERROR
--------
RCV_HEADERS_INTERFACE
Processing_Status_Code ERROR


RCV_TRANSACTIONS_INTERFACE
Processing_Status_Code ERROR 
Processing_Mode_Code BATCH
Transaction_Status_Code PENDING 
Interface_Source_Code LCM 

PO_INTERFACE_ERRORS
Column_Name SHIPPED_DATE
Error_Message Error: The expected delivery date [06-MAR-2011] cannot be earlier than the ship date.
Error_Message_Name RCV_DELIV_DATE_INVALID
Table_Name RCV_HEADERS_INTERFACE
Error_Message Error: Ship date 07-MAR-2011 is missing or invalid.
Error_Message_Name RCV_SHIP_DATE_INVALID
Table_Name RCV_HEADERS_INTERFACE

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
References


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