OFSS.png

Oracle Financial Services Data Management Application Pack v8.0.9.1.0 One-off Patch Release# 2 (8.0.9.1.2)

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

Description

ID 32012388 - OFSDM 8.0.9.1.2(DG): OCT CPU CHANGES AND VARIANCE PERCENTAGE IN VARIANCE ANALYSIS DASHBOARD.

Pre-installation Requirements

The minimum patch set level must be OFS DM Application Pack v8.0.9.1.0 and OFS AAI Maintenance Level v8.0.9.3.0 (ID 31656153).

Installing this Release

To install this release, follow these steps:

NOTE

In an environment consisting of multiple OFSAA applications, if the October 2020 Critical Patch Update is applied for any one application, it is mandatory to apply the respective October 2020 Critical Patch Updates for all other applications on that OFSAA instance, regardless of the application’s version. See the My Oracle Support Doc ID 2724021.1 for details.

 

1.        Log in to My Oracle Support, and search for 32012388 under the Patches and Updates tab.

2.       Download the 32012388_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 32012388_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 and DGS.rpd files from the <FIC_HOME>/DGSBI directory to your local machine and redeploy the DGS.catalog and DGS.rpd files.

NOTE

New tables are not added in the RPD file to define Opaque views.

 

Third-Party Library Upgrades
The third-party library upgraded in this release:

·         jQuery - from 3.4.1 to 3.5.1

Bugs Fixed in this Release

The following bugs are fixed in this release.

Sl. No.

Bug ID

Bug Description

Change Description

1

32009711

DQ CTL BATCH - TASK 4 - PARTITION ON FCT_DGS_DP_RECORD_STATS 

Added partition in FCT_DGS_DP_RECORD_STATS table on N_MIS_DATE_SKEY column.

2

32009816

DGS - DQ CTL - TASK 4 - FCT_DGS_DP_RECORD_ATTR_STATS INSERT - LONG RUNNING

Added partition on FCT_DGS_DP_RECORD_STATS table and using DQ_RESULT_SUMM_MASTER to retrieve the data and also added FIC_MIS_DATE filter on the DQ_RESULT_DETL_MASTER table.

3

32039533

DGS VARIANCE ANALYSIS -- FIRST LEVEL DRILL DOWN NOT MATCHING (VARIANCE % CALC BETWEEN FINAL VALUES OF CURRENT AND PREVIOUS PERIOD) 

Variance Percentage is computed on all account templates.

Known Issues or Limitations in this Release

The are no known issues or limitations in this release.

 

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