6.6 Pack on Pack Upgrade

Note:

Apply the latest available AAI Patch (Contact Support).

Note:

Before you run the patch/installer, perform a backup of the Schemas (Atomic and Config), FIC_HOME, and ftpshare directories.

BD 8.1.2.0.0, AAI 8.1.2.1.0, BD 8.1.2.1.0,ECM 8.1.2.0.0, ECM 8.1.2.1.0, ECM 8.1.2.1.1, Sanctions 8.1.2.0.0, CRR 8.1.2.0.0, and CRR 8.1.2.1.0

Before installing Sanctions pack 8.1.2.0.0., execute the following query in Atomic schema.
create table FCC_SAN_STD_CMNTS_DIM_BKP as (select * from FCC_SAN_STD_CMNTS_DIM);
drop table FCC_SAN_STD_CMNTS_DIM;
create table DIM_TF_MSG_TYPE_BKP as (select * from DIM_TF_MSG_TYPE);
drop table DIM_TF_MSG_TYPE;
create table FCC_ZCS_SCREENING_MODE_DIM_BKP as (select * from FCC_ZCS_SCREENING_MODE_DIM);
truncate table FCC_ZCS_SCREENING_MODE_DIM;
create table FCC_ZCS_ALERT_TYPE_DIM_BKP as (select * from FCC_ZCS_ALERT_TYPE_DIM);
truncate table FCC_ZCS_ALERT_TYPE_DIM;
create table FCC_SAN_STD_CMNTS_TL_BKP as (select * from FCC_SAN_STD_CMNTS_TL);
drop table FCC_SAN_STD_CMNTS_TL;

To trigger the installation, follow these steps

  1. To install Sanctions 8.1.2.0.0 pack on the pack on pack, see About Schema Creator Utility for configuration of files.

    Note:

    Schema name must be same.
  2. To configure the XML files, see SILENT Mode Installation.
  3. Navigate to OFS_SANC_PACK/bin.
  4. Execute setup.sh file using the following command:

    ./setup.sh SILENT

  5. Verify the logs in the 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/

Sanctions 8.0.8.0.0, Sanctions 8.0.8.2.0, Sanctions 8.0.8.2.1 to 8.0.8.2.9, BD 8.1.2.0.0, ECM 8.1.2.0.0, AAI 8.1.2.1.0, BD 8.1.2.1, ECM 8.1.2.1.0, ECM 8.1.2.1.1, Sanctions 8.1.2.0, CRR 8.1.2.0.0, CRR 8.1.2.1.0

Note:

Before upgrade to Sanction 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.

To install BD 8.1.2.0.0 in this lane on sanctions 8.0.8.0.0, follow these steps:

  1. Follow these mandatory steps before applying BD 8.1.2.0.0.
    1. Take a backup of FIC_HOME (complete file system including ftpshare).
    2. Take a backup of Atomic and Config Schema.
    3. Execute following queries in Atomic schema. 
      create table KDD_BUS_DMN_TEMP as (select * from KDD_BUS_DMN);
UPDATE KDD_BUS_DMN SET TF_BUS_DMN_NM=NULL;
commit;
ALTER TABLE FCC_BATCH_DATAORIGIN RENAME TO FCC_BATCH_DATAORIGIN_TEMP;
ALTER TABLE FCC_BATCH_DETAIL RENAME TO FCC_BATCH_DETAIL_TEMP;
ALTER TABLE FCC_BATCH_RUN RENAME TO FCC_BATCH_RUN_TEMP;
ALTER TABLE FCC_PROCESSING_GROUP RENAME TO FCC_PROCESSING_GROUP_TEMP;
  2. To install BD 8.1.2.0.0, see Behavior Detection Application Pack Installation Guide.
  3. Follow these mandatory steps after applying BD 8.1.2.0.0.
    1. Refer installation logs, if installation is successful follow these steps.
    2. Take a backup of FIC_HOME(complete file system including ftpshare)
    3. Take a backup of Atomic and Config Schema.
    4. Perform regression.

      Note:

      • Apply below step only if you plan regression after BD 8.1.2.0.0 Installation.
      • Below query is not required, if ECM 8.1.2.0.0 is installed on top of BD 8.1.2.0.0 without any regression.
      • ALTER TABLE KDD_BUS_DMN add TF_BUS_DMN_NM varchar2(20 CHAR); copy data from table KDD_BUS_DMN_TEMP to table KDD_BUS_DMN against column TF_BUS_DMN_NM

      Note:

      Before upgrade to Sanction pack 8.1.2.0.0 take a 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).
  4. Before triggering Sanction application pack 8.1.2.0.0, Execute following queries in Atomic schema.
    create table FCC_ZCS_SCREENING_MODE_DIM_BKP as (select * from FCC_ZCS_SCREENING_MODE_DIM);
truncate table FCC_ZCS_SCREENING_MODE_DIM;
create table FCC_ZCS_ALERT_TYPE_DIM_BKP as (select * from FCC_ZCS_ALERT_TYPE_DIM);
truncate table FCC_ZCS_ALERT_TYPE_DIM;

To trigger the installation, follow these steps

  1. To install Sanctions 8.1.2.0.0 pack on the pack on pack, see About Schema Creator Utility for configuration of files.

    Note:

    Schema name must be same.
  2. To configure the XML files, see SILENT Mode Installation.
  3. Navigate to OFS_SANC_PACK/bin.
  4. Execute setup.sh file using the following command:

    ./setup.sh SILENT

  5. Verify the logs in the 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/

SANC 8.1.2.0.0, ECM 8.1.2.0.0, AAI 8.1.2.0, ECM 8.1.2.1.0, ECM BD 8.1.2.0.0, BD 8.1.2.1 .0, CRR 8.1.2.0, CRR 8.1.2.1.0

Note:

Before you run the patch/installer, perform a backup of the Schemas (Atomic and Config), FIC_HOME, and ftpshare directories.
Before installing ECM 8.1.2.0.0, execute following queries in Atomic schema:
create table KDD_BUS_DMN_bkp as (select * from KDD_BUS_DMN);
UPDATE KDD_BUS_DMN SET TF_BUS_DMN_NM=NULL;
COMMIT;
create table FCC_PROCESSING_GROUP_bkp as (select * from FCC_PROCESSING_GROUP);
drop table FCC_PROCESSING_GROUP;
create table FCC_BATCH_DATAORIGIN_bkp as (select * from FCC_BATCH_DATAORIGIN);
drop table FCC_BATCH_DATAORIGIN;
create table FCC_BATCH_DETAIL_bkp as (select * from FCC_BATCH_DETAIL);
drop table FCC_BATCH_DETAIL;
Create table FCC_BATCH_RUN_bkp as (select * from FCC_BATCH_RUN);
drop table FCC_BATCH_RUN;

To trigger the installation, follow these steps

  1. To install Sanctions 8.1.2.0.0 pack on the pack on pack, see About Schema Creator Utility for configuration of files.

    Note:

    Schema name must be same.
  2. To configure the XML files, see SILENT Mode Installation.
  3. Navigate to OFS_SANC_PACK/bin.
  4. Execute setup.sh file using the following command:

    ./setup.sh SILENT

  5. Verify the logs in the 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>Installer/OFS_SANC_PACK/OFS_CS/logs/

    <Installer kit>Installer/OFS_SANC_PACK/OFS_TFLT/logs/

Post Installation Activities

Execute the following query.

ALTER TABLE KDD_BUS_DMN add TF_BUS_DMN_NM varchar2(20 CHAR);

  1. Copy data from table KDD_BUS_DMN_bkp to table KDD_BUS_DMN against column TF_BUS_DMN_NM
  2. BD 8.1.2.0 installation, manually add these columns for the following tables. 
    TABLE NAME COLUMNS
EXTRL_ORG ("JRSDCN_CD");
EXTRL_ORG_ARC("JRSDCN_CD");
EXTRL_ORG_STG("ADDR_SEQ_NB");
EXTRL_ORG_STG("JRSDCN_CD");
  3. The following are the SQL scripts for adding columns:
    ALTER TABLE EXTRL_ORG
ADD JRSDCN_CD VARCHAR2(4 CHAR);
ALTER TABLE EXTRL_ORG_ARC
ADD JRSDCN_CD VARCHAR2(4 CHAR);
ALTER TABLE EXTRL_ORG_STG
ADD ADDR_SEQ_NB VARCHAR2(20 CHAR);
ALTER TABLE EXTRL_ORG_STG
ADD JRSDCN_CD VARCHAR2(4 CHAR);