Loans Created via the Loans API are Skipping in Both Sequence ID and Loan Number (Doc ID 1595539.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Loans - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

For every loan type, the Loan Number and Loan ID are skipping values:

For example, the number/ID values show:

LOAN_ID LOAN_NUMBER
------- -----------
11061   L10950
11063   L10952
11065   L10954
11067   L10956
11069   L10958
11071   L10960
11073   L10962
11075   L10964
11077   L10966
11079   L10968


Pred-defined sequences:
LNS.LNS_LOAN_HEADERS_S
LNS.LNS_LOAN_NUMBER_S

The same happens with manual transactions.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms