OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration
Pack is a separately licensed product.
Description
Bug 25288475 - Oracle Financial Services
Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack
v8.0.3.1.0 Maintenance Level Release.
This
Maintenance Level Release (ML) of OFS REG REP USFED is cumulative of
enhancements and bug fixes done since the 8.0.3.0.0 Minor Release.
Prerequisites
The
pre-requisites required for this release are as follows:
§ The
minimum patch set level should be OFS REG REP USFED 8.0.3.0.0 full installer (Bug 24947981)
§ Oracle Financial Services
Analytical Applications Infrastructure (OFSAAI) 8.0.3.1.0
§ Oracle Financial Services Data
Foundation (FSDF) 8.0.3.1.0
§ Lombard Risk AgileREPORTER v1.14.2
§ AgileREPORTER Templates
(RPforFED_v1.7.1.4.zip) is available in AgileREPORTER
How to Apply This Maintenance Level Release?
For detailed instructions on installing
this Maintenance Level Release, refer to OFS REG REP USFED
8.0.3.1.0 Installation Guide.
New Features in This Release
The list of new features
incorporated in this release are:
§ Provides a
complete set of OFSAA Business Metadata objects to support regulatory reporting
of the below mentioned returns:
o
FR Y-11_V2
o
FR 2314_V2
o
FR 2052A_V2
o
FR Y-14MD1_V1
o
FR Y-9C_V5
o
FFIEC031_V7
o
FFIEC041_V7
§ Metadata Export
Utility:
Added a new utility for
exporting various types of Metadata like Reports, Schedules, Views, Derived
Entities, Entities, and so on with Dependencies,
Lineage and Usage.
List of Bugs Fixed in This Release
|
Bug ID |
Description |
|
FR Y-9C REPORT,
SCHEDULE HC-C, LINE ITEM M.12, SUB ITEMS M.12.A TO M.12.D |
|
|
FR Y-9C REPORT,
SCHEDULE HC-C, LINE ITEM M.1, SUB ITEM M.1.F.(1) TO M.1.F.(6) |
|
|
SCHEDULE RC-C MDRM
CODE RCONB534 - VALIDATION OF METADATA FILTER |
|
|
DIM_BEHAVIOUR_TYPE
SEEDED DATA CORRECTION |
|
|
8.0.2 SEEDED SCRIPTS
REQUIRED FOR DIM_RISK_TYP |
|
|
ONLY
F_ACCOUNT_INSURANCE_FLAG='Y' FILTER RECORDS SELECTED IN CURRENT METADATA |
|
|
MISSING FILTERS FOR
LINE 6(A) ITEMS UNDER HC-B AND RC-B SCHEDULES |
|
|
BAND RECLASSIFICATION
RULES MISSING UNDER HC-B AND RC-B SCHEDULES |
|
|
LOGIC TO BE CHANGED
FOR MDRM BHCKK150 - BHCKK153 UNDER HC-B AND RC-B SCHEDULES |
|
|
LOGIC TO BE CHANGED
FOR MDRM BHCKK142 - BHCKK145 UNDER HC-B AND RC-B SCHEDULES |
|
|
LOGIC TO BE CHANGED FOR
MDRM BHCKG364 - BHCKG367 UNDER HC-B AND RC-B SCHEDULES |
|
|
LOGIC TO BE CHANGED
FOR MDRM BHCK8782 - BHCK8783 UNDER HC-B AND RC-B SCHEDULES |
|
|
POPULATION OF
N_GUARANTOR_COUNTRY_SKEY IN FCT_REG_ACCOUNT_SUMMARY |
|
|
MDRM RCFDB538 (CELL
6A OF RC-C REPORT) REQUIRES REPORTING OF "CREDIT CARDS" |
|
|
INCORRECT REPRICE
BAND CODES BEING USED FOR RCONA587 |
|
|
ISSUES WITH
CONDITIONS SPECIFIED IN DERIVED ENTITIES DEBSM001 |
|
|
ISSUES WITH
CONDITIONS SPECIFIED IN DERIVED ENTITIES DE11BS02 |
|
|
FILTER CRITERIA FOR
"COMMERCIAL BANKS" IN LINE ITEMS 1(A) THROUGH 1(E) |
|
|
FILTER CONDITION TO
BE CORRECTED FOR DSRGRL24 |
|
|
DATATYPE MISMATCH IN
T2T_STG_CASA_CAS AND T2T_STG_TD_CONTRACTS_CAS |
|
|
INVALID IDENTIFIER IN
T2T FCT_REG_ACCOUNT_SUMMARY IN RRS 802 |
|
|
MISSING DERIVED
ENTITIES DERCOV01, DERCOV02 AND DEYTD01 |
|
|
FEW MEASURES NOT
SHOWING IN OFSAA WHEREAS PRSENT IN BUSINESS METADATA DOCUMENT |
|
|
BHCB2389 IS EXPECTED
TO INCLUDE FILTER ONLY INTEREST BEARING DEPOSITS |
|
|
REG DEPOSIT
RECLASSIFICATION RULES ARE REFERRING TO FDB |
|
|
CLARIFICATION
REQUIRED ON FR2314/Y11 REPORT LINE POPULATION: BS14 AND BS7 |
|
|
REGULATORY PRODUCT
CLASSIFICATION FOR BS21 |
|
|
FR2314/Y11 IS-B.1
LINE ITEM TO BE CORRECTED |
|
|
IS-A.1 REPORTING LINE
HFM SINCE NO BALANCE RETURNED POST BATCH TO BE CORRECTED |
|
|
FR2314/Y11 IS-A.3
LINE ITEM TO BE CORRECTED |
|
|
BS-3A/BS-A.1 LINE
ITEM IN REPORT Y11/FR2314 TO BE CORRECTED |
|
|
INCORRECT DEM CODE
USAGE FOR REPORTING LINES OF HFM FOR FR2314 AND FR Y-11 |
|
|
FR2314/Y11 IS-B.3
LINE ITEM TO BE CORRECTED |
|
|
SIGN ISSUE WITH
SUB-LEDGER LINE ITEMS FOR FR2314 AND Y11 REPORTING LINE ITEMS |
|
|
REPORT FR2314/Y11 -
BS.16 TO BE CORRECTED |
|
|
FR Y11 REPORT:
REGARDING Y11-BS-M.13.A/B/C AND Y11-BS-M.9.A/B/C TO BE CORRECTED |
|
|
Y11-BS-M.4 REPORT
LINE ITEM FOR Y11 REPORT TO BE CORRECTED |
|
|
CHECK-IN REQUIRED FOR
METADATA SCRIPTS OF FRY11/FR2314 TO ENABLE DRILLDOWN |
|
|
INCORRECT VALUES FOR
SOME DERIVED ENTITIES |
|
|
BS.4, BS11 CONDITION
TO BE CORRECTED |
|
|
CLARIFICATION
REQUIRED ON FR2314/Y11 REPORT LINE POPULATION |
|
|
REPORTING LINE
DESCRIPTION V_REP_LINE_NAME SHOWING IN BUSINESS METADATA |
|
|
2052A - EXCESS
PAYMENT IN CARDS SCENARIO |
|
|
FR2314/FR Y-11 BS-A
BS MAPPING CHANGES |
|
|
BAND CODES TO BE
CORRECTED UNDER HC-B AND RC-B SCHEDULES |
|
|
LOGIC TO BE CORRECTED
FOR MDRM RCFDG360 - RCFDG363 UNDER HC-B/RC-B |
|
|
MDRM LOGIC UPDATE |
|
|
OR CLAUSE TO BE
CHANGED TO AND |
|
|
DESCREPENCY IN SOME
SEEDED DATA ENTRY DESCRIPTIONS |
|
|
RCFD041-MEMBER CODE
FORDIM_PLEDGED_STATUS FOR N_PLEDGED_STATUS IS MENTIONED AS Y |
|
|
INCLUSION OF DOMICILE
COUNTRY CODE AS US (HC-B, RC-B) |