My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.