My Oracle Support Banner

incorrect filter applied on cells related to ‘brokered deposits’ (FRY9C, FFIEC031, FFIEc041) (Doc ID 2603120.1)

Last updated on NOVEMBER 04, 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.

Symptoms

'NONBROTHDPTY' is the one of the seeded values used in table- DIM_BROKER_DEPOSIT_TYPE, Column- V_BROKER_DEPOSIT_TYPE_CODE

This code indicates "Non Broker Third party Deposits".

Some of the MDRM codes related to 'BROKERED DEPOSIT' are using filter on HIRRCO02 hierarchy (referenced table is 'DIM_BROKER_DEPOSIT_TYPE.V_BROKER_DEPOSIT_TYPE_CODE') with filter values 'NOT EMPTY/NOT OTH/NOT MSG' which is causing inappropriate inclusion of 'NONBROTHDPTY' also for these cells. This is incorrect as because non broker deposit records should not be reported under brokered deposit cells

Impacted cells-

FFIEC-031 & FFIEC041

(RCON2365, RCONHK05, RCONHK06, RCONK220)

FR Y9C

(BHDMHK31, BHDMHK06)

Changes

 This is a product configuration issue

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


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