My Oracle Support Banner

ERL-4481: Identification Of New Term Loans (Doc ID 2810122.1)

Last updated on OCTOBER 04, 2021

Applies to:

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

Goal

Version: RRS 80951, FSDF 8093
Report: 2028D
MDRMs: QSBLHQ38, QSBLHQ39, QSBLHQ40, QSBLHQ41, QSBLHQ42, QSBLHQ43
Lines: 9.a to 9.f

Issue:
As per the instructions, for the impacted MDRMs below ""New Term"" C&I Loan reporting is required.

Instructions state "Include all term C&I loans to U.S. small businesses entered into your books or loan system during the most recent calendar quarter, even if the loans were approved or disbursed in the prior calendar quarter. Exclude loans approved or disbursed but not entered into your institution's books or loan system during the most recent calendar quarter."

Current configuration is checking if the loan is sold during the quarter but not if the loan was also booked in the same quarter (ie New Loan)

a) How is the configuration determining if the loan was booked in the recent quarter
b) How is the configuration identifying is the loan is 'SBA Guaranteed"
c) Dataset uses filter
DIM_REG_PRODUCT_TYPE.V_REG_PROD_TYPE_CODE IN ('CON', 'CISMALBUS', 'COMANDIND', 'OTHCOMLOAN')
AND COALESCE(DIM_REG_LOAN_PURPOSE.V_REG_LOAN_PURPOSE_CODE, 'MSG') NOT IN ('AGP', 'FAMPROCON')
Some of the values referred for reg prod types (CON, COMANDIND) are not in Seeded Dimension file shared with Customer.
 

Solution

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