My Oracle Support Banner

FCT_AGG_BASE_CCY_LR_GAP & FCT_AGG_BASE_CCY_IRR_GAP Tables Don't Show Up In The ALM HOME Dashboard Drop-down Prompt For AS OF DATE (Doc ID 2506692.1)

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Performance Management (EPM)


Within the ALM HOME Dashboard, the drop-down prompt for AS OF DATE has values for FCT_AGG_BASE_CCY_LR_GAP table but doesn't have an entry for FCT_AGG_BASE_CCY_IRR_GAP table.

FCT_AGG_BASE_CCY_LR_GAP is being referred to in report called "Liquidity Gap Summary in Base Currency", whereas FCT_AGG_BASE_CCY_IRR_GAP is being referred to in "Repricing Gap Summary in Base Currency".

Due to this, the expected results for the second report cannot be obtained.

Query that fetched values for AS OF DATE is supposed to be wrong:


The issue can be reproduced at will with the following steps:
1. Login to OFSAA
2. Go to ALM HOME Dashboard
3. Open "Repricing Gap Summary in Base Currency" report
4. Select IRR process and scenario and click on APPLY button
5. After clicking on applying button, no values populated in the AS OF DATE drop-down.


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

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