My Oracle Support Banner

FRY 14M. MDRMs: CCFLM206,CCFLM207, CCFLM215,CCFLM952. Missing Display Codes In Dimension Tables. (Doc ID 2606126.1)

Last updated on NOVEMBER 06, 2019

Applies to:

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

Symptoms

For MDRM: CCFLM206 Foreclosure Status - OFSAA has configured foreclosure status using
DIM_FORECLOSURE_STATUS.V_FORECLSR_STAT_REG_DISPLAY_CD but value "0" is repeated twice and there is no exclusion logic for "Missing" and "Other" in hierarchy expression.

For MDRM: CCFLM207 Loan Repurchase Type.
- OFSAA has configured repurchase type using DIM_LOAN_REPURCHASE_STATUS.V_LOAN_REPUR_STA_REG_DISP_CD. "Missing" and "Other" is not handled in hierarchy expression. Dimension table has display value 4 as "Eligible for Repurchase" which is not allowed value as per instruction.


For MDRM CCFLM952 Registered entity type of the BHC subsidiary that owns the reported loan. If the loan is not owned by the BHC or IHC or its subsidiaries, report the entity type as 'Other’. OFSAA has configured entity type using DIM_ENTITY_TYPE.V_ENTITY_TYPE_REG_DISPLAY_CD but column V_ENTITY_TYPE_REG_DISPLAY_CD in dimension table is blank.

CCFLM159: Duplicate values in dim table DIM_LOAN_SOURCE_TYPE.

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