3 Load Static Data

This topic explains the steps to load static data into the database and the basic setup to be done.

  1. Start Oracle FLEXCUBE Universal Installer.
    The Oracle FLEXCUBE Universal Installer is displayed.

    Figure 3-1 Oracle FLEXCUBE Universal Installer


    Description of Figure 3-1 follows
    Description of "Figure 3-1 Oracle FLEXCUBE Universal Installer"

  2. On Oracle FLEXCUBE Universal Installer screen, enter the following details.
    Refer to the table for JDK and Oracle Home path.

    Table 3-1 JDK and Oracle Home path

    Field Description
    JDK Path

    Provide Home folder path of JDK1.8.
    Oracle Home

    Provide home folder path of Oracle Client or Database.
    Application Server Home

    Provide home folder path of Application Server.
    Application Server Location

    Select location of the application server either local or remote.
  3. Click Next to select the option for installation.
  4. Select Oracle FLEXCUBE Investor Servicing from the lists of Oracle FLEXCUBE options.
    The available options for installation are displayed.

    Figure 3-2 Option for Installation


    Description of Figure 3-2 follows
    Description of "Figure 3-2 Option for Installation"

  5. Click Next to choose Oracle FLEXCUBE component for installation.
  6. Choose Database.
  7. Choose installation option from the Installation Type.
    The Oracle FLEXCUBE Universal Installer supports Custom Installation of Oracle FLEXCUBE in two methods.
    • Compile objects.
    • Load data.
  8. Select Load Static Data under Custom Installation and click Next.
    The following screen is displayed.

    Figure 3-4 Custom Installation_Load Data_Load Static Data


    Description of Figure 3-4 follows
    Description of "Figure 3-4 Custom Installation_Load Data_Load Static Data"

  9. Provide directory path as required in the Destination Directory and click Next.
    The following screen is displayed.

    Figure 3-5 Destination Directory


    Description of Figure 3-5 follows
    Description of "Figure 3-5 Destination Directory"

  10. Click Copy to start database objects source copy.
    The Installer will copy the source files from the source directory to the destination directory. The files are taken from this location for compilation.
  11. Check the status of all the files being copied and complete the copy process.
    The following screen is displayed.

    Figure 3-6 Status of static sources being copied


    Description of Figure 3-6 follows
    Description of "Figure 3-6 Status of static sources being copied"

  12. Click Next and provide schema details.
  13. Specify schema details.
    Refer to the table for Schema details.

    Table 3-2 Schema details

    Field Description
    User Name

    Specify the user name to access the schema.
    Password

    Enter the schema password.
    Service Name

    Provide service name of Database.
    TNS Connect Descriptor

    Specify a valid connect string that contains the details for database connectivity.
    IP Address

    Specify the IP address of the system where the database schema is installed.
    Port

    Specify the port number.
  14. Click Test Connection to test the connection with the Application server.
    If the connection is established, the installer displays the message Connection Successful.

    Figure 3-8 Information Message on Successful Connection


    Description of Figure 3-8 follows
    Description of "Figure 3-8 Information Message on Successful Connection"

  15. Click Next after testing the connection successfully.
    This screen displays the parameter details of the database. This is for information purpose and you cannot modify the parameters from this screen.

    Figure 3-9 Parameter Table


    Description of Figure 3-9 follows
    Description of "Figure 3-9 Parameter Table"

  16. Click Next.
    If object compilation is required and the privilege is not given, then you can find that out from this screen.
    The screen displays the grants provided to the schema. This is for information purpose only.

    Figure 3-10 Grant Previlege Details


    Description of Figure 3-10 follows
    Description of "Figure 3-10 Grant Previlege Details"

  17. You can view the status of pre-loading procedures for static data.

    Figure 3-11 Start Pre-Load Process


    Description of Figure 3-11 follows
    Description of "Figure 3-11 Start Pre-Load Process"

  18. Click Start Pre-Load Process.
    The installer executes the procedures required before beginning static data compilation. All the triggers will be disabled during this process.
  19. Click Log button.
    The installer executes the process log.
  20. Click Next once the process is completed.
    The following screen is displayed.

    Figure 3-12 Status of Static data loaded


    Description of Figure 3-12 follows
    Description of "Figure 3-12 Status of Static data loaded"

  21. Click Load Static Data to load the static data to schema.
  22. Click Static Data Log to view the static data log.
  23. Click Next once the static data is loaded.
    You can do the basic maintenances for the table CSTB_PARAM. The above screen appears only when doing the db setup for a console source but not for a patch source(s).
    The following screen is displayed.

    Figure 3-13 CSTB_PARAM Table


    Description of Figure 3-13 follows
    Description of "Figure 3-13 CSTB_PARAM Table"

  24. Click Next once the basic setup details are done.
    You can do the basic maintenances for the tables STTM_BANK and STTM_BRANCH.
    The following screen is displayed.

    Figure 3-14 STTM_BANK and STTM_BRANCH Table


    Description of Figure 3-14 follows
    Description of "Figure 3-14 STTM_BANK and STTM_BRANCH Table"

  25. Click Next to do the basic maintenance for the table STTM_DATES.
    The following screen is displayed.

    Figure 3-15 STTM_DATES Table


    Description of Figure 3-15 follows
    Description of "Figure 3-15 STTM_DATES Table"

  26. Click Next to do the basic maintenances for the table CYTM_CCY_DEFN.
    The following screen is displayed.

    Figure 3-16 CYTM_CCY_DEFN Table


    Description of Figure 3-16 follows
    Description of "Figure 3-16 CYTM_CCY_DEFN Table"

  27. Click Next for user creation with SMS role to log in to Oracle FLEXCUBE.
  28. On User Creation screen, you can do the basic maintenances for the table SMTB_USER and SMTB_USER_ROLE.

    Figure 3-17 SMTB_USER and SMTB_USER_ROLE Table


    Description of Figure 3-17 follows
    Description of "Figure 3-17 SMTB_USER and SMTB_USER_ROLE Table"

  29. Specify the Password.
    You can use Uppercase, Lowercase, and Numerals in the password whereas you cannot use _(underscore) in the password.
  30. Click Next to view the status of the basic setup.
    The following screen is displayed.

    Figure 3-18 Status of Basic Setup


    Description of Figure 3-18 follows
    Description of "Figure 3-18 Status of Basic Setup"

  31. Click Start Setup button to compile the entries.
    This completes the static maintenance and basic setup process. The STTM_HOST_DSN entry is to be done with the DSN Name as FCJSMS000DS for SMS and the same is to be used during datasource creation in weblogic.