My Oracle Support Banner

FRY14M Schedule A1/B1: Maturity Date Usage (Doc ID 2708408.1)

Last updated on SEPTEMBER 12, 2020

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

Issue 1:FRY14M Schedule A1 (line 57) – CCFLM198 and FR Y 14M Schedule B1 (line 57) – CCHEM198

Requirement: Report the remaining term of the loan in months. Note: For the Remaining Term line items in the FRY14M First Lien and Home Equity schedules, a value of 0 should be assigned if a loan is past maturity.

Issue- usage of D_MATURITY_DATE in the logic

OFSAA Design per RRS 80740 HM Linkage is using MRA1026 (FLAS Remaining Term Monthly) that has column FCT_LOAN_ACCOUNT_SUMMARY.N_REMAINING_TERM_MON. This column is derived in OFSAA FSDF T2T by Expression CASE WHEN (STG_LOAN_CONTRACTS.D_MATURITY_DATE <= STG_LOAN_CONTRACTS.FIC_MIS_DATE) THEN 0 ELSE ROUND(MONTHS_BETWEEN(STG_LOAN_CONTRACTS.D_MATURITY_DATE,STG_LOAN_CONTRACTS.FIC_MIS_DATE)) END

-----------------------------
Issue 2- Remaining Term Before Modification reported on FRY14M Schedule A1 (line 105) – CCFLM934
REQUIREMENTS: Fed instruction for Schedule A1: Report the remaining term in the month prior to loan modification. This line item should only be populated for loans with a value in Line item 74 (Modification Type).

Issue- usage of D_MATURITY_DATE in the logic

OFSAA Design per RRS 80740 HM Linkage is using MRR2910 (Remaining Term Before Modification) that has column FCT_LOAN_ACCOUNT_SUMMARY.N_REMAIN_TERM_BEFORE_MODFCTN. This column is derived in OFSAA FSDF T2T by Expression
ROUND(MONTHS_BETWEEN(STG_LOAN_CONTRACTS.D_MATURITY_DATE,STG_LOAN_CONTRACTS.D_MODIFICATION_PROGRAM_DATE))


---------------------------
Issue -3: Remaining Term After Modification reported on FR Y 14M Schedule A1 (line 106) – CCFLM935

REQUIREMENTS: Fed instruction for Schedule A1: Report the remaining term in the month after loan modification. This line item should only be populated for loans with a value in Line item 74 (Modification Type).

Issue- usage of D_EFF_MATURITY_DATE

OFSAA Design per RRS 80740 HM Linkage is using MRR2911 (Remaining Term After Modification) that has column FCT_LOAN_ACCOUNT_SUMMARY.N_REMAIN_TERM_AFTER_MODFCTN. This column is derived in OFSAA FSDF T2T by Expression
ROUND(MONTHS_BETWEEN(STG_LOAN_CONTRACTS.D_EFF_MATURITY_DATE,STG_LOAN_CONTRACTS.D_MODIFICATION_PROGRAM_DATE))

----------------------------

The expressions are in FSDF T2Ts the above changes will be required for all 3 tables for consistency (STG_LOAN_CONTRACTS, STG_LEASES_CONTRACTS and STG_OD_ACCOUNTS) that source into FCT_LOAN_ACCOUNT_SUMMARY. The examples of the expression mentioned is only from STG_LOAN_CONTRACTS but similar changes required in the T2Ts of the other 2 Staging tables also.

Changes

 NA

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
References


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