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).
    • Bug 37013828 - OFS ECM Application Pack v8.1.2.0.0 Minor Release 8.1.2.9.0.

      Note:

      Download and install the above patch if the ECM Application is installed on the same pack.
    • Bug 37025880 - OFS BD Application Pack v8.1.2.0.0 Minor Release 8.1.2.9.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.