Customer Number Skips When Automatic Customer Numbering On

While creating new customers the Customer Number is not generated sequentially, and often has gaps of 20


Solution :

1) Run the following sql.

SELECT sequence_owner ,sequence_name, increment_by, cache_size ,last_number
FROM dba_sequences seq
WHERE seq.sequence_name like 'HZ_ACCOUNT_NUM_S' ;

2)
If the cache is not = 0 set it to zero using the following alter statement :

ALTER SEQUENCE AR.HZ_ACCOUNT_NUM_S nocache;

COMMIT;

Ref:  397212.1