Error When Running API to Generate Lot Numbers Parallel For Different Items Across Organizations
Last updated on MARCH 08, 2017
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)
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