When using auto generated IDs, the sequence of newly created IDs are not incrementing as expected
SAP SuccessFactors Learning
Reproducing the Issue
- For example, create two Items in LMS with 'Auto Generate ID' option selected
- The IDs created are not in sequence. The first Item could start with 1000 and the next one could be 3000, and so on.
- 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 backed. They may also be in use by a different table within the database.
This has been confirmed by the Learning Product Management team that database sequence doesn't guarantee sequence without gaps (without performance impact).
2153445 - Learning: How to remove and disable Auto Generate ID option in Add New Item window?
Id sequence for Schedule offering, auto generated ID, sequencing, autogenerated, id numbers, course id, offering id, item id, program id, lms, sf, successfactors, learning , KBA , LOD-SF-LMS-DB , DB Data & Services , How To