My Oracle Support Banner

FFIEC-031, FFIEC-041: RC-C, HC-C : Logic is missing to report multiple loans given to same borrower on the same products (Doc ID 2650098.1)

Last updated on MARCH 22, 2020

Applies to:

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

Goal

Issue #1:

FFIEC-031/041 RC-C
Line item : 2.b.3
MDRM: RCFDA572

As per the instructions the line item has to interpreted as all Fixed rate Credit cards and Other revolving credit plans regardless of the actual maturity experience or expectation should be reported in 2.b.3 - this condition is not being handled in 80800 H_M linkage document.

Maturity should ignored for "Fixed rate Credit cards and Other revolving credit plans" and they should be reported in 2.b.3 irrespective of the maturity.
Current logic does not ignore the maturity and takes that into account and reports these products in 2b1, 2b2 and so on - which is not the ask as per the regulators.

 

Issue #2: As per OFSAA 8084 configuration, currently Business_processor BPFD1666 is used to calculate the numbers with the below expression.
COUNT(DISTINCT COALESCE (DIM_ACCOUNT.V_ORIGINAL_ACCOUNT_NUMBER,DIM_ACCOUNT.V_ACCOUNT_NUMBER))
Logic is missing to report multiple loans given to same borrower on the same products need to be counted as one.

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


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