My Oracle Support Banner

Error When Running API to Generate Lot Numbers Parallel For Different Items Across Organizations (Doc ID 1637720.1)

Last updated on MAY 21, 2021

Applies to:

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


We are using the Lot number generation API - INV_LOT_API_PUB.Auto_gen_lot to generate lot numbers based on prefix on the Organization Items form.
Multiple sessions are running the same API for different items in different organizations to generate lots.

We have confirmed that no users are working on the Organization Items form but, we are seeing the error -
Lot number can not be generated as item is being modified in other session.

Organization parameter - Lot number uniqueness is set to "Unique across items" (mtl_parameters.lot_number_uniqueness = 1) , and Lot number generation is set "At item level" (mtl_parameters.lot_number_generation = 2)




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

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