Generate Serial Numbers: Creates Duplicates Even With Organization Uniqueness
(Doc ID 2051084.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Inventory Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.
Serial generation duplicates serials intermitenly.
The serial number uniqueness setup is set at Organization level so the same serial must not be assigned to multiple items but finding same serial for 2 items.
See organization setup indicates serials are unique in the organization and generated at the organization level:
Serial generation should not create duplicate serials in an organization when serial uniqueness prevents duplication.
* Cannot replicate at will.
1. Navigate to Inventory > Onhand > Generate Serials.
2. Sometimes duplicate serials are generated.
* See duplicates via onhand:
1. Navigate to Inventory>Onhand, availability>Query the serial number
2. Sometimes -- Find 2 items linked to same serial.
Delays shipments and causes user confusion.
Users cannot get the expected result when setting Serial number uniqueness: Within Organization;
Continually must correct data via a datafix from Oracle Support.
Happens about 1 time per month, saw 3 duplicate serials in last 3 months.
Workaround to correct data but want to avoid data corruption.
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
|A. For data issues:
|B. To avoid the issue: