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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.