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

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.

Symptoms

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)

Changes

None

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