Error: WMSINB-22192:Lot/Serial Validation Failed While Receiving An Inter Org Shipment (Doc ID 2244433.1)

Last updated on AUGUST 23, 2023

Applies to:

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

Symptoms

When attempting to receive remaining quantity against an Inter Org Shipment, receive transaction ( with auto_transact_code deliver ) stuck in interface with the following error.

ERROR

WMSINB-22192:Lot/Serial Validation Failed. Please check log for details.

Inventory Debug Log shows below details:

[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: RTI_ID = : 7504898
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): move_lot_serial_info - Number of MTLT Inserted =: 0 with product transaction_id = 7504898
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_temp (move_lot_serial_info)
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): move_lot_serial_info - Number of MSNT Inserted =: 0 with product transaction_id =7504898
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: MOVE_LOT_SERIAL_INFO done :WMSINB-21949
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: RTI query done :WMSINB-21964
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: TRANSACTION TYPE: RECEIVE: WMSINB-21964
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :WMSINB-22021
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): INVCONV, Removing OPM specific fork :WMSINB-22021
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: Lot Control Code:2
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:1
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: Lot Status Enabled:Y
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: Lot Controlled :WMSINB-22076
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: LOT NUMBER: LOT#1: WMSINB-22087
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): Assigning values fetched from MTLT to l_mln_recWMSINB-22087
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: LOT PRIMARY QUANTITY: 55: WMSINB-22087

MAR-17 10:16:43] INV_RCV_CACHE.CONVERT_QTY: x_to_qty => 55
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: LOT EXISTS: 1 : WMSINB-22106
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): INVCONV, Removing OPM specific fork and selecting parent lot number :WMSINB-22143:
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: SOURCE DOCUMENT CODE: INVENTORY : WMSINB-22143
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): INVCONV, validating for parent lot :WMSINB-22143
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: LOT NOT ENTERED ON PARENT: WMSINB-22155
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): VALIDATE_LOT_SERIAL_INFO: LOT CONTROL FROM ORG: 2 : WMSINB-22161
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2017-03-14 10:14:43:WMSINB-22192
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.119 $): STACKED ERROR MESSAGES :
[14-MAR-17 10:16:43] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.11 $): validate_lot_serial_info: private API new debug
[14-MAR-17 10:16:43] po.src.rvtp.rvtpt.RVTPT.C.4005: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint

STEPS

1.Navigate to Purchasing Responsibility -> Receiving -> Receipts

2.From Find Expected Receipts form, query by Shipment Number

3.From Receipts form, enter required details and click on Save.