This section includes the procedures for the upgrade scenarios supported by OFSAA Reconciliation Framework Pack Release 8.1.1.0.0.
ATTENTION:
· If you are upgrading the OFSAA Application Pack to release v8.1.1.0.0, you must upgrade the other packs installed in the same environment to release v8.1.0.0.0, to ensure successful deployment.
· You can upgrade Oracle Financial Services Reconciliation Framework from base versions 8.0.7.0.0, 8.0.8.0.0, 8.1.0.0.0, or 8.1.0.1.0 only.
· Upgrade of only Stage Ledger Data and Stage Management Ledger source entities is performed.
· Hive-hybrid upgrade is not supported.
Before you plan to install/upgrade any of your application packs to Release 8.1.1.0.0, ensure that all the application packs in your current OFSAA instance are available in the Release 8.1.1.0.0 version. For more information about the release version details, contact My Oracle Support .
ATTENTION:
The minimum supported version is 8.0.7.0.0. If you are upgrading from a release before v8.0.7.0.0, then first upgrade to v8.0.7.0.0 or later. After this step, you can upgrade to v8.1.1.0.0 or later.
1. Backup the following in the OFS AAAI environment:
§ The Database
§ The following environment files from the <OFS_AAAI_PACK>/schema_creator/conf directory:
— OFS_<App pack>.xml
— OFS_<PACK>_SCHEMA_IN.xml
— OFSAAI_InstallConfig.xml
2. See the Oracle Financial Services Analytical Applications 8.1.1.0.0 Technology Matrix for the hardware and software required to upgrade to OFS AAAI Release 8.1.1.0.0.
3. Enable unlimited cryptographic policy for Java.
For more information, see the Enabling Unlimited Cryptographic Policy section in the OFS Analytical Applications Infrastructure Administration Guide.
4. Clone your environment.
For more information, see the OFSAA Cloning Reference Guide.
Topics:
· Upgrade from OFSAA Reconciliation Framework Release v8.0.x on AIX or Solaris x86 Operating System
· Clone Your Existing Environment
· Mandatory step before upgrading
Release v8.1.1.0.0 of OFSAA Reconciliation Framework is not certified for AIX and Solaris x86 Operating Systems. If you are currently running OFSAA v8.0.x on AIX or Solaris x86 Operating Systems and plan to upgrade to Release v8.1.1.0.0, migrate from AIX or Solaris x86 to Linux or Solaris SPARC. See the OFSAA 8.0.x.x.x Migration Guide for details.
If you are upgrading from one operating system (OS) to another or between different OS versions, do the following:
· Clone your existing environment to the v8.1.1.0.0 OFSAA Technology Matrix.
· For cloning from OFS DM Release 8.0.7.0.0 or 8.0.8.0.0 to OFSAA Reconciliation Framework version 8.1.1.0.0, see the Oracle Financial Services Analytical Applications Infrastructure Cloning Guide
· Enter the following details in the OFSAA_SETUP_APPLN_DTLS table in the config schema only if these entries are not present.
APPNAME |
APPVERSION |
DSNID |
SEG_MAP_ID |
SEGMENT_CODE |
INSTALLED_FLAG |
INSTALLED_DATE |
|---|---|---|---|---|---|---|
GL |
<last_version_installed> Ex: 8.0.7.0.0 |
<INFODOM> Ex: DMINFO |
COMMON |
<SEGMENT_CODE> Ex: DMSEG |
Y |
<ANY_DATE> Ex: 03-APR-20 |
To upgrade the OFS DM application pack to 8.1.1.0.0, perform the following steps:
1. Download the OFSAA Reconciliation Framework Pack v8.1.1.0.0 archive file and copy it to your OFSAA server in the Binary mode, see Download the OFS Analytical Applications Reconciliation Framework Pack Installer.
NOTE:
The archive files are different for every operating system such as Solar is and RHEL/Oracle Linux.
2. Log in to the OFSAA Server.
3. Shut down all the OFSAAI Services.
For more information, see Stop the Infrastructure Services section.
4. Execute the command:
chmod -R 750 $FIC_HOME
5. If you have an unzip utility, skip to the next step. Otherwise, download the unzip utility (OS-specific) and copy it in Binary mode to the directory that is included in your PATH variable; typically the $HOME path or directory in which you have copied the 8.1.1.0.0 installer.
6. Uncompress the unzip installer file using the command:
uncompress unzip_<os>.Z
NOTE:
In case you notice an error message uncompress: not found [No such file or directory] when the package is not installed, contact your UNIX administrator.
7. Give EXECUTE permission to the file using the command:
chmod 751 OFS_DM_8.1.1.0.0_<OperatingSystem>.zip
8. Extract the contents of the Oracle Financial Services Analytical Applications Reconciliation Framework Pack 8.1. 1.0.0 installer archive file, using the command:
Unzip -a OFS_DM_8.1.1.0.0_<os>.zip.
9. Give the EXECUTE permission to the OFS_DM_PACK folder using the command:
chmod -R 775 OFS_DM_PACK
10. For RDBMS upgrade:
a. Before triggering the installation, update the configuration in the Silent.props file.
b. Create a copy of the Silent.template file present in the installer /OFS_DM_PACK/appsLibConfig/conf location and rename it as Silent.props.
NOTE:
When you are entering the values, the names must be the same as the ones given in the previous full installation process.
c. Edit the OFS_DM_PACK/conf/OFS_DM_PACK.xml to enable the product licenses. Update the attribute ENABLE=YES/NO in the OFS_DM_PACK.xml for licensing the app in the pack.
NOTE:
Before installing the OFSAA Reconciliation Framework Pack, see Configure the OFS_DM_PACK.xml File for instructions.
11. Navigate to /OFS_DM_PACK/bin and execute setup.sh file using the following command:
./setup.sh SILENT
12. Verify if the release is applied successfully by checking the log file generated in the installation folder. You can ignore ORA-00001, ORA-00955, ORA-02260, and ORA-01430 errors in the log file. In case of any other errors, contact My Oracle Support (MOS).
13. For information about securing your OFSAA Infrastructure, refer to the OFSAA Security Guide in the OHC Documentation Library.
Verify the log files in the locations mentioned in the Verify the Log File section.
Follow these steps after completing your upgrade:
1. Navigate to ficweb/webroot/WEB-INF/web.xml file. Remove the following entries from the .xml file.
-----------------------------------------------------------------------
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter>
<filter-name>struts-cleanup</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/glreconciliation/*</url-pattern>
<url-pattern>/fsapps/*</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>struts-cleanup</filter-name>
<url-pattern>/fsapps/*</url-pattern>
<url-pattern>/glreconciliation/*</url-pattern>
</filter-mapping>
--------------------------------------------------------------------------------------------------------------
2. Navigate to the <FIC_HOME>/ficweb/webroot/WEB-INF/classes folder and perform the following changes:
a. Remove the GL_Struts.xml file from the folder.
b. Remove the tag: <include file="GL_Struts.xml" /> from the struts.xml file.
3. Execute the <INFODOM>_GL_MAPPING_POPULATION batch.
Follow these deployment instructions after the upgrade is complete.
Sl. No. |
Post-deployment configurations |
|---|---|
1 |
Installing OBIEE or OAS Server |
2 |
Installing OBIEE or OAS Windows Administration Client |
3 |
Configuring Reconciliation Framework Analytics v8.1.1.0.0 Dashboards and Reports |
4 |
Deploying Reconciliation Framework Pack Analytics |
5 |
Starting Node Manager and WebLogic Servers |
6 |
Logging in as System Administrator |
7 |
Create Application Users. |
8 |
Map Application User(s) to User Groups. For application specific user group refer Mapping Application User(s) to User Group. |
This section details the configurations required in case you want to enable Data Redaction in OFSAA applications after upgrade to OFSAA 8.1.1.0.0 version from a previous version. Additionally, these configurations are required in case you did not enable TDE during OFSAA Reconciliation Framework 8.1.1.0.0 installation but want to enable it at a later point of time.
For more information, see Enable Data Redaction.
Part III
Topics: