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 JULY 02, 2024
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]
Oracle Inventory Management - Version 12.1.3 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 |