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 #3 (8.1.0.2.3)

 

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

Description

ID 33914756 - DG 81023: OBIEE AND T2T RELATED BUG FIXES

Pre-installation Requirements

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

Installing this Release

To install the release, follow these steps:

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

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

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

12.    Execute the following script in the Config Schema:

UPDATE BATCH_TASK_PRECEDENCE_MASTER SET V_PARENT_TASK_ID = 'Task11' WHERE  v_batch_id='##INFODOM##_DGS_DQ_CTL_BATCH' and V_TASK_ID='Task4';

UPDATE BATCH_TASK_PRECEDENCE_MASTER SET V_PARENT_TASK_ID = 'Task4' WHERE  v_batch_id='##INFODOM##_DGS_DQ_CTL_BATCH' and V_TASK_ID='Task12';

UPDATE BATCH_TASK_PRECEDENCE_MASTER SET V_PARENT_TASK_ID = 'Task3' WHERE  v_batch_id='##INFODOM##_DGS_DQ_CTL_BATCH' and V_TASK_ID='Task5';

commit;

NOTE: Replace the placeholder ##INFODOM## with the actual Infodom name.

13.    Execute the following script in the Atomic Schema (only if you are aleady having GL 8.1.1.1.0 on the same environment):

declare

v_count int;

v_count1 int;

begin

select count(*) into v_count from user_tables where table_name = upper('FSI_KI_REP_SCH_CELL_CONFIG');

select count(*) into v_count1 from user_tab_columns where table_name = upper('FSI_KI_REP_SCH_CELL_CONFIG') and COLUMN_NAME in('V_WORK_CELL_ID');

if (v_count>0) then

if (v_count1=0) then

execute immediate 'alter table FSI_KI_REP_SCH_CELL_CONFIG  add (V_WORK_CELL_ID VARCHAR2(100 BYTE))';

end if;

end if;

end ;

/

Bugs Fixed in this Release

The following bugs are fixed in this Release.

Sl. No.

Bug ID

Bug Description

1

33960948

DATE PROMPT NOT PASSING TO IMPACT ANALYSIS PAGE WHEN NAVIGATED FROM IMPACT SUMMARY PAGE IN DATA QUALITY DASHBOARD

2

33960932

ADDITIONAL PP TABLES(STAGE LEASE, STAGE LOAN ETC) ARE DISPLAYED IN THE CONTROL RATING DRILL DOWN WHICH ARE NOT PART OF THE DQ EXECUTION

3

33958190

LATEST RECORD INDICATOR TO BE USED FOR DIM_KI_GROUP

4

33958180

ISSUE COUNT DISPLAYED IN KEY INDICATOR DASHBOARD NOT IN SYNC WITH VARIANCE ANALYSIS DASHBOARD

5

33958166

CALCULATION OF DQ REJECTS % S NOT CORRECT IN IMPACT ANALYSIS DASHBOARD

6

33958161

DATA QUALITY DASHBOARD ISSUES RELATED TO DRILL DOWN AND SELECTION OF ITERATION FROM HOME PAGE

7

33958148

CONTROL DASHBOARD ISSUES RELATED TO DRILL DOWN AND CONTROL BY REGULATORY REPORT

8

33958123

DGS_DQ_CTL_BATCH TASK21 AND TASK22 TAKE A LONG TIME TO COMPLETE

9

33910587

AGILE REPORTER TO DGS VA INTEGRATION ISSUE

10

33796039

QUALITY CONTROL EFFECTIVENESS TREND DOES NOT REFRESH WITH CHANGE IN DATA

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