My Oracle Support Banner

Receiving Transactions form error: Lot uniqueness will be violated - update not allowed (Doc ID 1927018.1)

Last updated on JULY 13, 2021

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
INV_LOT_UNIQUENESS

Symptoms

When trying to deliver a Lot Controlled Item through the form 'Receiving Transactions' form-RCVTXERT, the following error occurs:

ERROR:
---------

INV_LOT_API_PUB: Item is lot controlled
INV_LOT_API_PUB: Lot Number Uniqueness check failed
INV_LOT_API_PUB: In g_exc_error -val_lot_attrUser-Defined Exception
INV_LOT_API_PUB: Program validate_lot_attr_in_param return E
INV_LOT_API_PUB: Program validate_lot_attr_in_param has failed with a user defined exception
INV_LOT_API_PUB: In g_exc_error User-Defined Exception
INV_RCV_INTEGRATION_PVT: Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2014-09-16 08:16:55:WMSINB-22469
INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES : |Lot numbers exist that have been used for different items
Lot uniqueness will be violated - update not allowed
|Expiration will not be considered for Lot expiration  type shelf life days

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
Cause
Solution


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