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

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

Description

ID 33148287 - OFSDM 8.0.9.3.4(DG): OBIEE PERFORMANCE FIXES

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 33148287 under the Patches & Updates tab.

2.       Download the 33148287_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 33148287_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

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.

Bugs Fixed in this Release

The following bugs are fixed in this release:

Sl. No.

Bug ID

Bug Description

Change Description

1

33125805

DGS OBIEE REPORTS - FFIEC 009 - DOA/VA REPORTS PERFORMANCE

Data Origin Report for 009 is optimized by loading the aggregated table and using the same in OBI.

2

33096380               

DGS - OBIEE REPORTS - ALL REPORTS - DO NOT SHOW "SEARCHING" CLOCK BY DEFAULT

Variance Analysis Reports will now only load after a valid report is selected from the Prompt.

3

33050654               

DGS VA - OBIEE CURRENT PERIOD REPORT PERFORMANCE

Redundant Data in the Current Period Report impacting the performance is now optimized.

4

33050652

DGS VA - ACCOUNT MAPPER FSI_KICOND_ACCNT_MAP PARTITION HAS STALE STATS

·         Account Mapper Code is updated to Gather Stats for Range Partitioned Tables.

·         Introduced 20 Parallel Tasks in Account Mapper.

5

33014936

DGS: VA: 80932: DATA PROMPTS LIMITED FUNCTIONALITY

Hidden Attributes in the Drill-Down Reports are removed.  

6

33014843

DGS VA - CURRENT PERIOD -- REPORT FILTERS DISPLAY TAP TO RETRY ERROR WHEN EXPERIENCING LONGER RUNS

Redundant Data in the Current Period Report impacting the performance is now optimized.

7

33050629

DGS VA - OBIEE QUERY IS TAKING HUGE TEMP SPACE IMPACTING OTHERS

Variance Analysis report was processing some redundant data due which the it was taking more time to load and more temp space was used. Now, the query is optimized to use less space.

Known Issues or Limitations in this Release

There are no Known Issues or Limitations in this release.

 


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