Transfer Number Skips in Bank Account Transfers

http://cashmanagementcm.blogspot.com/2017/01/transfer-number-skips-in-bank-account.html

a.
alter Sequence CE.CE_PAYMENT_TRANSACTIONS_S NOCACHE;

b.
select min_value, max_value,increment_by, cache_size, last_number from all_sequences where
sequence_name like 'CE_PAYMENT_TRANSACTIONS_S%';

It should return one row with value: cache_size as 0

How to Generate Document Number in Bank Statement Reconciliation

http://cashmanagementcm.blogspot.com/2017/01/how-to-generate-document-number-in-bank.html

Query the Account Name from Reconcile Bank Statement Form

Navigate to Document Categories in system Administrator

Enter the Queried Account Name in Code, Name and Description

Enter Table Name "CE_STATEMENT_HEADERS_ALL" and save

Now, Define Sequences for the Account Name