Oracle Financial Services Data
Management Application Pack v8.0.9.1.0 One-off Patch Release #5 (8.0.9.1.5)
|
Oracle Financial Services Data Management Application Pack is a
separately licensed product.
ID 32353216 - OFSDM
8.0.9.1.5(DG): PERFORMANCE FIXES FOR ACCOUNT MAPPER, KEY INDICATOR AND DQ
CONTROLS
The minimum patch set level must be OFS DM Application Pack
v8.0.9.1.4.
To install this release, follow these steps:
1.
Log in to My Oracle Support, and search for 32353216 under the Patches & Updates tab.
2. Download
the 32353216_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 32353216_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
11. After
successful installation, follow these steps:
a.
Clear the application cache. Navigate to the
following directories depending on the configured web application server and
delete the files:
i.
Tomcat: <Tomcat installation
location>/work/Catalina/localhost/<Application Name>/org/apache/jsp
ii.
WebLogic: <WebLogic installation
location>/domains/<Domain name>/servers/<Server name>/tmp/_WL_user/<Application
name>/<auto generated folder>/jsp_servlet
12. Delete
the existing EAR or WAR file present in the $FIC_HOME/ficweb
directory.
13. Generate
the application EAR or WAR file and redeploy the application onto your
configured web application server.
For more information on
generating and deploying the EAR or WAR file, see the Post
Installation Configuration section in the Oracle
Financial Services Data Management Pack Installation Guide 8.0.9.0.0.
14. After
the successful installation of the release, restart all OFSAAI services.
For more information,
see the Starting or Stopping Infrastructure Services
section in the Oracle
Financial Services Data Management Pack Installation Guide 8.0.9.0.0.
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. Login
to Atomic Schema and execute the script data_origin_agg_migration_script.sql.
3. Change
the Batch Ownership.
For information on
changing the batch ownership, see the Changing Batch
Ownership section in the Oracle
Financial Services Data Management Pack Installation Guide 8.0.9.0.0.
4. Execute
the DYNAMIC_KI_BATCH_CREATION batch.
For more details, see
the Oracle
Financial Services Data Management Application Pack Run Chart 8.0.9.1.0.
The following bugs are fixed in this release:
Sl. No. |
Bug ID |
Bug Description |
Change Description |
1 |
32071284 |
DGS_DQ_CTL
- TASK28 FAILURE FOR RERUN |
Resolved
Data Quality Control Batch handling for LRI flag in DIM DATA Origin and
Exception handling. |
2 |
32028683 |
DIRECT
POSTING- UI RUN KEY POPULATION SHOULD CONSIDER LEGAL ENTITY PARAMETER ALONG
WITH MIS DATE AND REPORTING FLAG OPTION |
Updated
Run Skey to filter based on the MIS date, Legal
Entity, and Reporting flag in the DIM_RUN table. |
3 |
31960543 |
DGS
VARIANCE ANALYSIS - ACCOUNT MAPPER BATCH EXCEPTION HANDLING ISSUE |
Added
Exception handling for all the ORA–Errors. |
4 |
31956510 |
DGS
- DEBUG PROCESS - FAILURE OF ACCT_MAPPER |
Added
Exception handling for all the ORA–Errors when creating intermediate lookup
tables. |
5 |
31795378 |
KI
CONFIGURATION UI ISSUE |
Updated
KI Configuration functionality for more than 1000 MDRMs. |
6 |
31612737 |
DGS
- ACCOUNT MAPPER BATCH DOES NOT HANDLE EXCEPTIONS INSTEAD SHOWS BATCH STATUS
AS SUCCESSFUL |
Added
Exception handling for all the ORA–Errors. |
7 |
31058234 |
ROUNDING
OFF ISSUES IN THE OBIEE LEVEL |
Updated
assessment value to remove the rounding off function and display the decimal
value. |
8 |
32121260 |
PERFORMANCE
ISSUES DGS- KI MAPPER BATCH |
Removed merge statement
to the Final mapper table and part of separate Task (Task6) Inserts are
happening to the final Mapper tables. |
9 |
32233220 |
DGS
KI BATCH PERFORMANCE ISSUE |
Resolved handling of
multiple Legal Entities that are executed for an MIS date to display in the
Variance Analysis dashboard. Introduced a new column n_run_skey in
the table FSI_DG_KI_GRP_RESULT to hold the runkey
for each execution and to identify the assessment key for each runkey. |
10 |
32206691 |
TASK28
- DGS DQ CTL BATCH - FSI_DGS_DQ_ERR_VAL_MAP - RECORDS REJECTED DUE TO DQ
INCORRECT FORMATS |
Added a new column in FSI_DGS_DQ_BALANCE_COL_MAP.V_SRC_PK_COLS
to remove the dependency on DQ_RESULT_DETL_MASTER. |
11 |
32204024 |
DGS
DATA ORIGIN ANALYSIS REPORT PRODUCTION PERFORMANCE ISSUE |
A new aggregated table is added to improve the report
performance. |
12 |
32180485 |
DGS
DQ - CONTROL BATCH - GATHER STATS |
Gather Stats is added on all the relevant tables in Data Quality
Control Batch. |
13 |
32263376 |
DGS
PERFORMANCE FIX - OBSERVATIONS ON HOTFIX FOR ACTION |
·
Runsky filter is added in
data origin aggregation table. ·
Account mapper final
insert function length is reduced. ·
Parallel Hint added
in the select query of data_origin_agg_migration_script. |
14 |
32353457 |
DRILL
DOWN FAILING BHCK 3298: FCT_REG_ACCOUNT_SUMMARY.N_PRIN_DUE_IN_NEXT_12M_RCY
MISSING IN RPD |
Added the column FCT_REG_ACCOUNT_SUMMARY.N_PRIN_DUE_IN_NEXT_12M_RCY
in OBI RPD. |
There 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