ROI Errors WMSINB-20903 RCV_SPLIT_LOT_SERIAL_ERROR / Serial Quantity Mismatch

(Doc ID 1922193.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When using Receiving Open Interface ROI to process receipts for some serial controlled items for Inter organizations shipments for some transactions Receiving Transactions Processor RTP completes with Errors.

Inventory Debug log shows the following errors :

[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9667:       Interface Id 156021
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10064:       l_ls_table.COUNT: 1
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10069:       Calling split_lot_serial
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:010: Entry Stamp :2014-08-21 12:21:06
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial: new_interface_trx_id = 156021
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL:l_total_split_qty:2
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL:l_total_lot_qty:0
[21-AUG-14 12:09:06] INV_TRX_MGR: *** Initializing log ***
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL:l_total_serial_qty:6
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: Entering get_primary_uom_code...
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  p_inventory_item_id    => 71417
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  p_organization_id      => 268
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  x_prim_uom_code (DB)     => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY: Entering convert_qty...
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_inventory_item_id => 71417
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_from_uom_code     => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_to_uom_code       => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_from_qty          => 2
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_precision         => 5
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  x_to_qty            => 2
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.4: Serial Quantity Mismatch
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.5: total_serial_qty : 6
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: Entering get_primary_uom_code...
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  p_inventory_item_id    => 71417
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  p_organization_id      => 268
[21-AUG-14 12:09:06] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE:  x_prim_uom_code (Cache) => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY: Entering convert_qty...
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_inventory_item_id => 71417
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_from_uom_code     => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_to_uom_code       => EA
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_from_qty          => 2
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  p_precision         => 5
[21-AUG-14 12:09:06] INV_RCV_CACHE.CONVERT_QTY:  x_to_qty            => 2
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.6: total_split_qty : 2
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL : to_organization_id:268
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL : item_id:71417
[21-AUG-14 12:09:06] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL : uom_code:EA

[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10081:       After split_lot_serial Api
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10088:       split_lot_serial Api has errors
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10093:       return value: false
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10096:       x_return_status: E
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10097:       x_msg_count:
[21-AUG-14 12:09:06] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10098:       x_msg_data: WMSINB-20903
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin:       v--------Procedure Started-----------v
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214:         set error message token = RCV_SPLIT_LOT_SERIAL_ERROR
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215:         error stack from call to set_error_message
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:         Current Calling Stack = ?                   RVTBM.C             RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION 
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71:         logging error An error occurred while trying to split lot/serial lines. Please look into inventory log for more details. on column INTERFACE_TRANSACTION_ID
[21-AUG-14 12:09:06] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.36:         error stack from call to po_interface_call

Steps

a. Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI)   and mtl_serial_numbers_interface (MSNI).
b. Run Receiving Transaction Processor RTP.
c. See error.
d. Rcv11i output from <Note 402245.1> 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms