Regulatory
Reporting for US Federal Reserve Lombard Risk Integration Pack Release
v8.0.3.2.0 One-Off Patch #2 (8.0.3.2.2)
|
Regulatory
Reporting for US Federal Reserve Lombard Risk Integration Pack Release
v8.0.3.2.0 One-Off Patch #2 (8.0.3.2.2) |
OFS
Regulatory
Reporting for US Federal Reserve Lombard Risk Integration Pack is a
separately licensed product.
Description
ID 25820636 OFS REG REP US FED v8.0.3.2.0 ONE-OFF PATCH RELEASE #2 (8.0.3.2.2)
This release of
OFS REG REP US FED is cumulative of enhancements and bug fixes done since the
8.0.3.2.1 release.
Pre-Installation
Requirements
The pre-installation steps
required for this release are:
1. OFS
REG REP US FED 8.0.3.2.1 must be installed.
2. Agile
Reporter 1.15.2.1 must be installed.
3. AgileREPORTER
Templates (ARforFED_v1.9.0.7) is available in AgileREPORTER.
How to Install
This One-off Release?
The steps
to install the one-off patch are:
1. Login to https://support.oracle.com/, and search
for Bug# 25820636 under Patches and Updates tab.
2.
Download 25820636_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 25820636 _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_FRY2052A_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_FRY2052A_RESAVEDEPV after the previous SQL scripts
are executed.
3.
If the version of FSDF is 804,
then copy Reg Account Summary T2T files manually from
Consolidation directory of installer to FTPSHARE directory of the setup.
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 |
|
USAGE OF STANDARD
PARTY TYPE IN FR-2052A |
|
|
|
ADDITION OF LENDABLE
VALUE IN I.A.3 AND I.A.4 |
||
|
|
ADDITION OF LENDABLE
VALUE IN I.A.3 AND I.A.4 |
||
|
|
FR-2052A: CASHFLOW
TYPE IS PRIN INSTEAD OF P |
||
|
|
CONTRACTUAL MATURITY
BAND RULE IN FR2052A |
||
|
|
SEPARATE RUN REQUIRED
FOR FR-2052A - ADDITIONAL IDENTIFIER IS REQUIRED FROM LOMBARD |
||
|
|
RUSFR2052A28 WILL
CHANGE FOR HUS162 87 |
||
|
|
DATASET FILTER
CONDITION CHANGES FOR IU5 AND IU6 AND IS1 DATASET |
||
|
|
FR-2052A: UNENCUMSEC
SHOULD BE REMOVED FROM REG_IA_CF_LIQ_REP_GRP_MAP_V |
||
|
|
FR-2052A: INNER JOIN
CHANGES FOR FORWARD MATURITY BUCKET TO LOJ |
||
|
|
FR-2052A: RUNSKEY
JOIN MISSING (SR - 3-14674078321) |
||
|
|
OD1,OD2,OD3 RULE
NEEDS EXTRA FILTER FOR RETAIL |
||
|
|
RUSFR2052A27 RULE
CHANGES FOR CODE OTHACC TO OTHACT FOR OTHER ACCOUNTS |
||
|
|
FR-2052A:
ENHANCEMENT - LEND CARD SHOULD ONLY BE REPORTED AS PART OF IU5 |
||
|
|
CREATE SEPARATE
FR2052A BATCH FOR DEFRINAS,DEFROD AND DEFRINUS |
||
|
|
FR-2052A: COLLATERAL
ARE NOT AVAILABLE BUT DEFR008 HAS INNER JOIN WITH COLLATERAL TABLES |
||
|
|
FR-2052A: REG
INSURER, SWEEP ACCOUNTS AND DIM_PARTY ISSUE |
||
|
|
MDRM CODES OF FRY-9C
ARE NOT PRESENT IN HIERARCHY_MEASURE_LINKAGE DOCUMENT |
||
|
|
BHCKA517, BHCKA518,
BHCK6761, BHCK4172: SHOWS FCT_MGMT_REPORTING INSTEAD OF REG_REP |
||
|
|
HUS210: UNABLE TO
SAVE THE METADATA |
||
|
|
CHANGE IN RULE FOR
SWEEP DEPOSIT ACCOUNTS |
||
|
Metadata |
Rules |
ISSUE AROUND REG
PROD TYPE CODES USED IN THE BANDING RULES IN 80311 |
|
|
Metadata |
Hierarchy |
MISSING MEMBER CODES
IN DIMENSION TABLES |
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