Installation

To install the Oracle Financial Services Loan Loss Forecasting and Provisioning Application Pack, follow these steps:

Note:

The OFS LLFP application contains two Erwin data model files. If you are uploading the model outside of the installation and if ECL computation is required for reinsurance receivables merge the OFS_LLFP_Datamodel and OFS_LLFPI_Datamodel (Insurance Model) data models before you begin the installation.
  1. Log in to the system as a non-root user.
  2. Identify a directory for installation and set the same in the user .profile file as follows:

    FIC_HOME=<OFSAA Installation Directory>

    export FIC_HOME

  3. Execute the user .profile file.
  4. Navigate to the OFS_LLFP_PACK directory.
  5. Rename the OFS_LLFP_PACK/schema_creator/conf/OFS_LLFP_SCHEMA_IN.xml.Template file to OFS_LLFP_PACK/schema_creator/conf/OFS_LLFP_SCHEMA_IN.xml.
  6. Execute the schema creator utility with the –s option.
  7. Navigate to the path OFS_LLFP_PACK/conf/OFS_LLFP_PACK.xml, and enter YES in the enable tag for OFS_AAI and OFS_AAAI.
  8. From Release 8.1.0.0.0 onwards, LLFP supports a single Silent.template file available in the path OFS_LLFP_PACK/appsLibConfig/conf. The Silent.template file is populated with default values. Ensure to modify the template in the directory. Create a copy of this file and rename it as Silent.props.
  9. Ensure to modify the template in the directory. Create a copy of this file and rename the copy as Silent.props.
  10. Installation is achieved through the properties file (Silent.props) that must be updated with proper values, before attempting to install using silent mode. Edit the parameters in the Silent.props file and specify the parameters as per the requirements.
    The following table lists all the properties that must be specified:

    Table 5-5 Properties

    Property Name Description of Property Permissible values Comments
    LOG_MODE Specify Log Mode

    1 = Debug Mode

    0 = General Mode [Passwords will not be printed in the log file]

    Password will be printed in the log file.

    The default value is 0.
    APPFTP_LOG_PATH

    Specify the Infodom Maintenance log path (to be created) for the new Infodom.

    Ignore if you are doing the installation on an existing information domain.

    		 User Input
    DBFTP_LOG_PATH

    Specify the Infodom Maintenance log path (to be created) for the new Infodom.

    Ignore if you are doing the installation on an existing information domain.

    		 User Input
    UPLOAD_MODEL Specify whether you want to perform Model Upload.

    0 = If you have already performed Model Upload and want to skip the model upload process.

    1 = If you want to perform Model Upload.

    		 The default value is 1.
    MODEL_TYPE Specify whether you want to use the released data model or customized data model for the model upload process.

    0 = If you want to upload the released data model.

    1 = If you want to upload the customized data model.

    		 The default value is 0.

    DATAMODEL

    DM_DIRECTORY

    Specify the path (DM_DIRECTORY) and file (DATAMODEL) name for the customized data model.

    Mandatory only if you want to upload the customized data model

    i.e you have specified MODEL_TYPE=1.

    		 User Input
    SEGMENT_1_CODE Specify the LLFP Segment Code. LLFP809SEG The default value is LLFP809SEG.
    OBI_HOST Specify the Host Name of the OBIEE Server User Input This field should NOT be left blank. If OBIEE is not configured at the moment, ensure that you provide a dummy value in this field
    OBI_PORT Specify the Port Number of the OBIEE Server User Input This field should NOT be left blank. If OBIEE is not configured at the moment, ensure that you provide a dummy value in this field.
    OBI_CONTEXT Specify the Context Name of the OBIEE Server User Input This field should NOT be left blank. If OBIEE is not configured at the moment, ensure that you provide a dummy value in this field.
    ETL_APPSRC_TYPE Specify if you want to create a new ETL App or Src pair or use an existing one.

    0 = If you want to create a new ETL app/src pair.

    1 = If you want to use an existing pair.

    		 The default value is 1.
    ETL_SRC_1_DESC ETL Staging source description.

    Describe the ETL Src.

    Mandatory if you want to create a new ETL Src if you have specified ETL_APPSRC_TYPE= 1.

    		 The default value is Staging.
    ETL_SRC_2_DESC ETL Processing source description.

    Describe the ETL Src.

    Mandatory if you want to create a new ETL Src if you have specified ETL_APPSRC_TYPE= 1.

    		 The default value is Processing.
    ETL_SRC_1_NAME ETL Staging source name. User Input

    The default value is Staging.

    Specify the ETL Source Name into ETL Area Definitions to be deployed.
    ETL_SRC_2_NAME ETL Processing source name. User Input

    The default value is Processing.

    Specify the ETL Source Name into ETL Area Definitions to be deployed.
    LLFP_SEGMENT Specify the name of the Segment for the LLFP models sandbox infodom User Input
    LLFP_APPSERVER_FTP_LOGPATH Specify the sandbox Maintenance log path (to be created) for the LLFP models sandbox infodom. User Input
    LLFP_DBSERVER_FTP_LOGPATH Specify the sandbox Maintenance log path (to be created) for the LLFP models sandbox infodom User Input
  11. Enter the following command in the console to execute the application pack installer with the Silent option.

    ./setup.sh SILENT

  12. The installer proceeds with Pre-Installation Checks.
  13. Enter the OFSAA Processing Tier FTP or SFTP password value and proceed, when prompted in the command prompt.

    Table 5-6 Console Prompt: Enter the OFSAA Processing Tier FTP/SFTP Password

    Console Prompts User Inputs
    Please enter OFSAA Processing Tier FTP or SFTP password

    Enter the password to access the processing tier in the application server.

    NOTE: If the prompt reads as follows, enter the username and password for accessing the product Staging or Metadata Repository FTPSHARE:

    • Kerberos username [user]
    • Kerberos password for user
  14. The process displays the OFSAA License. Enter Y and proceed.
  15. The installer installs the AAI application.
  16. After the platform is installed, the Oracle Financial Services Loan Loss Forecasting and Provisioning installation begins.
  17. After Data Model Upload is complete, verify the installation logs in the log directories mentioned in the Verify the Log File Information section.
  18. After successful LLFP application installation, the WAR file is generated and all the servers are verified and the installation complete message is displayed.
  19. The OFSAA Infrastructure installation performs a post-install health check automatically on the successful installation of the product.
  20. On completion of the installation, verify the installation log files mentioned in the Verify the Log File Information section.
  21. Apply the mandatory patches mentioned in the Mandatory Patches section.
  22. If the OFS MMG patch (33672339) has been applied, then to access the models in the UI:
    1. Log in as a sysadmin.
    2. Navigate to Identity Management, User – User Group Role Map
    3. Map the Roles LLFP MODELLER and LLFP LGD MODELLER for the user LLFP Application Analyst Group to access Models.

    Note:

    • Perform steps mentioned in the Post-Installation section.
    • Ensure that the OFS_LLFP_PACK installer directory with its contents is preserved, for enabling additional products in the future.