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 38681161 - OFSAA 8.1.2.0.0 AAI ML Release #6 (8.1.2.6.0) (OFSAAI).
    • OFS Sanctions Bug 39107415 - OFS Sanctions 8.1.2.12.0 ML Release.
    • Bug 39025972 - OFS ECM Application Pack v8.1.2.0.0 Minor Release 8.1.2.12.0.

      Note:

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