My Oracle Support Banner

HC-S / RC-S: Product Filtering Is Inconsistent With HC-C / RC-C (Doc ID 2607026.1)

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

Symptoms

HC-S / RC-S: Product filtering is inconsistent with HC-C / RC-C

In the Fed formats of Schedules HC-S / RC-S (of the FR Y9C, FFIEC-031, FFIEC-041), please see columns (A) to (G) for rows 1 to 12.The OFSAA logic is using the V_BASEL_POOL_TYPE_CODE to filter exposure based on Product.

This is inconsistent with the identification of Product for the purposes of the RC-C schedule. Out of the values listed in the 8.0.6.1.1. Hierarchy Measure Linkages document, CCR, ALP, OCL are marked as Deprecated and the value 14FRLP does not exist in the in the Dimension Table documentation.
 
The identification of Product should be consistent across the FFIEC 031, and a review of the types of products included in the RC-S (1-4 Family Loans, Home Equity Lines, Credit Card Receivables, Auto Loans, Other Consumer Loans, Commercial and Industrial Loans, and finally All Other Loans, All Leases, and All Other Assets) indicates that there should be consistency with the RC-C. Similar observations for FR Y9C and FFIEC041

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