My Oracle Support Banner

FFIEC-009 - Issuer Not Considered For ABS Securities (Doc ID 2815732.1)

Last updated on OCTOBER 25, 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.

Goal

Version: RRS 80981
Report/Schedule: FFIEC-009


Issue: WF found in its testing that for ABS securities the logic is not referring to issuer but the counterparty for immediate risk reporting (country and sector)
We found that in T2T_FCT_REG_FUND_LEND_DETAILS_ACCOUNT, expressions for various fields consider V_STD_PRODUCT_TYPE_CODE_LVL1 IN ('DS', 'SDS', 'SOVDS', 'EQUITY') as security and do not include ABS

FCT_REG_FUND_LEND_DETAILS.F_CP_FINANCIAL_ENTITY_FLAG
FCT_REG_FUND_LEND_DETAILS.F_DOMESTIC_CP_FLAG
FCT_REG_FUND_LEND_DETAILS.N_COUNTER_PARTY_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_BUSINESS_DOMAIN_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_CONSTITUENT_TYPE_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_DOMICILE_COUNTRY_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_INCORP_COUNTRY_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_LV_OWNERSHIP_TYPE_SKEY
FCT_REG_FUND_LEND_DETAILS.N_CP_STD_PARTY_TYPE_SKEY
FCT_REG_FUND_LEND_DETAILS.N_REM_MATURITY_IN_DAYS
FCT_REG_FUND_LEND_DETAILS.N_REM_MATURITY_IN_MONTHS

Expectation to  ABS need to add in condition to cover all securities
 

Solution

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
Goal
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.