1 Set up Database for ODT

This topic explains the steps to set up Database for ODT.

Run FCUBSInstaller.bat batch file to start Oracle FLEXCUBE Investor Servicing Installer.
  1. Start Oracle FLEXCUBE Universal Installer.
    The Oracle FLEXCUBE Universal Installer is displayed.

    Figure 1-1 Oracle FLEXCUBE Universal Installer


    Description of Figure 1-1 follows
    Description of "Figure 1-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 1-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 Open Development Tool from the lists of Oracle FLEXCUBE options.
    The available options for installation are displayed.

    Figure 1-2 Option for Installation


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

  5. Click Next to choose Oracle FLEXCUBE component for installation.
  6. Select Database.
  7. Select the appropriate operating system from the File Seperator Style drop-down.
  8. Choose Weblogic from the Application Server drop-down.
  9. Select the appropriate DataBase Server from the drop-down and click Next.
  10. Click Next to specify Installation Type.
    The following screen is displayed.

    Figure 1-4 Installation Type_FC Home


    Description of Figure 1-4 follows
    Description of "Figure 1-4 Installation Type_FC Home"

  11. Browse for file Console_EXEC in the FC Home and click Next.
  12. Specify the destination path.
    You can use the directory icon to browse to the source directory location.
    The following screen is displayed.

    Figure 1-5 Destination Path


    Description of Figure 1-5 follows
    Description of "Figure 1-5 Destination Path"

  13. Click Next to specify the patch list details.
    The following screen is displayed.

    Figure 1-6 Valid Patch List


    Description of Figure 1-6 follows
    Description of "Figure 1-6 Valid Patch List"

  14. Click Next to view the status of sources being copied to destination folder.

    Figure 1-7 Status of the objects sources being copied


    Description of Figure 1-7 follows
    Description of "Figure 1-7 Status of the objects sources being copied"

  15. Click Copy.
    The following screen is displayed.

    Figure 1-8 Copy in Progress


    Description of Figure 1-8 follows
    Description of "Figure 1-8 Copy in Progress"

  16. Click Next once the source is copied to specify schema details.
  17. Specify the following schema details in the database installation screen and click Next.
    Refer to the table for schema details.

    Table 1-2 Schema details

    Field Description
    User Name

    Specify the user name to access the schema.
    Password

    Specify the schema password for the above user name.
    Service Name

    Specify service name of database.
    IP Address

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

    Specify the port number.
    TNS Connect Descriptor

    Specify a valid connect string that contains the details for database connectivity.
  18. Click Test Connection to test the connection with the Application server.

    If there is an error in establishing the connection, the system displays the message Invalid DB Credentials.

    If the TNS entry is not proper, the installer displays the message TNS entries are not proper.

    If the connection is established, the installer displays the message Connection Successful.

    Figure 1-10 Information Message on Successful Connection


    Description of Figure 1-10 follows
    Description of "Figure 1-10 Information Message on Successful Connection"

  19. Click Next to view the status of the ODT DDL objects being compiled.
    The following screen is displayed.

    Figure 1-11 Status of the ODT DDL objects being Compiled


    Description of Figure 1-11 follows
    Description of "Figure 1-11 Status of the ODT DDL objects being Compiled"

  20. Click Load ODT DDL button to start compiling.
    You can verify the DDL objects compilation by comparing the current count and the release count. The release count is the number of files in the temporary folder to which the files are copied.
    The objects Type, Table, and Sequence will be compiled and the count will be updated.
  21. Click ODT DDL log to see the log.
  22. Click Next to view the status of the ODT APP objects being compiled.
    The following screen is displayed.

    Figure 1-12 Status of the ODT APP objects being Compiled


    Description of Figure 1-12 follows
    Description of "Figure 1-12 Status of the ODT APP objects being Compiled"

  23. Click Load ODT Objects button to compile APP objects.
    The installer loads the functions, procedures, views, triggers and packages as per selection and compiles them.

    Note:

    You can verify the application objects compilation by comparing the count shown in this screen with the release count.
  24. Click ODT Objects Log to view the log.

    Note:

    The log file LoadODTObj.log will be available in the destination directory under the folder DBLogs.
  25. Click Next to view the list of invalid objects in the DB.
    The following screen is displayed.

    Figure 1-13 Invalid Lists in DB


    Description of Figure 1-13 follows
    Description of "Figure 1-13 Invalid Lists in DB"

  26. Click Invalids List button to view the count of invalid objects in the database.
    The installer creates the file InvalidList.txt in the destination directory under the folder DBLogs.
  27. Click Recompile to recompile any invalid objects if present. This reduces the invalid object count.

    Note:

    The Installer allows Recompile multiple times in order to reduce the invalid objects count.
  28. You can view the status of recompilation of ODT objects.
The database is set up for the ODT installation.