Oracle Financial Services Data
Management Application Pack v8.0.9.3.0 One-off Patch Release #2 (8.0.9.3.2)
|
Oracle 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.8.1.
ID 32786008 - OFSDM 8.0.9.3.2(DG): COMPATIBILITY RELEASE WITH RESPECT TO USFED 80981 AND BUG FIXES
The minimum patch set level must be OFS DM Application Pack v8.0.9.3.0.
To install this release, follow these steps:
1. Log in to My Oracle Support, and search for 32786008 under the Patches & Updates tab.
2. Download the 32786008_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 32786008_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
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 SQL Loader for loading data to FSI_RR_CTL_MAP.
a. Navigate to the following path to find the SQL loader file.
<context>/ficweb/webroot/sqlLoaderFiles
b. Navigate to the following path to find the sqlloader.sh file.
<context>/ficdb/bin
c. The following is the command to execute the sqlloader.sh:
./sqlLoader.sh <INFODOM> <COMPLETE PATH OF sqlLoaderFiles folder>
NOTE |
Before loading the data into FSI_RR_CTL_MAP ensure that the following
Index(s) are stable or in valid state. ·
FSI_RR_CTL_UDX ·
PK_FSI_RR_CTL_MAP |
3. 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.3.0.
4. 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.3.0.
5. 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.
6. 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.3.0.
The following bugs are fixed in this release:
Sl. No. |
Bug ID |
Bug Description |
Change Description |
1 |
32584300 |
DGS
VARIANCE ANALYSIS- MDRM VS MDRMWORK |
MDRM
work cells are converted to normal cells. A new batch DGS_KI_MDRM_UPDATE is
introduced to perform this conversion. |
2 |
32227332 |
DGS
DATA ORIGIN ANALYSIS REPORT - REQUIREMENT TO ADD 'CELL LINE ITEM' COLUMN |
Cell
Line Item is added to Data Origin Report. |
3 |
32614057 |
DGS
VA UAT2 - SUMMARY V/S DRILL DOWN MISMATCH - CASE CONDITION LOGIC |
MDRM
mismatch issue is resolved with the latest queries with respect to US FED
v8.0.9.8.1. |
4 |
32768562 |
DGS
VA - 80930 - FSI_DGS_DATA_ORIGIN_AGG TABLE INSERT |
Resolved
the issue to load the data into the FSI_DGS_DATA_ORIGIN_AGG table. |
5 |
32772027 |
DGS
VA - BATCH EXECUTION - ACCOUNT MAPPER PROCESS ERROR DIDN'T FAIL BATCH |
Account
Mapper batch is updated to fail the task in case the Temp table creation
fails. |
6 |
32766264 |
DGS
VA - ERROR LOGGING ISSUES FSI_DGS_ERROR_LOG |
Error
Message logging is improved, and some records inserted for
FSI_DGS_DATA_ORIGIN_AGG are captured in the log table. |
7 |
32779500 |
DGS
VA 80930 - MDRM COMPATIBILITY ISSUE |
MDRM
mismatch issue is resolved with the latest queries with respect to US FED
v8.0.9.8.1. |
8 |
32771740 |
DOA
TO DGS VA DIFFERENCE ON FINAL VALUE |
DOA
Report Data aggregation is corrected for GL, now its matches with VA. |
9 |
32447326 |
DGS
VA - INCORRECT THRESHOLD SETTING - FCT_KI_DEF_THRSLD |
Threshold
Breach computation is improved so that all the ranges are considered during
breach evaluation. |
10 |
32767234 |
DGS
- DOA REPORTS - MISMATCH BETWEEN ACTUAL VALUES AND OBIEE REPORTS |
Duplicate
entries removed from the following tables FCT_KRI_DEF, FSI_RR_KI_MAP, and
DIM_KEY_INDICATOR. |
The following are the Known Issues or Limitations in this release:
Sl. No. |
Bug ID |
Bug Description |
1 |
32928802 |
DRILL
DOWN NOT SUPPORTED FOR GRANULARITY OTHER THAN ACCOUNTS AND GL FOR THE REPORTS
FFIEC-031, FFIEC-041, FRY-9C AND FRY-15 |
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