Case Management - CM_CASES_SEQ - Sequences Rapidly Increasing
(Doc ID 2822357.1)
Last updated on NOVEMBER 23, 2021
Applies to:Oracle Financial Services Enterprise Case Management - Version 8.0.5 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document