SAP Knowledge Base Article - Public

2253841 - ID sequence number

Symptom

Auto generated ids are not created in sequence

Environment

SuccessFactors Learning Management System (LMS)

Reproducing the Issue

Create 2 Schedule offerings in LMS with Auto generated id's
=> the Id created are not in sequence. The first schedule offering could start with 1000 and the next one could be 3000 and so on.

Cause

  • Our application uses Oracle sequencing.
  • Sequences are special database objects that provide numbers in sequence for input to a table. 
  • It is possible that individual sequence numbers will appear to be skipped, because they were generated and used in a transaction that ultimately rolled back, or they are in use by a different table of the database.

Resolution

This has been confirmed by the LMS product management team that Oracle sequence doesn't guarantee sequence without gaps (without performance impact).

Additionnal information on Oracle sequencing can be found on the internet.

See Also

2153445 - Learning: How to remove and disable Auto Generate ID option in Add New Item window?

Keywords

Id sequence for Schedule offering, auto generated ID, oracle sequencing, autogenerated, id numbers, course id, offering id, item id, program id , KBA , LOD-SF-LMS-DB , DB Data & Services , Problem

Product

SAP SuccessFactors Learning 1511 ; SuccessFactors HCM Core 1508 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1508