Regulatory
Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.0.0
One-off Patch Release #3 (8.0.4.0.3)
OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack is a separately licensed product.
Description
Bug
26246401 - Oracle Financial Services
Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack
v8.0.4.0.0 One-off Patch Release #3 (8.0.4.0.3)
This
release of OFS REG REP US FED is cumulative of all enhancements and bug fixes
done since v8.0.4.0.2 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.
AgileREPORTER version 1.15.3-b1033 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# 26246401
under Patches and
Updates tab.
2.
Download 26246401_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
26246401_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
3.
AgileREPORTER
requisite for Drilldown: The following steps must be executed in the same order
post Config Package deployment to change the calculation engine due to change
in system code of Config Package.
a.
Log in to the
AgileREPORTER.
b.
Click the Settings button à Administration à Config Package
Binding. A new window is
displayed as follows.
c.
Select the Calculation Engine Type as None.
Click Save.
d.
Click the Settings button à Calculation Engines.
A new window is
displayed as follows.
e.
Click the Edit
icon on left hand side pane.
A new window is
displayed as follows.
f.
Select OFSAA_USFED as Calculation Engine from drop down. Click Save.
g.
Click the Settings button à Administration à Config Package
Binding.
A new window is
displayed as follows.
h.
Select the Calculation Engine Type as DW/DT. Click Save.
Note: Ensure that DW Binding Set and DT Form Import Set have the same CONFIG
PACKAGE PREFIX (OFSAA_REG_REP_USFED_80403).
List of Bugs
Fixed in This Release
The bugs fixed in this
release are as follows.
|
Component |
Sub Component |
Bug ID |
Subject |
|
Metadata |
– |
PLACEMENT
OF FILTER CONDITION OF AMOUNT MEASURE >= 5000 IN WRAPPER VIEWS |
|
|
– |
EDIT
CHECKS REQUIRED |
||
|
Adjustment |
– |
ISSUE
IN FR2052A_OTHER_INFLOW VIEW SPECIFICALLY FOR DE DEFR161 (PID I.O.6) |
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