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

Last updated on MARCH 31, 2017

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.

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