Case Management - CM_CASES_SEQ - Sequences Rapidly Increasing (Doc ID 2822357.1)

Last updated on NOVEMBER 23, 2021

Applies to:

Goal

We have set increment by value to 1 and cache to 100000 for sequence CM_CASES_SEQ. However, we see that sequence value is getting increased rapidly and randomly and not following the pattern of increment only by increment value.

Even though this is not an issue, we fear that something is not correct.

Below the sequence script

CREATE SEQUENCE OFSAAFCCM.CM_CASES_SEQ MINVALUE 1 MAXVALUE 99999999999999999999 INCREMENT BY 1 START WITH 379304087 CACHE 100000 NOORDER CYCLE NOKEEP NOSCALE GLOBAL ;

What happens is, it creates the values like 379304087, 379304088, 379404076 etc.
 

Solution

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