Regulatory
Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.0.0
One-off Patch Release #1 (8.0.4.0.1)
OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack is a separately licensed product.
Description
Bug
26041104 - Oracle Financial Services
Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack
v8.0.4.0.0 One-off Patch Release #1 (8.0.4.0.1)
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.
Agile Reporter version 1.15.3.1 must be installed.
3.
AgileREPORTER Templates (ARforFED_v1.9.1.6.zip) must be available in AgileREPORTER.
How to Install This One-off Patch Release?
The
steps to install the one-off patch are:
1. Login to https://support.oracle.com/, and search
for Bug# 26041104
under Patches and
Updates tab.
2.
Download 26041104_GENERIC.zip
archive file, and copy it to your OFSAA server in Binary mode.
3.
Shut down all the OFSAAI Services.
4.
Extract the contents of the patch archive file by using the command:
unzip -a <name of the
file to be unzipped>
For example: unzip -a
26041104_GENERIC.zip
Note: The above "-a" option is mandatory to unzip the patch.
In case you notice an error message “unzip: not found [No such file or
directory” before the package is installed, contact your UNIX administrator to
resolve this issue.
5.
Grant RWX (755) permissions for folder by executing the command:
chmod 755
OFS_REG_REP_USFED
6.
Navigate to the path:
<>/OFS_REG_REP_USFED/conf
7.
Update params.conf file with upload model parameter as 0.
8.
Navigate to the path:
<>/OFS_REG_REP_USFED/bin
9.
Execute the install command:
./install.sh
10.
Verify the patch installation logs in the path:
<>/OFS_REG_REP_USFED/logs
11. Generate the application EAR/WAR
file and redeploy the application in the configured web application server.
12. After successful deployment, restart all the OFSAAI
services.
13. Except <<INFODOM>>_USFED_FR2052A_RESAVEDEPV, Re-save derived entities using the batches
available for the respective reports.
Post-Installation
Steps
The post-installation
steps required for this release are:
1.
Execute the following view scripts (available under
“OFS_REG_REP_USFED/Post_Scripts” directory of the patch) in Atomic Schema:
a.
FR2052A_ASSET_INFLOW.sql
b.
FR2052A_DEPOSITS_OUTFLOW.sql
c.
FR2052A_FX_SUPPLEMENTAL.sql
d.
FR2052A_INFO_SUPPLEMENTAL.sql
e.
FR2052A_OTHER_INFLOW.sql
f.
FR2052A_OTHER_OUTFLOW.sql
g.
FR2052A_SECURED_INFLOW.sql
h.
FR2052A_SECURED_OUTFLOW.sql
i.
FR2052A_UNSECURED_INFLOW.sql
j.
FR2052A_WHOLESALE_OUTFLOW.sql
2.
Execute the batch <<INFODOM>>_USFED_FR2052A_RESAVEDEPV after the previous SQL scripts
are executed.
3.
The following SQL statement must be executed in Config Schema, if this
INDEX is not created:
CREATE INDEX index_mdr_mod_parent_child
ON mdb_object_dependencies
(parent_object_def_id,child_object_def_id)
COMPUTE STATISTICS
/
Post USFED Run
Execution
The post US FED run
execution steps required for this release are:
1.
For prior date
reporting, please see the Prior
Date Reporting document
2.
After US FED run
execution is completed, execute the following batch:
##INFODOM##_USFED_RUNEXE_RESAVE
List of Bugs
Fixed in This Release
The bugs fixed in this
release are as follows.
|
Component |
Sub Component |
Bug ID |
Subject |
|
Metadata |
– |
CLARIFICATIONS
ON RC-C PART II - LOANS TO SMALL BUSINESS AND SMALL FARMS |
|
|
– |
RCFAH314
MISSING IN HIERARCHY_MEASURE_LINKAGE DOCUMENT |
||
|
– |
RCFAH313
MISSING IN HIERARCHY_MEASURE_LINKAGE DOCUMENT |
||
|
– |
MISSING
POPULATION OF AGENCY TYPE IN FCT_REG_ACCOUNT_SUMMARY |
||
|
– |
CLARIFICATION
REQUIRED ON USAGE OF MDRM CODE-RCFDC391 IN FFIEC-031 (RC-C) |
||
|
– |
FR-2052A:
DUPLICATE VALUES IN LOMBARD WRAPPER VIEWS |
||
|
– |
FR-2052A:
T2T_FCT_REG_ACCOUNT_SUMMARY - FK ERROR IN THE T2T |
||
|
– |
REPORTING
ENTITY COLUMN HOLDS NULL VALUES IN THE FR2052A_DEPOSITS_OUTFLOW VIEW |
||
|
– |
I.S.7
DE-DEFR124 JOIN ISSUE CAUSING DUPLICATE RECORDS |
||
|
– |
FR-2052A:
FRRLEM SHOULD BE JONED WITH DERIVING TABLE |
||
|
– |
INCORRECT
ACCTPRIAMTBAND BAND CODE USED FOR MDRMS RCON5582, RCON5583, RCON5588,
RCON5589 |
||
|
– |
FR-2052A:
COLLATERAL CURRENCY CAN BE NULL FOR OUTFLOW OTHER PID'S (O.O.*) |
||
|
– |
FR-2052A:
PRODUCT AND PID COLUMNS ARE FLIPPED IN THE FR2052A_OTHER_OUTFLOW VIEW |
||
|
– |
FR-2052A:
INTERNAL COUNTERPARTY TAG NOT COMING UP IN LOMBARD XML |
||
|
– |
FR-2052A:
RUNSKEY JOIN MISSING |
||
|
– |
OUTFLOW
/ INFLOW EXPOSURES MOVING INTO EACH OTHER DES |
||
|
– |
FR-2052A:
INTERNAL COUNTERPARTY TAG NOT COMING UP IN LOMBARD XML |
||
|
– |
FR-2052A:
VIEW CHANGES TO CONVERT AMOUNT COLUMN <=10000 TO 0 |
||
|
– |
FR-2052A:
INCONSISTENCY IN METRICS |
||
|
– |
FR-2052A:
INTERNAL COUNTERPARTY AND REPORTSCOPE TAG NOT COMING UP IN LOMBARD XML |
||
|
– |
METADATA
REPORT UTILITY SCREEN UI ISSUES |
||
|
Hierarchy |
USING
INCORRECT FILTER 'HVCRE' IN DIM_BASEL_ASSET_CLASS.V_BASEL_ASSET_CLASS_CODE |
||
|
Derived Entities |
FR-2052A:
DE JOINS NEEDS TO BE CHANGED |
||
|
Business Processors |
THE
INTERNAL COUNTERPARTY FOR FR-2052A REPORT IN LOMBARD IS NOT AT A MLE LEVEL |
||
|
CAPABILITY
TO PROCESS THE NEGATIVE AMOUNTS FOR EXCESS NOSTRO ACCOUNTS (I.U.4) |
|||
|
Report Templates |
– |
FEW
COLLATERAL STOCK GROUP CODE FILETRS ARE MISSING IN LOMABRD REPORT |
|
|
Data Lineage |
– |
MDRM
BHCK2746 ON THE HCC IN DEHCC01 HAS REQUIREMENT HIRHCC20 |
|
|
– |
MDRM
RCONB531 AND RCFDB533 ON THE RCC IN DERCC004 NEED TO HAVE A HIREG065 LIMIT |
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