2 Pre-Installation

Note:

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

Note:

If the Behavior Detection Application Pack version 8.1.2.6.0 patch to be installed on Sanctions Pack Version 8.1.2.0.0, or later, then follow these steps:
  • create table KDD_BUS_DMN_TEMP as (select * from KDD_BUS_DMN);
  • UPDATE KDD_BUS_DMN SET TF_BUS_DMN_NM=NULL; commit;
  1. The OFS Sanctions Application Pack v8.1.2.0.0 must be downloaded from Edelivery and installed.
  2. Download and install the following mandatory patches from My Oracle Support by searching the patch under the Patches & Updates tab:
    • Bug 36420089 - OFSAA 8.1.2.0.0 AAI ML Release #5 (8.1.2.5.0) (OFSAAI).
    • Platform Enhancement 37876070 - Certification of ERWIN 14.1.
    • Bug 37786646 – Consolidated fixes for issues dependent on the FCCM 8.1.2.10 Maintenance Release (ML)..
    • Bug 38384230 – OFS Sanctions (SANC) 8.1.2.11.0 – Maintenance Release (ML) #11.
    • Bug 38376346 – OFS Enterprise Case Management (ECM) 8.1.2.11.0 – Maintenance Release (ML) #11.

      Note:

      Download and install the above patch if the ECM Application is installed on the same pack.
    • Bug 38402265- BD81211: Behavior Detection Version 8.1.2. ML Release # 11 (8.1.2.11.0).

      Note:

      Download and install the above patch if the BD Application is installed on the same pack.
  3. The Patch will add primary key to the stg_party_party_relationship table. Before installing this patch make sure the default value (MSG) is present in the v_relationship_type_code column.