9.2 Prepare for Upgrade

Before you install/upgrade any of your application packs to Release v8.1.2.0.0, ensure that all the application packs in your current OFSAA instance are available in Release v8.1.2.0.0 or later version.

Contact My Oracle Support for more information about the release version details.

Note:

The minimum supported version is 8.1.1.0.0. If upgrading from a release before 8.1.0.0.0, then first upgrade to 8.1.1.0.0 or later. After this step, you can upgrade to 8.1.2.0.0.

1. Back up the OFSAA schemas from the Oracle Database server.
2. Backup the following environment files:
   • OFS_PAM_PACK.xml from the OFS_PAM_PACK/conf directory.
   • OFS_PAM_SCHEMA_IN.xml from the OFS_PAM_PACK/schema_creator/conf directory.
   • OFSAAI_InstallConfig.xml from the /OFS_PAM_PACK/OFS_AAI/conf directory.
3. See the OFS Analytical Applications Technology Matrix for the hardware and software required to upgrade to OFS AAAI Release 8.1.2.0.0.
4. Enable unlimited cryptographic policy for Java. For more information, see the Enabling Unlimited Cryptographic Policy section in the OFS Analytical Applications Infrastructure Administration and Configuration Guide.
5. In an integrated environment where OFS Profitability Management Pack (OFS PAM Pack) exists with the OFS Balance Sheet Planning (OFS BSP) and or OFS Asset Liability Management (OFS ALM), execute the following SQL script on the ATOMIC schema to avoid the data model upload failure:

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

6. If you are uploading the packaged data model with the installer, execute the following script in the atomic schema:

   DECLARE
   tbl_check NUMBER;
   BEGIN
   Select count(*) into tbl_check from user_tables where table_name='FSI_IRCS';
   IF( tbl_check=1) THEN
   for i in (SELECT CONSTRAINT_NAME, TABLE_NAME FROM USER_CONSTRAINTS WHERE R_CONSTRAINT_NAME = (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME='FSI_IRCS' AND CONSTRAINT_TYPE='P'))
   LOOP
   execute immediate 'ALTER TABLE '||i.table_name||' DISABLE CONSTRAINT '||i.constraint_name||'';
   end loop;
   execute immediate 'ALTER TABLE FSI_CURRENCIES DROP CONSTRAINT FK_FSI_CURRENCIES_2';
   END IF;
   EXCEPTION 
   WHEN OTHERS THEN
   	dbms_output.put_line(sqlerrm);
   END;  
   /