Financial
Services Data Governance for US Regulatory Reporting Release 8.1.0.1.0
One-off Patch Release #1 (8.1.0.1.1) |
Oracle Financial Services Data Governance for US Regulatory Reporting Pack is a separately licensed product.
ID 33241820 - DG 8.1.0.1.1: RELEASE FOR DEFECT REMEDIATION
· The minimum patch set level must be OFS DGUSRR Application Pack v8.1.0.1.0 and US Fed Regulatory Reporting Release 8.1.1.0.0.
· In case you have installed US Fed Regulatory Reporting Release v8.1.1.1.0, ensure to run the following script in Config Schema:
1. DELETE ofsaa_installer_execution_storage
WHERE
v_app_id =
'OFS_REG_REP_USFED'
AND v_app_version
= '8.1.1.1.0'
AND v_task_name =
'CONDITIONAL_WEB_LAYER_DEPLOYMENT';
2. DELETE FROM installer_fsapps_scripts_details
WHERE
v_app_id =
'OFS_REG_REP_USFED'
AND v_app_version
= '8.1.1.1.0'
AND v_file_name
IN ( 'DG80934_config_inserts.sql', 'pkg_ki_mapper.sql', 'DG80934_atomic_create.sql',
'DG80935_atomic_create.sql',
'con_DE_insert_fsi_cell_bireport_map.sql',
'PKG_DGS_KI_GRP_ASSESSMENT.pck' );
3. Commit;
To install the release, follow these steps:
1. Log in to My Oracle Support, and search for 33241820 under the Patches & Updates Tab.
2. Download the 33241820_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 33241820_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
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 DGS_KI_MDRM_UPDATE batch. This batch is used to convert work cells to normal cells. Enter the current system date as the MISDATE for this batch.
The following bugs are fixed in this release:
Bug ID |
Bug Description |
Change Description |
|
1 |
33180967 |
DGS VA - OBIEE - GL ACCOUNT DETAILS- BHCK2130-
VARIANCE % IN GRID MISSPELLING AS "VARIANCE" |
Variance spelling is corrected in the required
templates. |
2 |
32978589 |
DGS VA - ACCOUNT DRILL DOWN (LEVEL 2) - NEW ACCOUNT
AND CLOSED ACCOUNT - DOCUMENTATION CHANGE |
New and Closed Account Logic is updated to show the
delta accounts between the two periods. |
3 |
32231644 |
DGS VA ENHANCEMENT - VARIANCE REPORT REQUIRED TO
SUPPORT REPORT FOR TWO RUNS ON SAME REPORTING DATE |
A new Variance Analysis report to compare multiple
runs are created. |
4 |
32063444 |
UNABLE TO COMPARE DGS REPORT FOR THE MULTIPLE RUNS
FOR THE SAME FIC_MIS DATE |
A new Variance Analysis report to compare multiple
runs are created. |
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