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

OFS 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.6.1.

Description

ID 31977571 - OFSDM 8.0.9.1.1(DG): VARIANCE KEY INDICATOR REFRESHED TO BE COMPATIBLE WITH USFED 80961 METADATA AND SOR ENHANCEMENT.

Pre-installation Requirements

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

Installing this Release

To install this release, follow these steps:

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

2. Download the 31977571_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 the Oracle Financial Services Data Management Pack Installation Guide 8.0.9.1.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 31977571_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.

2. 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.1.0.

3. 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.1.0.

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.1.0.

Bugs Fixed in this Release

The following bugs are fixed in this release.

Sl. No.	Bug ID	Bug Description	Change Description
1	31960099	DQ EXCEPTION SUMMARY PAGE NEED TO BE SHOWN THE MDRM AND DQ WISE CELL AND EXCEPTION AMOUNT	Two additional columns are added to display the MDRM and Data Quality wise exception amount.
2	31960077	DQ EXCEPTION REPORT TO BE SUPPORTED FOR DATA ORIGIN (SOR)	SOR is added as an additional feature to filter the Data Quality exceptions.
3	31599957	DGS - DIRECT POSTING ISSUE NAME MUST BE UNIQUE	The issue name is appended with the assessment ID.
4	31541562	JOINS WITH DIMENSIONS IN T2TS MISSING FILTER TO CHECK ONLY LATEST RECORDS	Record Start Date and End Date filter from the dimensions are used in the T2Ts.
5	32013237	CONTROL DASHBOARD TO SHOW DQ SOR LEVEL RECORD SCAN, FAILED DETAILS	SOR related Data Quality details for the control can be viewed from the Control Dashboard.

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