Not All Forecast Scenarios Are Populating In FCT Tables Of ALMBI
(Doc ID 2957347.1)
Last updated on JUNE 26, 2023
Applies to:
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)
Symptoms
On ALMBI 8.0.x version, not all the forecast SCENARIOS are populated in FCT tables of OBIEE.
You have 2 Scenarios defined in their system, say UP and DOWN scenarios. When you are executing the cashflows, both the scenarios are populating in the resultant tables (RES_DTL_XXX and CONS_DTL_XXX), but only UP scenario is moving to below FCT tables:
FCT_AGG_BASE_CCY_CASHFLOWS
FCT_AGG_BASE_CCY_IRR_GAP
FCT_AGG_BASE_CCY_LR_GAP
FCT_AGG_CONS_CCY_CASHFLOWS
FCT_AGG_CONS_CCY_IRR_GAP
FCT_AGG_CONS_CCY_LR_GAP
FCT_AGG_BASE_CCY_ALM_MEASURES
FCT_AGG_CONS_CCY_ALM_MEASURES
FCT_PROCESS_CASHFLOW
You have tried populating scenario through both ALM cashflow process itself ("Move to ALM BI Mart" option) and while creating separate ALMBI transformation batch, but results are still not getting populated as expected.
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 |