ALM BI Dashboards and Reports Do Not Display All Latest Process ID and As Of Dates in the Drop Down List Boxes

(Doc ID 1955972.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.6 and later
Information in this document applies to any platform.
ALMBI

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 5.6, none of the ALMBI Dashboards or reports display the latest information in any of the drop down list boxes.

ACTUAL BEHAVIOR
The ALM BI Dashboards and Reports do not show any of the latest loaded information in the list boxes therefore none of the correct information cannot be displayed:

Listbox :
Process.
as_of_date
Dynamic gap Date
Bucket End Date


The happens in all the following reports:
• 01 ALM Home
• 02 Repricing Gap
• 03 Financial Results
• 04 Earnings At Risk
• 06 Market Value
• 07 Value At Risk

The SCD processes are all successfully executed for the following items:

DIM_PROCESS
DIM_FCST_RATES_SCENARIO
DIM_RESULT_BUCKET

The DIM_RUN Process was executed.
The DIM_DATES Process was executed.

The ALM BI Transformation is also successfully executed and the following tables are populated with correct information:

FCT_AGG_BASE_CCY_CASHFLOWS:contains the standard (base currency) cash flow output for all current position and forecast balances, across all forecast rate scenarios.
FCT_AGG_BASE_CCY_LR_GAP: contains Liquidity Gap Financial Element (base currency) cash flow output for all current position balances, across all forecast rate scenarios.
FCT_AGG_BASE_CCY_IRR_GAP: contains Repricing Gap Financial Element (consolidated to reporting currency) cash flow output for all current position balances, across all forecast rate scenarios.
FCT_AGG_BASE_CCY_ALM_MEASURES: contains Market Value, Duration and Convexity information (base currency) for all current position balances, across all forecast rate scenarios.

EXPECTED BEHAVIOR
Expect to see the latest process rules and dates to appear for selection in the drop down list boxes.

The issue can be reproduced at will with the following steps:

1. Successfully run all SCDs for ALMBI
2. Successfully run ALMBI Transformation
3. Check ALMBI Dashboard

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