Oracle Financial Services Data
Management Application Pack v8.0.9.3.0 One-off Patch Release #1 (8.0.9.3.1)
|
Oracle Financial Services Data Management Application Pack is a separately licensed product.
ID 32711583 - OFSDM 8.0.9.3.1(DG): VARIANCE ANALYSIS ACCOUNT MAPPER SOR FILTERING 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 32711583 under the Patches & Updates tab.
2. Download the 32711583_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 32711583_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. |
The following bugs are fixed in this release:
Sl. No. |
Bug ID |
Bug Description |
Change Description |
1 |
32584358 |
DGS
VA - OBIEE DATA FOR BREACH IS SHOWING INCORRECTLY - MONTHLY RUN V/S QUARTER |
Breached
flag computation is now done based on the report frequency to fix this issue. |
2 |
32437962 |
DGS
VARIANCE ANALYSIS - ACCOUNT MAPPER SOR FILTERING TO BE ADDED |
A
new metadata FSI_DGS_ACCNT_MAPPER_FILTERS table is introduced, where Derived
Entity and SOR filter details must be added. Account Mapper applies filters
from the new table to load data only for the mentioned SORs. |
3 |
32413812 |
DGS
VA - DIRECT POSTING - RELEASE 80915 - PICKING OLD V_ENTITY_CODE (LEGAL
ENTITY) |
Added
latest record indicator flag to pick latest legal entity while running direct
posting batch. |
4 |
32502214 |
DGS
VA OBIEE - FMR DRILL DOWN - SOR LEVEL REPORTS ARE NOT SHOWING UP |
GL
account templates now include an intermediate drill down at the product level
similar to account templates to show aggregated data and address the
performance issue. |
5 |
32736422 |
DGS
VA - OBIEE REPORTS - RCONB549: MISSPELLED VARIANCE AND NO COMMAS IN ANY OF
THE VALUES |
Variance
spelling is corrected, and comma separators are added for all the measure
columns. |
Include the CHANGE_REQUEST(CR) to get the data
model change from VARCHAR2(50) to VARCHAR2(60)” on DIM_BATCH .V_BATCH_CODE
column. |
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