Regulatory
Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.0.0
Maintenance Level Release #1 (8.0.4.1.0)
OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack is a separately licensed product.
Description
Bug
26228650 - Oracle Financial Services
Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack
v8.0.4.0.0 Maintenance Level Release #1 (8.0.4.1.0)
This
release of OFS REG REP US FED is cumulative of all enhancements and bug fixes
done since v8.0.4.0.0 release.
The
prerequisites for this one-off patch are:
1.
The minimum patch set level must be OFS REG REP US FED v8.0.4.0.0 (Bug 25710692).
2.
Oracle Financial Services Analytical Applications
Infrastructure (OFSAAI) 8.0.4.1.0
3.
Oracle Financial Services Data Foundation following patches
installed:
o
Download and apply FSDF 8.0.4.1.0 Maintenance Level patch
(Bug 26285451)
o
Download and apply FSDF 8.0.4.1.1 One-off patch (Bug 26263935)
4.
Lombard Risk Agile Reporter version 1.15.4-b1112 must be installed.
5.
AgileREPORTER Templates (ARforFED_v1.9.2.6.zip) must be available in AgileREPORTER.
How
to Install This Maintenance Level Release?
For
detailed instructions on installing this Maintenance Level Release, refer to OFS REG REP USFED
8.0.4.1.0 Installation Guide.
New Features
in this Release
The list of new features
incorporated in this release is:
1.
Provides a complete set of OFSAA Business Metadata objects to support
regulatory reporting of the below mentioned returns:
a.
FR Y-14Q_V2 (A10)
b.
FR Y-14Q_V5 (B1& B2)
c.
FR 2052A_V4
2.
Validation Check for Data Schedules
Added a new utility for validating Data Schedules
under Chapter 9 in the OFS REG REP USFED
8.0.4.1.0 User Guide.
3.
Data Lineage Program Enhancement
a.
Rule-to-Rule Dependency Lineage: Rule-to-Rule dependency is calculated
using used Member Codes in Source and Target.
4.
MDB Export Functionality Enhancement
a.
Output file format is changed from .xls to .xlsx as there was a
limitation earlier of showing only around 65000 records with .xls format.
b.
Data Lineage sheet will be in .csv format if number of records exceed
100000.
c.
INDEX index_mdr_mod_parent_child ON mdb_object_dependencies table is
introduced to improve performance while fetching records.
List
of Bugs Fixed in This Release
The
bugs fixed in this release are as follows.
|
Component |
Sub Component |
Bug ID |
Subject |
|
Metadata |
– |
REQUIRED
COLUMN NAME IN PP TABLES FOR INSTRUMENT TYPE |
|
|
– |
STAGING
REFERENCE COLUMN REQUIRED FOR DIM_REG_RISK_CLASS |
||
|
– |
CLARIFICATION
REQUIRED ON ADDING FILTER TO RCOND972, RCOND973, RCOND974, RCONS41 |
||
|
– |
MISSING
RE-CLASSIFICATION RULES UNDER HC-R / RC-R SCHEDULES |
||
|
– |
INCORRECT
ACCTPRIAMTBAND BAND CODE USED IN FFIEC-031/RC-C/PART 2 |
||
|
– |
OLDER
LOMBARD REPORT TEMPLATE USED FOR FRY-14Q (B1,B2) |
||
|
– |
FR
Y-14Q: AUTO LOANS - FUNCTIONAL QUERY RELATED TO NET CHARGE-OFFS |
||
|
– |
FFIEC
031_RC-R PART II_FILTER CONDITION FOR MDRM RCFDH294 & RCFDH295 |
||
|
– |
SOURCE
TABLE MAPPINGS MISSING FOR MDRMs BELONGING TO FRY-14M (SCHEDULE D1, D2) |
||
|
– |
FR-2052A:
EDIT CHECKS REQUIRED |
||
|
– |
LOGIC
IN THE DE DERSLN01 DOES NOT SEEM TO BE CORRECT |
||
|
– |
FILTER
CONDITION NEEDS TO BE CORRECTED FOR SOME MDRM CODES UNDER HC-R PART II |
||
|
– |
QUERY
ON FORWARD_START_BUCKET_START FILTER USAGE IN IA5 SCHEDULE |
||
|
T2T |
CLARIFICATION
ON F_RESTRUCTURED_IND & F_TROUBLED_DEBT_RESTRUCRE_FLAG |
||
|
DEPRICATED
STAGING COLUMN 'N_30DPD_12MONTHS_BAL' IS USED FOR FRY-14Q LINEAGE |
|||
|
Measures |
FFIEC
031_RC-R PART II_INCORRECT MEASURE |
||
|
DOCUMENTATION:
REG REPORT:INCORRECT VALUE FOR MEMBER CODE IN DIM_REG_DEPOSIT_TYPE |
|||
|
Rules |
SOURCE
TABLE MAPPINGS MISSING FOR MDRM'S BELONGING TO FRY-14M (SCHEDULE D1) |
||
|
Derived Entities |
DIM_ORG_STRUCTURE.V_COUNTRY_ID
USED FOR COUNT OF JURISDICTIONS |
||
|
RC-C
PART I MEMORANDA - LOAN MATURITY BANDING ISSUES |
|||
|
DIM_PRODUCT_TYPE,
DIM_ISSUER_TYPE USED AS FILTER FOR THE REPORT FRY-7N |
|||
|
Business Processors |
FRY-14Q:
A2-LOGIC USED IN GROSS CONTRACTUAL CHARGE-OFFS SAME AS NET CHARGE-OFFS |
||
|
RRS_CAP1:
FRY-14Q AUTO LOANS - INTEREST RATE CLARIFICATION |
|||
|
Install |
– |
FR-2052A:
FOR ORG STRUCTURE, THERE IS A REQUIREMENT FOR MULTIPLE HIERARCHIES |
|
|
Documentation |
– |
FFIEC
031_RC-R PART I_REP LINE FOR DERIVED MDRMS |
|
|
Data Lineage |
– |
RRS_CAP1:
14Q SECURITIES - MISSING DATA LINEAGE |
|
|
– |
FRY-14Q:
SECURITIES - MISSING DATA LINEAGE |
Known Issues/
Limitations in This Release
There are no known issues
/ limitations in this release.
Oracle Financial Services Software
Confidential and Restricted | Copyright ©
2017, Oracle and/or its affiliates. All rights reserved. | Phone: +1.650.506.7000 | Fax: +1.650.506.7200 | www.oracle.com/industries/financial-services/index.html