Oracle Financial Services Reconciliation Framework Application Pack v8.1.1.1.0 One-off Patch Release #5 (8.1.1.1.5)

This readme has the following sections:

·         Description

·         Prerequisites

·         How to Apply This One-Off Patch Release

Description

ID 35045156  – ONE-OFF PATCH RELEASE OF RECONCILIATION FRAMEWORK 8.1.1.1.5.

Prerequisites

·         The minimum version of the Oracle Financial Services Reconciliation Framework on which this patch can be applied is 8.1.1.1.2 (ID 34478502).

·         If you are using Data Governance (DGS) along with the Reconciliation Framework application, then perform the below steps:

For Example: If you are using a higher version of DGS of 8.1.2.0.0 version and Reconciliation Framework of 8.1.1.1.5, then the DataAdjustment.jar of any one-off patch of the Reconciliation Framework is not applied.

To rectify this:

1.        Modify the AAI table in config schema aai_pack_app_file_details for the DataAdjustment.jar file and rename the file with a suffix as '_YYYYMMDD_tag'.

2.       Apply the Reconciliation Framework patch on the environment and the new DataAdjustment.jar file will be copied by the installer.

How to Apply This One-Off Patch Release

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

2.       Download the 35045156_GENERIC.zip archive file and copy it to your OFSAA Server in Binary Mode.

3.       Stop all the OFSAAI Services.

For more information, see the Stop the Infrastructure Services Section in the Oracle Financial Services Reconciliation Framework Application Pack Installation Guide 8.1.1.0.0.

4.      Extract the contents of the Patch Archive File using the following command:

unzip -a <name of the file to be extracted>

For example: unzip -a 35045156_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 directory by executing the following command:

chmod -R 755 OFS_GLRECON

6.      Navigate to the following directory:

<>/appsLibConfig/conf

7.       Update the params.conf File with the Upload Model Parameter as 0.

8.      Navigate to the following directory:

<>/OFS_GLRECON/bin

9.      Execute the following install command:

./setup.sh

10.   Verify the patch installation logs in the following directory:

<>/OFS_GLRECON/logs

11.     After successful installation, perform the below steps:

a.       Clear the Application Cache

b.       Navigate to the following directory based 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 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 Oracle Financial Services Reconciliation Framework Application Pack Installation Guide 8.1.1.0.0

14.   After the successful installation of the release, restart all OFSAAI Services.

For more information, see the Start Infrastructure Services section in the Oracle Financial Services Reconciliation Framework Application Pack Installation Guide 8.1.1.0.0

List of Bugs Fixed in this Release

The following bugs are fixed in this release.

Sl. No.

Bug ID

Bug Description

Change Description

1

34865589

DATA TYPE ERROR ON LOOKUP VALUE IN ADJUSTMENT DEFINITION SCREEN

New type has been added in the user interface to accommodate this requirement.

2

34663659

ISSUE WITH GL PARAMETER SCREEN

Individual members for a dimension are selected on load.

3

34657308

EXPORTING ADJUSTMENT RULE USING OFFLINE MIGRATION

Offline Migration is now supported for Adjustment rules.

4

34553477

ISSUE WITH RUNNING FEW RECON DEFINITIONS

Technical fix is done around DB Connection objects.

5

35072915

GETTING MULTIPLE MEASURE IN THE SAME CORRECTION EXCEL

Additional attribute has been filtered out from the report.

 

Oracle Financial Services Software   |   Copyright © 2023, 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