2.2 How to Apply This Maintenance Level Release?

This section describes how apply this maintenance release.

To install this Maintenance Level release:

Note:

If the OFS Behavior Detection 8.1.2.12.0 patch is to be installed on OFS Sanctions 8.1.2.0, then follow these steps:

• Create table KDD_BUS_DMN_SANC as (select * from KDD_BUS_DMN); UPDATE KDD_BUS_DMN SET TF_BUS_DMN_NM=NULL;
• Commit;
• Restore the TF_BUS_DMN_NM column in the KDD_BUS_DMN table from NULL to the original value after the installation is complete.

1. During OFS Behavior Detection 8.1.2.12.0 patch installation, only the FICServer (<FIC_HOME>/ficapp/common/FICServer/bin/startofsaai.sh) can be up and running. Stop all other OFSAAI application services (MANTAS, ICC, BD algorithms dispatcher, etc.).
2. Load the .profile and ensure that $FIC_HOME corresponds to the proper environment where the patch application is required.
3. Navigate to <USER_PATCH_DIR> and extract the contents of the patch archive file using the command: unzip -a <name of the file to be unzipped>.

   For example: unzip -a 39073828_LINUX.zip

   Note:

   <USER_PATCH_DIR> is the location of the <patch>.zip file. The -a option mentioned above is required to unzip the patch. If you encounter the error message unzip: not found [No such file or directory] when the package is not installed, contact your UNIX administrator to resolve the issue.

4. Navigate to <USER_PATCH_DIR>/39073828/bin and grant execute (755) permission for all executables: $ chmod 755*.
5. Navigate to <USER_PATCH_DIR>/39073828/conf/PatchConfig.xml and provide the following placeholder values:
   1. ##SCHEMA_OUT_XML_PATH## - this attribute refers to the path which needs to be pointed to OFS_BD_SCHEMA_OUTPUT.xml, which was generated at the time of installation.
   2. ##BIG_DATA_ENABLE## - set the value toFALSE.
   3. ##SCORING_PROTOCOL_SERVER_PORT## - provide the server host & port. For example: hostIP:PortNumber.
   4. ##COMM_LOG_PATH## - provide the folder path for the logs of KYC Onboarding Services.
   5. ##FSDF_UPLOAD_MODEL##- provide the value mentioned in default.properties during BD 812 installation. Path : /<BD812_Installer>/OFS_BD_PACK/OFS_AML/conf/ default.properties.
   6. ##EXECUTE_PRE_AND_POST_SCRIPTS##- attribute value must be set to 1 to execute the prescripts and postscripts. Attribute value 0 skips the prescripts and postscripts.

      Note:

      As part of prescripts, back up tables with the naming convention <TABLE_NAME>_81211_BACKUP.
6. Navigate to <USER_PATCH_DIR>/39073828/conf/params.conf and provide the following place holder values:
   1. WEBSERVER_TYPE - This attribute refers to the valid web server used.
      For example:

      • WEBSERVER_TYPE=TOMCAT
      • WEBSERVER_TYPE=WEBLOGIC
      • WEBSERVER_TYPE=WEBSPHERE
   2. WEBSERVER_VERSION - This attribute refers to the valid web server version used.
      For example:

      • WEBSERVER_VERSION=9.0.82
      • WEBSERVER_VERSION=10.1.20
      • WEBSERVER_VERSION=14.1.2
7. Install the patch by executing the command: $./install.sh.
8. Check if the patch is applied successfully by verifying the patch install logs under <USER_PATCH_DIR>/39073828/logs.

   Note:

   Contact My Oracle Support in case of any errors.