3 Applying This Maintenance Level Release

To apply this ML release, follow these steps:

Note:

The following files are required for the patch utility to work:
  • merge_wd.xsl
  • merge_Persissdtence.xsl
  • merge_web.xsl
  • merge_Menu.xsl
  1. Load the .profile and make sure that $FIC_HOME directory corresponds to the proper environment where the patch application is required.

    Note:

    The FIC server must be up and running.
  2. Start the OFSAAI Services.
  3. Download and copy the 37586943_GENERIC.zip file (in Binary mode) to the server where OFSAAI is installed.
  4. Navigate to the <USER_PATCH_DIR> directory and extract the contents of the patch archive file using the following command:unzip -a <name of the archive file to be unzipped>
    For example: unzip -a 37586943_GENERIC.zip.

    Note:

    • <USER_PATCH_DIR> is the directory containing the <patch>.zip file copied in step 3.
    • The -a option is mandatory to unzip the patch. In case, you receive an error message unzip; not found [No such file or directory] when the package is not installed, contact your UNIX Administrator.
    The list of files available when you unzip the folder are as follows:
    • PatchConfig.xml
    • install.sh
    • Setup.bin
    • validateXMLInputs.jar
    • Readme_OFSSANC_8.1.2.9.0.txt
  5. Navigate to the <USER_PATCH_DIR>/37586943/bin directory and grant 755 permission using the following command: 
    $ chmod 755 *
  6. Navigate to <USER_PATCH_DIR>/37586943/conf/PatchConfig.xml directory and provide the following place holder values:
    • ##SCHEMA_OUT_XML_PATH## - This attribute refers to the path which needs to be pointed to OFS_SANC_SCHEMA_OUTPUT.xml, which was generated at the time of installation.
    • FSDF_UPLOAD_MODEL- The value to this parameter should be 1 for pack on-pack or standalone.
  7. Install the patch by executing the following install.sh command: $ ./install.sh
  8. Check if the ML release is applied successfully by verifying the patch install logs under the <USER_PATCH_DIR>/37586943/logs directory. Contact My Oracle Support in case of any errors.
  9. After the patch is installed successfully, re-create the OFSAA EAR/WAR file and re-deploy a new EAR/WAR file on the web application server.
  10. Restart the OFSAA Application server and the web server.
    For more information on the application configuration, see Administration Guide on OHC.

    Note:

    While installation, if you encounter the error:

    kdd_bus_dmn.sql---------ORA-01430: column being added already exists in table

    Execute the following statement and restart the installation:

    ALTER TABLE KDD_BUS_DMN DROP COLUMN TF_BUS_DMN_NM;

    Once the installation is completed perform the following step:

    Copy data from table KDD_BUS_DMN_TEMP to table KDD_BUS_DMN against column TF_BUS_DMN_NM.