ROI Error - WMSINB-20903 RCV_SPLIT_LOT_SERIAL_ERROR / Serial Quantity Mismatch (Doc ID 1922193.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

When using Receiving Open Interface ROI to process Receipts for some Serial Controlled items for Inter Organizations shipments, Receiving Transactions Processor (RTP) transactions complete in Error.

Inventory Debug log shows the following errors :

 
STEPS:
1.  Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI)   and mtl_serial_numbers_interface (MSNI).
2.  Run Receiving Transaction Processor RTP.
3.  See error.
4.  Example RCV11i output for the Intransit Shipment shows:

RCV_TRANSACTIONS_INTERFACE
INTERFACE_TRANSACTION_ID 156021
GROUP_ID 9104
TRANSACTION_TYPE RECEIVE
TRANSACTION_DATE 21-AUG-2014 00:00:00
PROCESSING_STATUS_CODE ERROR
PROCESSING_MODE_CODE BATCH
PROCESSING_REQUEST_ID 658653
TRANSACTION_STATUS_CODE PENDING
QUANTITY 2
UNIT_OF_MEASURE Each
ITEM_ID 71417
AUTO_TRANSACT_CODE DELIVER
SHIPMENT_HEADER_ID 107001
SHIPMENT_LINE_ID 111003
RECEIPT_SOURCE_CODE INVENTORY
FROM_ORGANIZATION_ID 270
TO_ORGANIZATION_ID 268
SOURCE_DOCUMENT_CODE INVENTORY
DESTINATION_TYPE_CODE INVENTORY
SHIPMENT_NUM SIM1145
HEADER_INTERFACE_ID 72001
USE_MTL_LOT 1
USE_MTL_SERIAL 5
VALIDATION_FLAG Y
ORG_ID 101

RCV_HEADERS_INTERFACE
HEADER_INTERFACE_ID 72001
GROUP_ID 9104
RECEIPT_SOURCE_CODE INVENTORY
SHIPMENT_NUM SIM1145
VALIDATION_FLAG N
PROCESSING_REQUEST_ID 658653
 
MTL_SERIAL_NUMBERS_INTERFACE
TRANSACTION_INTERFACE_ID FM_SERIAL_NUMBER TO_SERIAL_NUMBER PRODUCT_CODE PRODUCT_TRANSACTION_ID
704508                               SN9200                   SN9200                  RCV                  156021
704509                               SN9200                   SN9200                  RCV                  156021
704510                               SN1932                   SN1932                  RCV                  156021
704511                               SN1940                   SN1940                  RCV                  156021
704512                               SN9200                   SN9200                  RCV                  156021
704513                               SN9200                   SN9200                  RCV                  156021

PO_INTERFACE_ERRORS
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.
REQUEST_ID 658653
ERROR_MESSAGE_NAME RCV_SPLIT_LOT_SERIAL_ERROR
TABLE_NAME RCV_TRANSACTIONS_INTERFACE
BATCH_ID 9104
INTERFACE_HEADER_ID 72001
INTERFACE_LINE_ID 156021

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.