Financial
Services Data Governance for North America Regulatory Reporting Release
8.1.2.0.0.0 One-off Patch Release #2 (8.1.2.0.2) |
Oracle Financial Services Data Governance for North America Regulatory Reporting Pack is a separately licensed product.
ID 34190611: DG81202 CANADA CONTENT REFRESH
The minimum patch set level must be OFS DGS North America Regulatory Reporting Application Pack v8.1.2.0.0.
To install the release, follow these steps:
1. Log in to My Oracle Support, and search for 34190611 under the Patches & Updates Tab.
2. Download the 34190611_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 • Stop the Infrastructure Services Section in the OFS AAI Installation and Configuration Guide Release 8.1.2.0.0.
4. Extract the contents of the patch archive file using the command:
Unzip <name of the file to be extracted>
For example: unzip 34190611_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. Verify the patch installation logs in the following directory:
<>/OFS_DGS/logs
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. 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 following 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
13. Delete the existing EAR or WAR file present in the $FIC_HOME/ficweb directory.
14. Generate the application EAR or WAR file and redeploy the application on 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 OFS AAI Installation and Configuration Guide Release 8.1.2.0.0.
15. Restart the OFSAAI services. For more information, see the Starting Infrastructure Services section in the OFS AAI Installation and Configuration Guide Release 8.1.2.0.0.
The post-installation steps required for this one-off release are as follows:
1. Perform the Regulatory Reporting Deployment steps. For more information, see the Regulatory Reporting Deployment Steps section in the Oracle Financial Services Data Governance for North America Regulatory Reporting Pack Installation Guide 8.1.2.0.0.
2. Execute the MERGE_FCT_KRI_DEF batch.
For more details, see the Merging Key Indicators Section in the Oracle Financial Services Data Governance for North America Regulatory Reporting Pack Installation Guide 8.1.2.0.0.
3. Execute the FCT_KRI_DEF_UPDATE batch.
For more details, see the Updating Measures for Key Indicators Section in the Oracle
Financial Services Data Governance for North America Regulatory Reporting Pack
Installation Guide 8.1.2.0.0.
4. Execute the KI_CONFIGURATION batch.
For more details, see the Key Indicator Configuration Section in the Oracle Financial Services Data Governance for North America Regulatory Reporting Pack Installation Guide 8.1.2.0.0.
5. Assessment based on Report and Legal Entity flag is enabled in Key Indicator Assessment. The flag ASSMT_BASED_ON_REPORT_AND_LE must be marked as Y when Assessment has to happen based on Report and Legal Entity combination.
If the ASSMT_BASED_ON_REPORT_AND_LE flag is marked as N then Assessment will happen for all Legal Entities.
If the ASSMT_BASED_ON_REPORT_AND_LE flag is marked as Y, then ensure that the Report and Legal Entity mapping is defined in the FSI_M_REPORT_LE_MAP Mapping Table.
NOTE: Ensure that Multiple Legal Entities are not mapped to a single Report.
Table: fsi_dgs_configuration
V_MODULE_NAME |
V_LOOKUP_CODE |
N_LOOKUP_VALUE |
V_LOOKUP_CODE_DESC |
KI |
ASSMT_BASED_ON_REPORT_AND_LE |
Y |
This
Flag enables to compute the Key Indicator Assessment based on Report and
Legal Entity configuration. |
6. Execute the following script:
§ DG81202_post_install_script.sql
§ fct_reg_run_legal_entity_map.sql
7. If you want to run the Account Mapper Batch for the same MIS Date and Run Skey combination, then you need to delete the data from the FSI_KI_REG_FUND_LEND_EXP_MAP table. And then run the Account Mapper Batch.
There are no bugs fixed in this one-off release.
The known issue in this one-off release is as follows:
Sl. No. |
Bug ID |
Bug Description |
1 |
34246271 |
DG
81202: MIS MATCHES BETWEEN ACCOUNT MAPPER AND ASSESSMENT VALUES |
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