Oracle Financial Services Data Management Application Pack v8.0.9.3.0 One-off Patch Release #7 (8.0.9.3.7)

Oracle Financial Services Data Management Application Pack is a separately licensed product.

This One-off Patch is released for Data Governance qualification on US Fed Regulatory Reporting Release v8.0.9.8.4.

Description

ID 33384560 - OFSDM 8.0.9.3.7(DG): COMPATIBILITY RELEASE WITH RESPECT TO USFED 8.0.9.8.4

Pre-installation Requirements

The minimum patch set level must be OFS DM Application Pack v8.0.9.3.0.

Installing this Release

To install this release, follow these steps:

1.        Log in to My Oracle Support, and search for 33384560 under the Patches & Updates Tab.

2.       Download the 33384560_GENERIC.zip archive file and copy it to your OFSAA Server in Binary Mode.

3.       Shut down all the OFSAAI Services.

For more information, see the Stopping Infrastructure Services section in Oracle Financial Services Data Management Pack Installation Guide 8.0.9.0.0.

4.      Extract the contents of the patch archive file using the command:

unzip -a <name of the file to be extracted>

For example: unzip -a 33384560_GENERIC.zip

Note: The "-a" option is mandatory to unzip the patch.
If you notice the error message: “unzip: not found [No such file or directory” before the package is installed, contact your UNIX administrator.

5.       Assign RWX (755) permissions to the folder by executing the command:

chmod -R 755 OFS_DM

6.      Navigate to the following directory:

<>/OFS_DM/conf

7.       Update the params.conf file with the upload model parameter as 0.

8.      Navigate to the following directory:

<>/OFS_DM/bin

9.      Execute the install command:

./install.sh

10.   Verify the patch installation logs in the following directory:

<>/OFS_DM/logs

11.     After successful installation, follow these steps:

a.       Clear the application cache. Navigate to the following directories depending on the Configured Web Application Server and delete the files:

                                                                         i.            Tomcat: <Tomcat installation location>/work/Catalina/localhost/<Application Name>/org/apache/jsp

                                                                       ii.             WebLogic: <WebLogic installation location>/domains/<Domain name>/servers/<Server name>/tmp/_WL_user/<Application name>/<auto generated folder>/jsp_servlet

12.    Delete the existing EAR or WAR file present in the $FIC_HOME/ficweb directory.

13.    Generate the application EAR or WAR file and redeploy the application onto your Configured Web Application Server.

For more information on generating and deploying the EAR or WAR file, see the Post Installation Configuration Section in the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.0.0.

14.   After the successful installation of the release, restart all OFSAAI Services.

For more information, see the Starting or Stopping Infrastructure Services Section in the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.0.0.

Post-installation Steps

The post-installation steps required for this release are as follows:

1.        Copy the DGS.catalog file from the <FIC_HOME>/DGSBI directory to your local machine and redeploy the DGS.catalog file.

2.       Execute the SQL Loader for loading data to FSI_RR_CTL_MAP.

a.       Navigate to the following path to find the SQL loader file.

                                <context>/ficweb/webroot/sqlLoaderFiles

b.       Navigate to the following path to find the sqlloader.sh file.

                               <context>/ficdb/bin

c.       The following is the command to execute the sqlloader.sh:

./sqlLoader.sh <INFODOM> <COMPLETE PATH OF sqlLoaderFiles folder>

NOTE

1.     Before loading the data into FSI_RR_CTL_MAP ensure that the following Index(s) are stable or in a valid state.

·         FSI_RR_CTL_UDX

·         PK_FSI_RR_CTL_MAP

2.     In case SQL loader must be rerun, ensure to run the following in atomic schema:

delete from FSI_RR_CTL_MAP where V_REPORT_NAME in('FFIEC-031','FFIEC-041','FRY-9C');

 

1.        Execute the MERGE_FCT_KRI_DEF batch.

For more details, see the Merging Key Indicators Section in the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.3.0.

2.       Execute the FCT_KRI_DEF_UPDATE batch.

For more details, see the Updating Measures for Key Indicators Section in the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.3.0.

3.       Execute the DGS_KI_MDRM_UPDATE batch. This batch is used to convert work cells to normal cells. Enter the current system date as the MISDATE for this batch.

4.      Execute the KI_CONFIGURATION batch.

For more details, see the Key Indicator Configuration Section in the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.3.0.

Bugs Fixed in this Release

There are no Bugs Fixed in this release.

Known Issues or Limitations in this Release

The following is the Known Issue in this release:

Sl. No.

Bug ID

Bug Description

1

33414305

DRILL DOWN NOT SUPPORTED FOR CELLS RELATED TO THE GRAIN REG_LE_CAPITAL_SUMMARY

Oracle Financial Services Software   |   Copyright © 2021, 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