Prepare for Upgrade

Prerequisites for installing/upgrading any application packs to Release 8.1.2.0.0.

Before you plan to install/upgrade any of your application packs to Release 8.1.2.0.0, ensure that all the application packs in your current OFSAA instance are available in the Release 8.1.2.0.0 version. Contact My Oracle Support or more information about the release version details.

Note:

The minimum supported version is 8.0.6.1.0. If you are upgrading from a release before v8.0.6.1.0, then first upgrade to v8.0.6.1.0 or later. After this step, you can upgrade to v8.1.2.0.0 or later.

Note:

• Ensure to revert any customized data model changes done without performing data model upload before upgrading.
• If you have defined any custom run purpose, ensure to take a backup of the tables FSI_LRM_LOOKUP_TL and FSI_LRM_PROCESS_PURPOSE_MAP, before you run the upgrade.

1. Backup the following environment files from their respective directories:
   • 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.2.0.0 Technology Matrix for the hardware and software required to upgrade to OFS AAAI Release 8.1.2.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.
5. Execute the following SQL query on the Atomic Schema:

   update rev_tables_b set version=0 where version is null;
   commit;