3 Installing Sanctions Pack 8.0.8 with BD Application Pack 8.1.2 & ECM 8.1.2

This enables the client to install the Sanctions Pack 8.0.8.0.0 with Behavior Detection Application Pack 8.1.2, and ECM 8.1.2.

To install Sanctions Pack 8.0.8.0.0 with Behavior Detection Application Pack 8.1.2 and ECM 8.1.2, follow these steps:

1. Install the Sanction Pack 8.0.8.0.0 and 8.0.8.2.0 ML on Java8. Complete the post installation configuration and deployment.
2. Take a backup of FIC_HOME (complete file system including ftpshare).
3. Take a backup of Atomic and Config Schema.
4. Execute below 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;

5. Install OFS BD8.1.2.0.0, to install refer OFS BD Installation Guide.

Refer installation logs, if installation is success proceed further by following steps:

1. Take a backup of FIC_HOME (complete file system including ftpshare)
2. Take a backup of Atomic and Config Schema.

   Note:

   Apply the following steps only when planned for Regression after BD 812 Installation or else it is not required, if ECM 812 is going to be installed on top of BD812 without any regression.
3. ALTER TABLE KDD_BUS_DMN add TF_BUS_DMN_NM varchar2(20 CHAR);
4. Copy data from table KDD_BUS_DMN_TEMP to table KDD_BUS_DMN against column TF_BUS_DMN_NM.