ROI Error - WMSINB-20903 RCV_SPLIT_LOT_SERIAL_ERROR / Serial Quantity Mismatch
(Doc ID 1922193.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Relevancy Check: 01/02/19
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
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 |
Changes |
Cause |
Solution |
References |