ALMBI DIM_RESULT_BUCKET D_PARENT_START_DATE Set To AS_OF_DATE for All Dynamic Start Dates (Doc ID 1505573.1)

Last updated on APRIL 01, 2016

Applies to:

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

Symptoms

On: ALMBI 6.0

When running SCD for DIM_RESULT_BUCKET for ALM Dynamic Process with multiple start date, the N_START_DATE_INDEX does not reflect multiple start dates and D_PARENT_START_DATE is set to AS_OF_DATE

STEPS

1. Time Buckets for ALM process shows two Dynamic Start Dates for Interest Rate Gap Buckets and Liquidity Buckets.
1. Run SCD for DIM_RESULT_BUCKET
2. DIM_RESULT_BUCKET shows one D_PARENT_START_DATE for V_BUCKET_TYPE IRR (Reprice Gap Buckets) and LR (Liquidity Gap Buckets) instead of two.


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