My Oracle Support Banner

Getting ORA-01438 Populating DIM_RESULT_BUCKET When Gap Buckets Have Two 99 Year Buckets (Doc ID 2664045.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management Analytics - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)

Symptoms

When attempting to populate DIM_RESULT_BUCKET using the seeded SCD, the SCD fails with the following error during the merge into the table:

Error Msg :-> ORA-01438: value larger than specified precision allowed for this column

The error occurs because there is a row in DIM_O_RESULT_BUCKET_V with N_BUCKET_END_DAYS > 99,999.

For example: 70159 - 106317 days

This large number of days occurs because there are two different bucket rows with a frequency of 99 Years in DIM_O_RESULT_BUCKET_V for Gap.

For example:

select n_bucket_term_freq, f_bucket_term_freq_mult, n_bucket_no
from DIM_O_RESULT_BUCKET_V
where n_time_bucket_sys_id = xxxxxx
and n_bucket_type = 'IRR'
and d_as_of_date = '31-JAN-2020';

You expect the Interest Rate Gap and Liquidity Gap buckets to have only one 99 Year Bucket.

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
References


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