My Oracle Support Banner

FRY 14M, MDRM: CCFLM159. Duplicate Values In Dim Table DIM_LOAN_SOURCE_TYPE (Doc ID 2607535.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

There were duplicate values found in dimension table for display codes.
For example: In the dimension table DIM_LOAN_SOURCE_TYPE. The column LOAN_SRC_TYPE_REG_DISPLAY_CD has category 6 assigned to 'Wealth Management / Private Banking ' as well as 'Loan source unknown', though as per instructions only 'Wealth Management / Private Banking ' is required.

For MDRM: CCFLM206 (Foreclosure Status ¿ Report the current foreclosure
status as of the end of the reporting month.)

For MDRM: CCFLM207 (Loan Repurchase Type ¿ Report the loan repurchase type.)

For MDRM CCFLM952 (Report the 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.¿) .

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
References


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