Missing Mappings Related To Investments Portfolio MDRMs On Y15/FFEIC-009/FFIEC-031 Reports
(Doc ID 2605005.1)
Last updated on NOVEMBER 06, 2019
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.7 and later
Information in this document applies to any platform.
1> Dim_Risk_Sector table is seen under INNER JOIN in DEC009A6. This DIM is joined via FCT_MITIGANTS.N_RISK_SECT_SKEY. However this attribute from Fct_Mitigants is not mapped in T2T_FCT_MITIGANTS.
2> Hierarchy HIFD1533 is used under MDRMs like RCFDA248, RCFDA549, RCFDA550 on FFIEC-031/RC-B. This hierarchy uses attribute N_INTEREST_BM_RATE and N_FLOAT_SPREAD from FCT_COMMON_ACCOUNT_SUMMARY. However both these attributes are not mapped in the T2T_STG_INVESTMENTS_CAS T2T.
3> Hierarcy HIR15D07 is used for Y-15 Schedule B MDRM RISKM353. This hierarchy is checking the FCT_COMMON_ACCOUNT_SUMMARY.F_SENIORITY_FLAG attribute. However this attribute is unmaped in the T2T_STG_INVESTMENTS_CAS T2T.
4> FCT_REG_ACCOUNT_SUMMARY.F_READILY_DETER_FAIR_VALUE is referred via hierarchy HIFD6503 on FFIEC-031/RC-Q MDRM RCFDG476. This attribute however is un-mapped in T2T_FCT_REG_ACCOUNT_SUMMARY T2T.
5> Attributes FCT_REG_ACCOUNT_SUMMARY.N_CPRT_COUNTRY_SKEY and FCT_REG_ACCOUNT_SUMMARY.N_ULT_RISK_COLLATERAL_SKEY are used in INNER JOINS on DEC009A6 and DEF009C4 respectively. These DEs are used for column 14 on FFIEC-009a and on column 12 on FFIEC-009 schedule C-Part II. But in the T2T T2T_FCT_REG_ACCOUNT_SUMMARY T2T these columns are mapped to TO_NUMBER(0).
It is a product configuration issue
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