I have 3 sequence in one user
some time sequence next value skip some numbers
like if last sequence no was 10 it generate next value 21
some time only one no skip ...like last no 21 ... next value 23
all 3 sequence are getting some problem.
I created sequence
Sequence 1 :-
create sequence SJV
minvalue 1
maxvalue 9999999
start with 1
increment by 1
Order;
Sequence 2 :-
create sequence JV
minvalue 1
maxvalue 9999999
start with 1
increment by 1
Order;
Sequence 3 :-
create sequence voucherno
minvalue 1
maxvalue 9999999
start with 1
increment by 1
Order;