ASN Loading File Error An Error Occurred While Trying To Split Lot/serial Lines. WMSINB-20903 ROI (Doc ID 2090598.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

During ASN file uploading, if the item is serial control for PO error occurs

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

1. ASN File upload -> Serial controlled item
Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI) mtl_serial_numbers_interface (MSNI)

2. Run RVCTP

3. Inventory debug log file shows

[07-DEC-15 09:36:16] po.plsql.RCV_ROI_HEADER.RCV_ROI_HEADER.66: ASN_TYPE ASN
[07-DEC-15 09:36:16] po.plsql.RCV_ROI_HEADER.RCV_ROI_HEADER.416: In Vendor Procedure
...
[07-DEC-15 09:36:17] po.plsql.RCV_ROI_HEADER.RCV_ROI_HEADER.233: asn_tyoe ASN
[07-DEC-15 09:36:17] po.plsql.RCV_ROI_HEADER.RCV_ROI_HEADER.234: shipment_num S1258T
[07-DEC-15 09:36:17] po.plsql.RCV_ROI_HEADER.RCV_ROI_HEADER.235: receipt_header_id -999
...
[07-DEC-15 09:36:18] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.1724: ### po_header_id : 18021632
...
[07-DEC-15 09:36:18] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.1726: ### po_line_id : 16872257
...
[07-DEC-15 09:36:20] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4797: Converted PO UOM Quantity 2
[07-DEC-15 09:36:20] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4798: PO UOM Box250
...
[07-DEC-15 09:36:21] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): split_lot_serial:010: Entry Stamp :2015-12-07 09:07:21
[07-DEC-15 09:36:21] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): split_lot_serial: new_interface_trx_id = 11472627
[07-DEC-15 09:36:21] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL:l_total_split_qty:2
[07-DEC-15 09:36:21] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL:l_total_lot_qty:0
[07-DEC-15 09:36:21] INV_TRX_MGR: *** Initializing log ***
[07-DEC-15 09:36:21] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL:l_total_serial_qty:2
[07-DEC-15 09:36:22] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: Entering get_primary_uom_code...
[07-DEC-15 09:36:22] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: p_inventory_item_id => 4514294
[07-DEC-15 09:36:22] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: p_organization_id => 15889
[07-DEC-15 09:36:22] INV_RCV_CACHE.GET_PRIMARY_UOM_CODE: x_prim_uom_code (DB) => EA
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: Entering convert_qty...
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: p_inventory_item_id => 4514294
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: p_from_uom_code => BX2
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: p_to_uom_code => EA
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: p_from_qty => 2
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: p_precision => 5
[07-DEC-15 09:36:22] INV_RCV_CACHE.CONVERT_QTY: x_to_qty => 500

[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): split_lot_serial:075.6: total_split_qty : 500
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL : to_organization_id:15889
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL : item_id:4514294
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL : uom_code:BX2
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): SPLIT_LOT_SERIAL - Execution Error::WMSINB-20903:2015-12-07 09:07:22
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): STACKED ERROR MESSAGES :
[07-DEC-15 09:36:22] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.5 $): inv_rcv_intergration_pvt.split_lot_serial returned error
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9326: After split_lot_serial Api
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9333: split_lot_serial Api has errors
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9338: return value: false
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9341: x_return_status: E
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9342: x_msg_count:
[07-DEC-15 09:36:22] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.9343: x_msg_data: WMSINB-20903
[07-DEC-15 09:36:22] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
[07-DEC-15 09:36:22] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214: set error message token = RCV_SPLIT_LOT_SERIAL_ERROR
[07-DEC-15 09:36:22] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215: error stack from call to set_error_message
[07-DEC-15 09:36:22] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_ERROR_PKG
[07-DEC-15 09:36:22] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call

4) Receiving data collection output shows

RCV_HEADERS_INTERFACE
Header_Interface_Id 19950228
Group_Id 6445977
Receipt_Source_Code VENDOR
Asn_Type ASN
Transaction_Type NEW
Shipment_Num S1258T
Receipt_Num
Receipt_Header_Id 15762576
Ship_To_Organization_Id 15889
Validation_Flag N
Processing_Request_Id 198656067


RCV_TRANSACTIONS_INTERFACE
Interface_Transaction_Id 11472627
Group_Id 6445977
Transaction_Type SHIP
Transaction_Date 12/07/2015 09:35
Processing_Status_Code ERROR
Processing_Mode_Code BATCH
Processing_Request_Id 198656067
Transaction_Status_Code PENDING
Quantity 2
Unit_Of_Measure Box250
Item_Id 4514294
Item_Description XYZ
Uom_Code BX2
Auto_Transact_Code SHIP
Shipment_Header_Id 15762576
Shipment_Line_Id
Primary_Quantity 500
Primary_Unit_Of_Measure Each
Receipt_Source_Code VENDOR
To_Organization_Id 15889
Source_Document_Code PO
Po_Header_Id 18021632
Po_Line_Id 16872257
Po_Line_Location_Id 18588761
Destination_Type_Code RECEIVING
Shipment_Num S1258T
Expected_Receipt_Date 12/08/2015 05:46
Vendor_Lot_Num LOT67
Source_Doc_Quantity 2
Source_Doc_Unit_Of_Measure Box250
Use_Mtl_Lot 1
Use_Mtl_Serial 5
Header_Interface_Id 19950228
Item_Num XYZ H/H
Document_Num 612802
Document_Line_Num 1
To_Organization_Code S1
Document_Shipment_Line_Num 1
Validation_Flag Y
Quantity_Shipped 2
Interface_Available_Qty 2
Interface_Transaction_Qty 500
License_Plate_Number MTN49055683LPN
Lpn_Group_Id 6445978
Order_Transaction_Id 11472627
Org_Id 5052

PO_INTERFACE_ERRORS
Interface_Type RCV-856
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 6445977
Interface_Header_Id 19950228
Interface_Line_Id 11472627

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.