My Oracle Support Banner

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

Last updated on FEBRUARY 08, 2019

Applies to:

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

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

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


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