My Oracle Support Banner

Unused Customer Numbers Missing in STTM_CUSTOMER_UNUSED Table (Doc ID 2829367.1)

Last updated on JANUARY 24, 2022

Applies to:

Oracle FLEXCUBE Universal Banking - Version 12.0.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Bank team checked there are around total of 191,669 customer numbers are missing to be utilized, the below sequence is indicating the first customer record start from 100000002 and the end record is 100607188 in the system, in between the system missing the sequence of the customer records,

Team also identified all the missing records by executing the below query and the result is attached in excel file,

select strt, end_record, ((end_record - strt) + 1) numofmissing from (
  select m.customer_no + 1 strt,
  (select min(customer_no) - 1 from sttm_customer x where x.customer_no > m.customer_no) as end_record
  from sttm_customer m
  left outer join sttm_customer r on m.customer_no = r.customer_no - 1
  where r.customer_no is null
) x
where end_record is not null order by end_record;

EXPECTED BEHAVIOR
-----------------------
Customer number generation should be in sequence and there should not be any unused customer numbers

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Bank is running out of licensed number of customer generation.

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
Cause
Solution


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