Oracle Financial Services Capital Adequacy Application Pack v8.1.0.1.0 One-off Patch Release #3 (8.1.0.1.3)

OFS Financial Services Capital Adequacy Application Pack is a separately licensed product.

Description

ID 32639652 - OFS CAP APPLICATION PACK 8.1.0.1 ONE-OFF PATCH RELEASE #3 (8.1.0.1.3)

Pre-installation Requirements

The minimum patch set level must be OFS CAP Application Pack release 8.1.0.1.2.

This patch is compatible with the OFS AAI release 8.1.1.0.0.

Pre-installation Steps

1. PR2 TABLES in CONFIG SCHEMA

a. Take back up of the tables PR2_RULE_QUERY, PR2_RUN_EXECUTION_FILTER, and PR2_RUN_EXECUTION_B.

b. Truncate the tables in the following order: PR2_RULE_QUERY, PR2_RUN_EXECUTION_FILTER, PR2_RUN_EXECUTION_B.

2. INSTALLER_FSAPPS_SCRIPTS_DETAILS

Take back up of the table INSTALLER_FSAPPS_SCRIPTS_DETAILS and execute the below delete statement in CONFIG Schema.

DELETE FROM INSTALLER_FSAPPS_SCRIPTS_DETAILS WHERE V_FILE_NAME IN ('DM_T2T_FRCAS_FSI_CAP_BANKING_EXPOSURES.sql','DM_T2T_FRCAS_FSI_CAP_DERIVATIVES.sql','DM_T2T_FRCAS_FSI_CAP_INVESTMENT_EXPOSURES.sql','DM_T2T_FRCAS_FSI_CAP_SFT_EXPOSURES.sql','DM_T2T_FCT_REG_LE_CAPITAL_SUMMARY.sql','DM_T2T_FSI_CAP_EXPOSURES_POST_CRM.sql');

DATA MODEL CHANGES

The Data Model Changes are shared as a .erwin file.� You can upload the Data Model XML file before or during the patch installation.

If you re-apply the patch on a setup that already has CAP ADQ PACK 8.1.0.1.3 installed, perform the following steps:

1. Back up the tables INFODOM_PATCHES, INSTALLER_FSAPPS_SCRIPTS_DETAILS, and OFSAA_INSTALLER_EXECUTION_STORAGE in CONFIG Schema.

2. Perform the following actions for the tables INFODOM_PATCHES, INSTALLER_FSAPPS_SCRIPTS_DETAILS, and OFSAA_INSTALLER_EXECUTION_STORAGE and commit the changes:

� DELETE FROM INFODOM_PATCHES WHERE V_APP_ID = 'OFS_BASEL_BASIC' AND V_PATCH_NAME = '8.1.0.1.3'.

� DELETE FROM INSTALLER_FSAPPS_SCRIPTS_DETAILS WHERE V_APP_ID = 'OFS_BASEL_BASIC' AND V_APP_VERSION = '8.1.0.1.3'.

� DELETE FROM OFSAA_INSTALLER_EXECUTION_STORAGE WHERE V_APP_ID = 'OFS_BASEL_BASIC' AND V_APP_VERSION = '8.1.0.1.3'.

New Features

In the OFS Basel Regulatory Capital Release 8.1.0.1.3, the following feature is included:

� Capital Structure:

As part of a common design change, the computed standard accounting heads that were previously taken as a download in the stage standard accounting head (STG_STANDARD_ACCT_HEAD), are now expected as a download in the FSI Standard Accounting Head table (FSI_STANDARD_ACCT_HEAD). This provides the capability to build the required integration between a solo run and a consolidated run for consuming the computed fields from the solo run or any other previous run for computing the various required calculation.

The significant and insignificant exposures were previously stamped by the accounting head related to the total exposure level. However, for ease of identification, the same has now been moved to a specific accounting head of direct, indirect, and synthetic exposures of significant and insignificant transactions.

Installing this Release

To install this release, follow these steps:

1. Log in to My Oracle Support, and search for 32639652 in the Patches & Updates tab.

2. Download the 32639652_GENERIC.zip archive file and copy it to your OFSAA server in Binary mode.

3. Extract the contents of the patch archive file using the following command:

unzip -a <name of the file to extract>

For example, unzip -a 32639652_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 you install the package, contact your UNIX administrator.

4. Update the following parameters in the params.conf file in the directory path appsLibConfig/conf/ as per the comments detailed in the file:

o UPLOAD_MODEL

o MODEL_TYPE

o DATA MODEL

o DM_DIRECTORY

NOTE

The DATA MODEL changes associated with this release are shared in an excel file (see DATA MODEL CHANGES section above). You must set the value for UPLOAD_MODEL as 1 if you need to upload any DATAMODEL XML during the installation. If DATAMODEL upload is not applicable during installation, you must set the value UPLOAD_MODEL as 0.

5. Provide RWX permissions to the following shell script in the directory path ./OFS_BASEL_BASIC/bin:

setup.sh.

6. Stop All OFSAA services and Web services.

For more information, see the Starting or Stopping Infrastructure Services section in the Oracle Financial Services Capital Adequacy Pack Installation Guide 8.1.0.0.0.

7. Execute the following install command in the directory path ./OFS_BASEL_BASIC/bin:

./setup.sh

8. Verify the log file OFS_BASEL_BASIC_installation.log in the following directory to ensure that the patch is applied successfully:

./OFS_BASEL_BASIC/logs

9. Clear the application cache. Delete the files for the web application server that you configured as per the following table:

Web Application Server	Directory Path
Tomcat	<Tomcat installation directory>/work/Catalina/localhost/<Application name>/org/apache/jsp
WebLogic	<Weblogic installation location>/domains/<Domain name>/servers/<Server name>/tmp/_WL_user/<Application name>/<auto generated folder>/jsp_servlet
WebSphere	<Websphere installation directory>/AppServer/profiles/<Profile name>/temp/<Node name>/server1/<Application name>/<.war file name>

10. Generate the application EAR or WAR file and redeploy the application on your configured web application server.

For more information, see Create and Deploy the EAR or WAR Files.

11. Perform the following steps if the OFS AAI Infrastructure release 8.1.1.0.0 is installed:

a. cd $FIC_DB_HOME/bin

b. Execute the following shell script:

./updatePipelineType.sh

12. 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 Capital Adequacy Pack Installation Guide 8.1.0.0.0.

Post-installation Steps

1. Restore PR2_RULE_QUERY, PR2_RUN_EXECUTION_FILTER, and PR2_RUN_EXECUTION_B tables, if required for the Run Execution Audit.

2. Open the existing Run Definitions in the �Regulatory Calculation Definitions� screen and resave the definitions to sync them with the new Run Parameters.

Bugs Fixed in this Release

The functionality on the rating standardization and asset class categorization were updated in the reporting tables for ease of reporting consumption, and the reporting data population at an account and asset class granularity was provided by the processing layer.

Known Issues or Limitations in this Release

The following Known Issues are applicable in this release:

Sl No.	Bug or Enhancement	Definitions
1	32772094	The issue purpose code in stage investments is not being reclassified into Regulatory capital account purpose. This impacts the line items on public development investments that are issued under the Public Policy Programme. As a workaround, the bank can reclassify the investment data into regulatory capital account purpose, as the specific treatment for Public Policy Programme investments is already handled in the Leverage Ratio calculations.

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