Considerations for Selecting Lot Number Uniqueness Control

Use the Inventory Organization Parameters page to specify if lot numbers should be unique for an item.

Select one of these lot number uniqueness control options to apply to the items in your inventory organization:

  • No uniqueness control

  • Across items

When you perform transactions, Oracle Inventory Management checks the lot number uniqueness control to generate lot numbers.

No Uniqueness Control

Choose this option if you don't want to establish lot number uniqueness. When selected, you can assign the same lot number to multiple items in the same organization and across organizations. Organizations that choose No uniqueness control can enter any lot as long as the lot doesn't exist in any organization that's set to Across items.

Across Items

Choose this option to control lot number uniqueness across items. With this option, you can assign a specific lot number to only one item in the same organization and across organizations. The application verifies that the lot number doesn't exist for any other item in any other organization.

This table shows what's allowed:

Organization

Uniqueness Setting

Item

Lot Number

M3

No control

INV-101

LOT2

M3

No control

INV-102

LOT2

M4

No control

INV-103

LOT2

M5

No control

INV-104

LOT2

This table shows what's not allowed:

Organization

Uniqueness Setting

Item

Lot Number

M3

No control

INV-101

LOT1

M3

No control

INV-102

LOT1

M4

No control

INV-103

LOT1

M5

No control

INV-104

LOT1

It is important to understand that when you use this setting for an organization, the same lot number can't exist for any other item in any other organization. However, it's possible to have the same item with the same lot number in multiple organizations.

Note: You can change the setting for the lot number uniqueness control at the inventory organization level if there are no open transactions.