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