My Oracle Support Banner

Incorrect Range Of Values Used For FRY 14Q, A.10, D_CDR_000199 (Doc ID 2607000.1)

Last updated on NOVEMBER 08, 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.

Goal

FRY 14Q, A.10, D_CDR_000199: As per instructions for this line item, the total unpaid principal balance in the segment that has a school cohort default rate as computed by the Department of Education falling within 0% through 1.99% as of the month-end.

As per configuration the logic uses the condition within the DIM table where V_BAND_TYPE = 'CDR' AND N_BAND_CODE = 1. The upper bound value for this combination in the DIM_BAND table is 1 and the lower bound value is 0 (version 8.0.6.0.1-8.0.6.1.1)

Clarification sought on how does the configuration include the records for which the CDR value is between 1 and 1.99, which is also relevant range for this line item as per the instructions? Same is the case for rates in 2 – 3.99%, 4 – 5.99%, 6 – 7.99% and 8 – 9.99% ranges.
 

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


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