SAP Knowledge Base Article - Public

2756775 - Opportunity IDs are not in Sequence or There Are Gaps in Document IDs

Symptom

On Creating the new opportunity, Document IDs generates are not in chronological order.

You may also see gaps in opportunity ids, even you have not deleted any document.

Environment

SAP Cloud For Customer

Reproducing the Issue

  1. Go to the Sales work center
  2. Go to the Opportunities view
  3. Select the button New and create new opportunity
  4. Enter all mandatory fields
  5. Save and Open
  6. The opportunity id generates is XYZ (where XYZ represents opportunity id 1001)
  7. Repeat the same step 3 and 5 to create another new opportunity
  8. Now opportunity id generates is UVW (Where UVW represents opportunity id 998)

You will see opportunity id UVW is created after Opportunity id XYZ but have lesser number.

Example Opportunities Creation:
Opportunity XYZ is created on 19th February.
Opportunity UVW is created on 20th February.

You may also see gaps in opportunity ids, even you have not deleted any document.

For Example: An opportunity is created in the system which has id 100 and very next opportunity id 103

Cause

Every Aplication server buffers a batch of 10 numbers. So, depending on which application server the request is processed. The system makes these numbers available to the application server in question. The following numbers can then be taken directly from the application server buffer. New numbers are not used in the database until the application server buffer has been used up. As there are more than one application servers available, the numerical sequence will not reflect the (chronological) insert sequence because the numbers are buffered separately on the individual hosts.

Resolution

This is the expected behavior of the system.

Keywords

Id Missing, Number range, Sequence , KBA , LOD-CRM-OPP , Opportunity Management , How To

Product

SAP Cloud for Customer add-ins all versions