Auto generated ids are not created in sequence
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.
- 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.
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.
2153445 - Learning: How to remove and disable Auto Generate ID option in Add New Item window?
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