Cannot Receive PO After LCM Shipment FRM-40212: SHIPMENT_NUM Records Stuck In RTI PO_SRCE_ORG_OUT_OF_DEV (Doc ID 1463065.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

In OPM LCM enabled Pre-receiving organization, Purchase order cannot be received after creating the Landed Cost Shipment.
 
When searching for LCM Shipment on Find Expected Receipts  RCVRCERC form the following error message occurs:

FRM-40212: Invalid value for field SHIPMENT_NUM.

Examination of the RCV11i output from <Note 402245.1>  shows the SHIP record is stuck in RTI

RCV_TRANSACTIONS_INTERFACE table

Interface_Transaction_Id
Transaction_Type SHIP
Processing_Status_Code ERROR
Processing_Mode_Code BATCH
Transaction_Status_Code PENDING

 
In RCV_HEADERS_INTERFACE

Header_Interface_Id
Processing_Status_Code ERROR
Receipt_Source_Code VENDOR
Asn_Type LCM
Transaction_Type NEW
Shipment_Num 638-3.1
Ship_To_Organization_Id 82
Validation_Flag Y

 
In PO_INTERFACE_ERRORS

Column_Name Secondary Parameter
Error_Message Error: The Transaction and Secondary quantities specified are out of deviation in the Source Organization.
Error_Message_Name PO_SRCE_ORG_OUT_OF_DEV
Table_Name RCV_TRANSACTIONS_INTERFACE

 
  STEPS
  -------
  1. Create a dual UOM controlled Item        
  2. Create a Purchase Order for the Item
  3. In Landed Cost Management responsibility Create a shipment for the PO
  4. Change Transaction Qty, Secondary Qty, Transaction UOM values
  5. Navigate to Inventory - Receipts.
  6. From Source Type select "LCM" and enter Shipment Number.
  7. Shipment number cannot be found and the receiving process cannot be done.
  Get FRM-40212: Invalid value for field SHIPMENT_NUM.  
  8. In Receiving Transactions Summary lines are pending.

Cause

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