6.2 Upgrading from 8.0.7.0.0 to 8.0.8.0.0, 8.0.8.2.0, and 8.1.2.0.0

To upgrade from 8.0.7.0.0 to 8.0.8.0.0, 8.0.8.2.0, and 8.1.2.0.0, perform the following steps:

Note:

Before upgrade to 8.1.2.0.0. take backup of all STG tables. Use the list of the STG tables and create SQL truncate script for truncating STG tables from BD atomic schema. For the list of STG table, see CSA_Data_Map_812.xlsx in Components of Sanctions Pack (Doc ID 2329509.1).

Note:

Before you run the patch/installer, perform a backup of the Schemas (Atomic and Config), FIC_HOME, and ftpshare directories.
  1. Upgrade to 8.0.8.0.0 (patch number- 30503763).
  2. Then upgrade to 8.0.8.2.0. (patch number- 33090893) for more information, see 8.0.8.2.0 Installation Guide.
  3. Take backup of the kdd_centricity table and truncate it.
  4. Take backup of fsi_rt_match_service table.
  5. Execute the following queries.
    • alter table fsi_rt_match_service drop CONSTRAINT UK_FSI_RT_MATCH_SERVICE1;
    • alter table fsi_rt_match_service drop column V_GOOD_SERVICE_UNIQ_ID;
  6. Apply Sanctions 8.1.2.0.0.
  7. Go to <##INSTALLER KIT##>/OFS_SANC_PACK/OFS_TFLT/conf.
  8. Open the PatchConfig.xml file and configure the parameters as shown below.

    Table 6-2 PatchConfig.xml Parameters

    Tag Name/ Attribute Name Description Mandatory (Y/ N) Default Value/ Permissible Value Comments

    SCHEMA_OUT_XML_PATH

    		 Specifies the Schema XML path Y Unique Seeded Value  
    DATA_TABLE_S PACE Provides the tablespace data Y Unique Seeded Value  
    INDEX_TABLE_ SPACE Provides the tablespace index Y Unique Seeded Value  
    BIG_DATA_ENA BLE Flag to enable or disable big data N False DO NOT modify this value.

    EXECUTE_PRE_AND_POST_S CRIPTS

    		 Provides the pre and post scripts that need to be executed Y 1  
    SWIFT_INFO Provides the SWIFT information Y Unique Seeded Value  

    SANC_ATOMIC

    _USER

    		 Provides the ATOMIC user name. Y Unique Seeded Value -
  9. Navigate to OFS_SANC_PACK/bin.
  10. Execute setup.sh file using the following command:

    ./setup.sh SILENT

  11. Verify the logs in installer.

    <Installer kit>OFS_SANC_PACK/logs/

    <Installer kit>OFS_SANC_PACK/schema_creator/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_AAI/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_CS/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_TFLT/logs/

    Note:

    You can ignore ORA-00001, ORA-00955, ORA-02260, and ORA-01430 errors in the log file. In case of any other errors, contact Oracle Support.
  12. Apply the latest available AAI Patch (Contact Support).

After you complete the upgrade, ensure that you run the following EDQinsert.sh script: refer the Post Installation Configurations chapter.