Unable To Receive Via ROI Intransit Inter Org Shipment An Error Occurred Trying To Split Lot / Serial RCV_SPLIT_LOT_SERIAL (Doc ID 2056108.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

When using Receiving Open Interface ROI to deliver Inter Organizations Transfers for Lot and Serial controlled items, Receiving Transaction Processor completes normal but Transaction Status Screen shows below error message;

Steps
The issue can be reproduced at will with the following steps:

a. Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI), mtl_serial_numbers_interface (MSNI) and mtl_transaction_lots_interface (MTLI)  

b. Run RVCTP Receiving Transaction Processor.

c. See records in error:

In RCV_HEADERS_INTERFACE RHI table
HEADER_INTERFACE_ID 17139342
GROUP_ID 885619
RECEIPT_SOURCE_CODE INVENTORY 
SHIPMENT_NUM ITW11
RECEIPT_HEADER_ID 13684931
FROM_ORGANIZATION_ID 1227
SHIP_TO_ORGANIZATION_ID 234 

In RCV_TRANSACTIONS_INTERFACE RTI table
INTERFACE_TRANSACTION_ID 23593264
GROUP_ID 885619
TRANSACTION_TYPE RECEIVE
PROCESSING_STATUS_CODE ERROR
QUANTITY 20
ITEM_ID 1079146
AUTO_TRANSACT_CODE DELIVER
SHIPMENT_HEADER_ID 13684931
RECEIPT_SOURCE_CODE INVENTORY
FROM_ORGANIZATION_ID 1227
TO_ORGANIZATION_ID 234
SOURCE_DOCUMENT_CODE INVENTORY
DESTINATION_TYPE_CODE INVENTORY
SUBINVENTORY Goods
SHIPMENT_NUM ITW11
HEADER_INTERFACE_ID 17139342
USE_MTL_LOT 2
USE_MTL_SERIAL 5
VALIDATION_FLAG Y 
ORG_ID 81

MTL_SYSTEM_ITEMS MSI table
Inventory_Item_Id 1079146
Lot_Control_Code 2
Serial_Number_Control_Code 5

PO_INTERFACE_ERRORS PIE table
Column_Name INTERFACE_TRANSACTION_ID
Error_Message Error: An error occurred while trying to split lot/serial lines. Please look into inventory log for more details.
Error_Message_Name RCV_SPLIT_LOT_SERIAL_ERROR
Table_Name RCV_TRANSACTIONS_INTERFACE
Batch_Id 885619
Interface_Header_Id 17139342
Interface_Line_Id 23593264

Changes

Cause

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