1. Installer Property File Creation
  2. Creating Property File

1.2 Creating Property File

To create the property file for Oracle Banking Trade Finance, follow the steps given below:

  1. Launch Oracle Banking Trade Finance Installer i.e. FCUBSInstaller.bat (for Windows), and FCUBSInstaller.sh (for Linux, bash shell recommended). These files are available in INSTALLER/SOFT/GUI
    Description of 1.2_fcubsinstaller.png follows
    Description of the illustration 1.2_fcubsinstaller.png

    In the first screen, provide the following details:
    1. JAVA HOME PATH

      Provide the JDK home path with the latest version.

    2. ORACLE HOME PATH

      Provide the Oracle 18C Client Path.

    3. APP SERVER HOME PATH

      Provide the app server home path

    After providing these details, INSTALLER-GUI gets started. And follow the below details. Ensure the Pre-requisites are available.
    Description of 1.2_installer.png follows
    Description of the illustration 1.2_installer.png

    Enter the following details
    JDK Path
    Maintain Home folder path of JDK. The JAVA HOME path given in previous screen gets defaulted.
    Oracle Home
    Maintain home folder path of Oracle Database Client. The ORACLE HOME path given in previous screen gets defaulted.
    Select one of the radio buttons:
    1. Property File creation
    2. Utilities
    Based on the selection, Next screen will be shown .Click Property File creation for the current case.
  2. Click ‘Next’ and the following screen is displayed.
    Description of 1.2_ofu-installer.png follows
    Description of the illustration 1.2_ofu-installer.png

    1. Select the component for which property file is to be created.
      1. INFRA is for FCUBS property file creation .To create property file for Scheduler or Gateway or Switch Interface Installation, please refer the respective property file creation document.
    2. Select Oracle Banking Trade Finance for Trade Finance Property file creation. In case of co-deployment one or more Product Processors can be included with Trade Finance.
      1. Oracle Financial Universal Banking product processor contains Rest of Flexcube other than Payments, ELCM and OBCL etc.
      2. Oracle FLEXCUBE Enterprise Limits and Collateral Management (ELCM) has three types. They are Embedded, CO-Deploy and Standalone (Elcm Adapter). Please choose proper option. Oracle FLEXCUBE Enterprise Limits and Collateral Managements can be selected as individual application or along with Oracle Financial Universal Banking. Also ELCM Adapter required checkbox is available.
      3. Oracle Banking payments can be selected.
      4. Oracle Banking Corporate Lending can be selected.
      5. Open Development Tool(ODT) can be selected to install ODT, that allows end user to design ODT screens.
      6. Oracle Banking Treasury can be selected.
    3. In the screen above, select the Plug-ins to be included in the application.
    4. If you need to modify an existing property file, load it using the respective browse button.
    Plug-ins will be enabled and disabled based on the combination of Product Processors and components selected.
    These are the plug-ins available for Oracle Banking Trade Finance:
    • Scheduler
    • Reports
    These are the plug-ins available for Oracle Banking Trade Finance if co-deployed with Oracle Banking Payments
    • Scheduler
    • Reports
    • BPEL
    You can load existing property-file to make any modifications.
  3. Click ‘Next’ again and the following screen is displayed:
    Description of 1.2_ofu-installer_sms-schema.png follows
    Description of the illustration 1.2_ofu-installer_sms-schema.png

    Provide the SMS schema details to capture the credentials which will be used for DB Compilation.

    Note:

    IP Address should be same as mentioned in the TNSnames.ora

    Once the connection is successfull env.properties file present in path INSTALLERSOFTGUIlogsenv.properties will get updated with schema details in encrypted format.

    For Multi-Entity Details 

    Scenario for Single Entity:
    • Here Entity Schema is mandatory, atleast minimum one entry should be provided.
    • Entity Id value is default i.e. ‘ENTITY_ID1’ for first entry.
    • Provide the JNDI Name for the ENTITY_ID1. By default the jndi name is ‘jdbc/fcjdevDS’
    • Give the Schema Details for the Entity1.
    • Here Compile In All Entities Field is ‘N’. (As using the Single Entity Concept).
    Scenario for More than One Entity, i.e. Multi Entity :
    • After providing the Single Entity details, click on ‘+’ Add the rows.
    • Now give the details for Entity_ID2. Here the field is mandatory.
    • Provide the schema details and the JNDI name.
    • Next and Prev button is to traverse for entity screens.
    • Can also add the entites and delete the entities.
  4. Click on ‘Test Connection’ button. After Successful connection click on ‘Next’ button to proceed and below screen occurs. This screen displays database parameters listed in v$parameter table.

    This page is Read only used as reference to know the database parameters.

    Schema drop down list is provided to verify parameters of SMS and Entity Schemas.


    Description of 1.2_installer_database_1.png follows
    Description of the illustration 1.2_installer_database_1.png

  5. Click on ‘Next’ Button. This screen displays the grants provided to the schema. If object compilation is required and the privilege is not given, then you can find that out from this screen.

    Schema drop down lists SMS and Entity Schemas. Select Schema and proceed further.


    Description of 1.2_installer_database_2.png follows
    Description of the illustration 1.2_installer_database_2.png

  6. Click ‘Generate Report’ button, the installer creates an SQL file ‘grantScript.sql’ containing the script for granting the privileges in the ‘Logs’ folder and the following screen is displayed.

    You can use this file to get the access.


    Stop
    Only the sys user can execute the file ‘grantScript.sql’ for granting privileges.

  7. Click ‘Next’ again and the following screen is displayed:
    Description of 1.2_installer_environment.png follows
    Description of the illustration 1.2_installer_environment.png

    Field Description
    EAR Name

    Specify a name for the Application to be deployed.

    You cannot use special characters such as ‘.’ (Dot), ‘,’ (comma), ‘$’ etc. However, you may use ‘_’ (underscore). – Applicable for both Windows and Linux.
    Context Name

    Based on the Application type selected, the Installer displays the application context. However, you may modify the default value.

    This information will be updated in ‘application.xml’. In case of a WebLogic server, this will be updated in ‘weblogic.xml’.
    File Separator Style

    Specify the type of file separator (For example: Linux or Windows). Select the appropriate one from the drop-down list. You also need to specify the version of the selected operating system.
    Application Server

    Specify the application server in which you are creating the property file. Select the appropriate one from the adjoining drop-down list. For WebSphere, External JSUIXML Required option is not supported.
    External JSUIXML Required

    Specify whether screen changes will be deployed as External JSUIXML for the application.

    EXTERNAL_JSUIXML_REQUIRED=Y/N: Depending on requirement.

    EXTERNAL_JSUIXML_REQUIRED=N: JS and UIXML files are included inside the application EAR.

    EXTERNAL_JSUIXML_REQUIRED=Y: JS and UIXML and HELP files are kept in an external path in the application server.
    External Property File Required

    Specify whether screen changes will be deployed as External fcubs.properties for the application.

    EXTERNAL_PROPERTY_PATH_REQUIRED =Y/N: Depending on requirement.

    EXTERNAL_PROPERTY_PATH_REQUIRED =N: fcubs.properties file is included inside the application EAR.

    EXTERNAL_PROPERTY_PATH_REQUIRED =Y: fcubs.properties file is kept in an external path in the application server.


    Stop
    External property file path should have the property file name also with it.

    For example: C:\App\fcubs.properties
    Application server path Provide the Application Server Path.
    Source Path Provide the source path of the console exec directory. (Mention exact folder name after unzip the source).
    Ear Destination path Specify the path where Ear needs to be copied after building it using SOFT Installer.
    External JSUIXML Path In case External JSUIXML Required option is checked, External JSUIXML path on the application server machine has to be specified here. External JSUIXML required option is supported only for Weblogic Application Server. EXTERNAL_JSUIXML_PATH:

    ex:- /scratch/work_area/DEV/FC124_UBS/JS_UIXML_HELP -this can be any path in the Application server.
    External Property File Path In case External Property File required option is checked, External Property File path on the application server machine has to be specified here. ss
  8. Click ‘Next’ to continue and following screen is displayed:
    Description of 1.2_property-file-creation.png follows
    Description of the illustration 1.2_property-file-creation.png

    Field Description
    Release
    Specify the Release in which you are creating the property file. Default Option would be ‘KERNEL’. The valid options are:
    • KERNEL

    Specify the Hashing Algorithm Iteration Count. By default, it is 1000.

    ‘Security Key for Encryption Logic’ is the key (exact 16 characters) for all encryption logic. By default is ‘oraclefinancials’.