My Oracle Support Banner

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

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