OFS Regulatory Reporting for US Federal Reserve – Lombard Risk
Integration Pack is a separately licensed product.
Description
Bug
25443064 - Oracle
Financial Services Regulatory Reporting for US Federal Reserve – Lombard Risk
Integration Pack v8.0.3.2.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.1.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.15.1
§ AgileREPORTER Templates
(RPforFED_v1.8.1.4 for AR_1.15.1) is available in AgileREPORTER.
§ Add the column
F_TEMPORARY_OVERDRAFT_IND CHAR(1) (Logical Name:
Temporary or Unplanned Overdraft Indicator) in FCT_COMMON_ACCOUNT_SUMMARY using
FSDF ERWIN model.
§ Add the column N_INTEREST_TYPE NUMBER(5) (Logical Name: Interest Type Surrogate Key) in
FCT_CARDS_BALANCE_SUMMARY using FSDF ERWIN model.
§ These columns would be available as
a formal release of FSDF 8.0.4.0.0
§ Generate the xml file and upload
the model using Data Model maintenance option in OFSAA. Use slice as the Upload
mode.
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.2.0 Installation Guide.
New Features in This Release
The 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_V3
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 |
|
SEEDED
DIMENSION TABLES ARE MISSING IN DIMENSION TABLES_8031.XLSX DOCUMENT |
|
|
CLARIFICATION
REQUIRED ON THE USAGE OF PARTIAL PLEDGES IN DIM_PLEDGED_STATUS |
|
|
CLARIFICATION
REQUIRED ON THE USAGE OF TOTAL LOAN PERCENTAGES IN RC-N |
|
|
FILTER
REQUIRED FOR 'PROPERTIES IN DOMESTIC OFFICES' IN FFIEC-031, FFIEC-041(RC-N) |
|
|
CLARIFICATION
ON TROUBLED_DEBT_RESTRUCRE FILTER IN HC-N & RC-N SCHEDULE |
|
|
NONE OF THE
RECORDS SHOULD BE LEFT BLANK.CONFIGURATION TO BE UPDATED. |
|
|
FCT_CARDS_SUMMARY.N_EOP_BAL_RCY
COLUMN NEED TO BE CHANGED |
|
|
DERIVED
ENTITIES JOIN CONDITIONS SEEMS INCORRECT |
|
|
INCORRECT
FILTER 'MIS' IN DIM_ENTITY_TYPE.V_ENTITY_TYPE_CODE IN H-M LINKAGE DOC |
|
|
INFORMATION
INCONSISTENT IN THE LINKAGE DOCUMENT UNDER IS-A AND RI SCHEDULES |
|
|
DIM
GEOGRAPHY SEEDED VALUES |
|
|
BATCHES ARE
MISSING IN THE ENVIRONMENT |
|
|
ADDITION OF
COLLATERAL CLASS IN I.O.8 |
|
|
2052A-PID-IA3
AND IA 4- CHANGES REQUIRED IN DE QUERY |
|
|
CONTRACTUAL
MATURITY BAND RULE IN FR2052A |
|
|
IS4 AND OS4 |
|
|
ADDITION OF
COLLATERAL VALU EIN DEFR101 |
|
|
RUN
EXECUTION FILTER |
|
|
HANDLING
"NULL" VALUES FOR FLAGS IN RECLASS RULES |
|
|
RUSFR2052A101
- REG STANDARD PARTY TYPE HIER-SMALL BUSINESS: INCORRECT MAPPING |
|
|
HANDLING
AND SOURCING OF COMPLEX CARDS DATA |
|
|
QUERY ON
FCT_REG_ACCOUNT_SUMMARY UNDER HC-R / RC-R SCHEDULES |
|
|
T2T FROM
STG_CARDS TO FCT_LOAN_ACCOUNT_SUMMARY |
|
|
CLARIFICATION
REQUIRED ON FR2314/Y11 REPORT LINE POPULATION: BS14 AND BS7 |
|
|
INCOMATIBILITY
IN THE USAGE OF MEASURES FOR SIMILAR CELLS IN DIFFERENT REPORTS |
|
|
FR2314/Y11
BS-.1 - DEBSM001 - HELD BY CLIENT FLAG |
|
|
FFIEC-031/041
- HIRCL001 - HELD BY CLIENT FLAG |