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 JANUARY 11, 2017

Applies to:

Oracle Landed Cost Management - Version 12.1.2 and later
Oracle Purchasing - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2014***

Symptoms

On : 12.1.1

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

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