Lead and Opportunity Number Sequencing Gaps
(Doc ID 1941894.1)
Last updated on MARCH 05, 2019
Applies to:Oracle Sales - Version 126.96.36.199 and later
Information in this document applies to any platform.
On : 12.1.3 version, Lead Management
We have noticed that there is no continuity in the LEAD_ID/LEAD_NUMBER generated by the system when we create a lead or opportunity. It continues to increase by 1 for some time, and then suddenly will increase by couple of thousand & then back to increase by 1.
3 3 21 21 41 41 44 44 45 45 46 46
We would like to understand the logic for Lead and Opportunity Numbering. Also, From where it is controlled ? Is there a patch to fix the sequential numbering?
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