Lead and Opportunity Number Sequencing Gaps (Doc ID 1941894.1)

Last updated on AUGUST 28, 2023

Applies to:

Goal

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.

LEAD_ID LEAD_NUMBER
1 1
3 3 21 21 41 41 44 44 45 45 46 46
65 65
66 66
69 69
71 71
72 72
73 73

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?
 

Solution

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