My Oracle Support Banner

Lot Generation With Uniqueness Across Items Repeats Sequence Number (Doc ID 552354.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Inventory Management - Version 11.5.2 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

When Lot Number generation is setup with Control "Across Items" and Lot Number Generation at "Organization Level" with prefix specific for each organization (O01, O02, O03, etc ...).
So the lot numbers could be in each organization for a specific item like:

Organization O01 => Lots: O01-0001, O01-0002,O01-0003,O01-0004,O01-0005, etc.
Organization O02 => Lots: O02-0001, O02-0002,O02-0003,O02-0004,O02-0005, etc.

When performing a transaction and clicking in "Generate" button while entering lots in the different organizations, the lot sequence is not being repeated, as example:

Enter transaction for org O01, generate the lot and get lot O01-0001, then enter a transaction for org O02, and the system generates the lot O02-0002, then, if another transaction is entered for organization O01 it will generate the lot O01-0003 ... why is it not repeating numbers in the number sequence?

NOTE: The system allows entering the lot numbers repeating sequence number (but with prefix of specific organization), but when generating the lot number automatically the lots are generated without repeating numbers.
 

Solution

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


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