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.
'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
FFIEC-031 & FFIEC041
(RCON2365, RCONHK05, RCONHK06, RCONK220)
This 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