1.2 Setting up Database for Open Development Tool

This topic provides the systematic instructions to set up database for Open Development Tool.

To set up database for Open Development Tool (ODT), follow the steps given below:
  1. Run FCUBSInstaller.bat batch file to launch Oracle FLEXCUBE Investor Servicing Installer.
  2. Click Next.
  3. Click Open Development Tool.
  4. Click Next.
    The following screen is displayed.
    Description of select-database.png follows
    Description of the illustration select-database.png

  5. Select Database as Oracle FLEXCUBE component for installation.
  6. Specify the following details.
    1. Operating System: Specify the operating system in which you are installing Oracle FLEXCUBE.
    2. Database Server: Specify the database server on which you are installing Oracle FLEXCUBE.
  7. Click Next.
  8. Browse for Console_EXEC folder and click Next.
  9. Select the console type and select Next.
  10. Specify the destination directory. You can use the directory icon to browse to the source directory location.
  11. Click Copy.
    The following screen is displayed.
    Description of copy-sources.png follows
    Description of the illustration copy-sources.png

  12. Click Copy to copy the source from source directory to the destination directory.
    Once the source is copied, the following screen is displayed.
    Description of provide-schema-details.png follows
    Description of the illustration provide-schema-details.png

  13. Specify the following schema details:
    1. User Name: Specify the user name to access the schema.
    2. Password: Specify the schema password for the above user name.
    3. Service Name: Specify service name of database.
    4. IP Address: Specify the IP address of the system where the database schema is installed.
    5. Port: Specify the port number.
    6. TNS Connect Descriptor: Specify a valid connect string that contains the details for database connectivity.
  14. Once you have specified the details, click Test Connection button to test the database schema connection.
    The below message is displayed if the connection is established successfully.
    Description of connection-successful-warning-message.png follows
    Description of the illustration connection-successful-warning-message.png

  15. Click Next.
  16. 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.
    Description of load-odt-ddl.png follows
    Description of the illustration load-odt-ddl.png

  17. Click ODT DDL Log to see the log.
  18. Click Next.
  19. Click Load ODT Objects button to compile APP objects. The installer loads the functions, procedures, views, triggers and packages as per your selection and compiles them.
    You can verify the application objects compilation by comparing the count shown in this screen with the release count.
  20. Click ODT Objects Log to view the log.
    The log file LoadODTObj.log will be available in the destination directory under the folder DBLogs.
  21. Click Next.
    The following screen is displayed.
    Description of invalids-list.png follows
    Description of the illustration invalids-list.png

  22. Click Invalids List button to view the count of invalid objects in the database.
    You can view the file InvalidList.txt created by the installer in the destination directory under the folder DBLogs.
  23. Click Recompile to recompile any invalid objects if present.
    This reduces the invalid object count. The Installer allows Recompile multiple times in order to reduce the invalid objects count.
    The following screen is displayed on successful recompilation of ODT Objects.
    Description of recompile.png follows
    Description of the illustration recompile.png

Parent topic: Open Development Tool Installation