My Oracle Support Banner

Issues related to MDRM code CCHEM251 (Loan Status-MBA Method ), Report- FRY14M, schedule- B1 (Doc ID 2597831.1)

Last updated on OCTOBER 20, 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

Report- FRY14M

Schedule- B1

MDRM code- CCHEM251 (Loan Status - MBA Method)

 

Issue 1- Rule 'RLFD_FRAS_REG_LN_DLQ_STATUS_04' uses 'N_ACCT_CLOSED_IND' as '0' for the identification of CLOSED ACCOUNTS which is incorrect because the T2T populates it as '1'. Rule logic has to be in sync with T2T expressions

Rule Data set join is as shown below-

LEFT OUTER JOIN DIM_BOOLEAN_FLAGS DIM_ACCT_CLOSED_IND ON DIM_ACCT_CLOSED_IND.V_FLAG_CODE=CASE WHEN FCT_COMMON_ACCOUNT_SUMMARY.N_ACCT_CLOSED_IND = 0 THEN 'Y' when FCT_COMMON_ACCOUNT_SUMMARY.N_ACCT_CLOSED_IND = 1 THEN 'N' ELSE NULL END


T2T_STG_LOANS_CAS expression is as shown below-

CASE WHEN (UPPER(STG_LOAN_CONTRACTS.F_CLOSED_IND)= 'Y') THEN 1 WHEN (UPPER(STG_LOAN_CONTRACTS.F_CLOSED_IND)='N' ) THEN 0 END


Issue 2-

Fed instructions for this cell 'CCHEM251' specifies that " If a loan has been liquidated by means of a short sale or has been sold to a third party at a foreclosure sale in the reporting month, then report a “0”(0 is the Allowable value for 'Paid Off')".


The Rule RLFD_FRAS_REG_LN_DLQ_STATUS_03 used for this cell incorrectly define a foreclosed account (INVOLLQ) as paid off.

(rule target Member- PAIDOFF and rule Source Member-INVOLLQ )

The Paid off value should reflect those scenarios mentioned in the guide lines which is not handled in current logic

Issue 3-

Rule 'RLFD_FLS_REG_LN_DLQ_STATUS_01' includes grouping for delinquency bands based on FCT_LOANS_SERVICED.N_DPD_BAND_SKEY. But there is no mapping available for column 'FCT_LOANS_SERVICED.N_DPD_BAND_SKEY'

Changes

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