ALM BI Dashboards and Reports Do Not Display All Latest Process ID and As Of Dates in the Drop Down List Boxes
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.
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.
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:
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:
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms