ALMBI Transformation Not Loading Data To All FCT Tables / DIM_ALM_COA Incorrectly Used In JOIN Condition
(Doc ID 2504065.1)
Last updated on JULY 27, 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 Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Business Intelligence Enterprise Edition (OBIEE)
ALMBI transformation is not loading data to all the FCT tables for few processes (data is getting loaded to all the FCT tables for other processes).
In this given case, tables like FCT_AGG_BASE_CCY_CASHFLOWS, FCT_AGG_CONS_CCY_CASHFLOWS, etc. are not getting populated, whereas FCT_AGG_BASE_CCY_ALM_MEASURES & FCT_AGG_CONS_CCY_ALM_MEASURES tables are getting populated.
The joining condition seems incorrect, i.e. the "DIM_ALM_COA.N_ALM_COA_ID = RES_DTL_200687.alm_coa_id" part.
After correcting the JOIN condition, the above query outputs the result, so there is no data issue in these tables.
Note: DIM_ALM_COA is used as a product dimension for ALM.
No errors were reported in FSI_PROCESS_ERRORS table.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Run similar ALMBI transformation process.
2. Check how data is loaded into FCT tables.
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