My Oracle Support Banner

'1-4 Family Residential Mortgages' As Underlying Missing For Some MDRMs (Doc ID 2601554.1)

Last updated on OCTOBER 30, 2019

Applies to:

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

Symptoms

Page 88 of FRY 9C, under line item 4, Mortgage backed Securities (MBS) states the following : Include mortgage backed securities issued by non-U.S. issuers. Exclude from mortgage-backed securities:
Securities backed by loans extended under home equity lines, i.e., revolving open-end lines of credit secured by 1-4 family residential properties (report as asset-backed securities in Schedule HC-B, item 5, and, if applicable.

Page 89 of FRY 9C, under line item 4 (a) , Residential mortgage PTCs, states ""a residential mortgage pass-through security represents an undivided interest in a pool of loans secured by 1-4 family residential properties""."

Reference to MDRMs :

"BHCK G 300/301/304/305/308/309/312/316/320/ BHCK K142/K146/K150/K154,

Except for BHCK G 316 (line 4 b 2,) where there is relation to the underlying DIM_UNDRLYNG_ASST_POOL_TYPE.V_UNDRLYNG_ASST_POOL_TYPE_CODE


There is no relation to the underlying i.e 1-4 family residential mortgage for the other MDRMs mentioned in this SR. All the other MDRMs apart from BHCK G 316 also needs to have the underlying type hierarchy.


Changes

DIM_UNDRLYNG_ASST_POOL_TYPE.V_UNDRLYNG_ASST_POOL_TYPE_CODE filter value has been updated for the mentioned cell ids. DIM_STANDARD_PARTY_TYPE.V_STANDARD_PARTY_TYPE_CODE <>SOV has been added for the following cells:

FRY9C HCB : BHCKG308, BHCKG309, BHCKG310, BHCKG311
FFIEC031/041 RCB : RCFDG308, RCFDG309, RCFDG310, RCFDG311

Below are the MDRMs impacted :

FRY-9C
-BHCKG300,BHCKG301,BHCKG304,BHCKG305,BHCKG308,BHCKG309,BHCKG312,BHCKG316,
BHCKG320,BHCKK142,BHCKK146,BHCKK150,BHCKK154

FFIEC-031
-RCFDG300,RCFDG301,RCFDG304,RCFDG305,RCFDG308,RCFDG309,RCFDG312,RCFDG316,RCFDG
320
RCFDK142,RCFDK146,RCFDK150,RCFDK154

FFIEC-041-
RCONG300,RCONG301,RCONG304,RCONG305,RCONG308,RCONG309,RCONG312,RCONG316,
RCONG320,RCONK142,RCONK146,RCONK150,RCONK154

HREG1320 -Has been modified.

1-4FAMCEFLRESMORT;1-4FAMREVOPENRESMORT;1-4FAMCEJLRESMORT changed as NOT

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.