My Oracle Support Banner

Incorrect Filter Condition On Outward & Inward Risk Transfer FFIEC009-C-Part I (Doc ID 2757487.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.

Symptoms

Version: RRS 80963, FSDF 8094
Report/Schedule: 009 - C-Part I
Columns - 13 to 22

Issue:
1) For Columns, C13 -C22 the configuration checks HREG2017 (Collateral Counterparty) country is not same as HREG2001 (Account Customer's) country For eg. HREG2017='US' and HREG2001 NOT IN ('US')

>> This will capture only risk transfers where country is changing, not the sector change within same country
E.g. Customer country is US and sector is Corp, while Guarantor country is US and sector is Bank above configuration would not show outward (from US-Corp) and Inward (to US-Bank), due to above filters

Customer expect country and sector mismatch to be configured as separate cell-groups

2) Configuration for C13-C22 uses
HREG1338 HIR - RR Reg Reporting Line
HREG1340 HIR - RR Reg Fund Lend Granularity = ACCTGUARANTOR#~#ACCTMITIGANT#~#UNDEXP

>> Above configuration would not give any results, since Reg Rep lines are only assigned to ACCOUNT grain
(T2T_FCT_REG_FUND_LEND_REP_LINE_FFIEC009 populates FCT_REG_FUND_LEND_REP_LINE_MAP table only for V_REG_FUND_LEND_GRAIN_CODE IN ('ACCOUNT', 'FIXEDASSETS', 'CREDITLINE', 'GL'), which does not include grains used in MDRM configuration

Customer expect for sector change [Account grain + Reg Rep line] should be compared with [ACCTGUARANTOR, ACCTMITIGANT, UNDEXP grains + Sector for mitigant provider]
Outward reporting should happen based on [Account grain + Reg Rep line]
Inward reporting should happen based on [ACCTGUARANTOR, ACCTMITIGANT, UNDEXP grains + Sector for mitigant provider]

Changes

 NA

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
Changes
Cause
Solution
References


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