https://docs.oracle.com/cd/E99053_01/dcommon/img/OFSS.PNG

Financial Services Data Governance for US Regulatory Reporting Release 8.1.0.2.0 One-off Patch Release #5 (8.1.0.2.5)

Oracle Financial Services Data Governance for US Regulatory Reporting Pack is a separately licensed product.

Description

ID 34091062 - DG 81025: KI ASSESSMENT BASED ON REPORT CODE AND LEGAL ENTITY MAPPING

Pre-installation Requirements

The minimum patch set level must be OFS DGUSRR Application Pack v8.1.0.2.4.

Prerequisite

Before you start installing this patch, run the following query Config schema:

delete from  INSTALLER_FSAPPS_SCRIPTS_DETAILS where V_FILE_NAME in('FN_KI_GRP_BATCH_PROCESS.sql','sp_ki_grp_map_details.sql','PKG_DGS_KI_GRP_ASSESSMENT.pck');

commit;

Installing this Release

To install the release, follow these steps:

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

2.       Download the 34091062_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 Governance for US Regulatory Reporting Installation and Configuration Guide.

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

Unzip <name of the file to be extracted>

For example: unzip 34091062_GENERIC.zip

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

·       chmod -R 755 OFS_DGS

·       chmod -R 755 appsLibConfig

6.      In the Installer Kit Path /appsLibConfig/conf:

a.       Update the params.conf file with the Upload Model Parameter as 0.

7.       Navigate to the following directory:

<>/OFS_DGS/bin

8.      Execute the install command:

./setup.sh SILENT

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

<>/OFS_DGS/logs

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

For more information, see the Starting or Stopping Infrastructure Services Section in Oracle Financial Services Data Governance for US Regulatory Reporting Installation and Configuration Guide.

Post-Installation Steps

Report and Legal Entity Configurations for Key Indicator Assessments

1.        After installation is done, provide the required Jurisdiction Report Code and Legal Entity details in the FSI_M_REPORT_LE_MAP table.

NOTE: Ensure that Multiple Legal Entities are not mapped to single Report.

2.       Assessment based on Report and Legal Entity flag is enabled in Key Indicator Assessment. The flag ASSMT_BASED_ON_REPORT_AND_LE must be marked as Y when Assessment has to happen based on Report and Legal Entity combination.

If the ASSMT_BASED_ON_REPORT_AND_LE flag marked as N then Assessment will happen for all Legal Entities.

Table: fsi_dgs_configuration

V_MODULE_NAME

V_LOOKUP_CODE

N_LOOKUP_VALUE

V_LOOKUP_CODE_DESC

KI

ASSMT_BASED_ON_REPORT_AND_LE

Y

This Flag enables to compute Key Indicator Assessment based on Report and Legal Entity configuration.

 

Bugs Fixed in this Release

The following bug is fixed as part of this one-off release:

Sl. No.

Bug ID

Bug Description

1

34063294

Issues with respect to DGS Variance Analysis Dashboard

Known Issues or Limitations in this Release

There are no Known Issues or Limitations in this release.

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