2 Compile Object

This topic describes the steps to compile objects from Shipment Media.

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

    Figure 2-1 Oracle FLEXCUBE Universal Installer


    Description of Figure 2-1 follows
    Description of "Figure 2-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 2-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 2-2 Option for Installation


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

  5. Click Next to choose Oracle FLEXCUBE component for installation.
  6. Select Database.
  7. Select the appropriate file separator style.
    Example: Linux or Windows.
  8. Specify the application server on which you are installing Oracle FLEXCUBE.
  9. Specify the database server on which you are installing Oracle FLEXCUBE.
  10. Choose the FCIS Schema Type and click Next.
    The schema types for Oracle FLEXCUBE Investor Servicing are given below.
    • SMS
    • SP
    • LOB
    • PENSION
    • REPORTS
  11. You need to get EXECUTE permissions for the procedures of all the schema types.
    • DBMS_CRYPTO
    • UTL_MAIL
    • CTX_DDL
    • UTL_RAW
    • CTXSYS
    • DBMS_RLS
    • UTL_RECOMP
    • DBMS_MONITOR
    • DBMS_LOCK
    • DBMS_AQ
    • DBMS_REDACT
  12. You need to get the SELECT permissions for the Tables of all the schema types.
    • GV_$INSTANCE
    • REDACTION_POLICIES
    • REDACTION_COLUMNS
  13. Select the Schema Type which needs to be deployed and click Next.
    The following screen is displayed.

    Figure 2-4 Schema Type


    Description of Figure 2-4 follows
    Description of "Figure 2-4 Schema Type"

  14. Enter the details in the FC Home, which is the location where FCIS sources copied from shipment media.
    The following screen is displayed.

    Figure 2-5 Installation Type


    Description of Figure 2-5 follows
    Description of "Figure 2-5 Installation Type"

  15. Select the appropriate Installation Type option.
    The options available are:
    • New Installation
    • Patch
    • Rolled-up Patch
  16. Provide schema details for validation in case of Patch and Rolled-up Patch installation.
    For New Installation, schema details are not enabled.
  17. Choose the required set of Main and Patch releases.
    The valid list of deployable units are displayed based on the FCHOME chosen.

    Figure 2-6 Valid Patch List


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

  18. 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.
  19. Select Compile Object under Custom Installation and click Next.
    The following screen is displayed.

    Figure 2-7 Select Compile Object


    Description of Figure 2-7 follows
    Description of "Figure 2-7 Select Compile Object"

  20. Provide directory path as required in the Destination Directory and click Next.
    This directory will be used as a staging directory to copy required files for compilation.

    Figure 2-8 Destination Directory


    Description of Figure 2-8 follows
    Description of "Figure 2-8 Destination Directory"

  21. 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.

    Figure 2-9 Copying sources in progress


    Description of Figure 2-9 follows
    Description of "Figure 2-9 Copying sources in progress"

  22. Check the status of all the files being copied and complete the copy process.
    The following screen is displayed.

    Figure 2-10 Status of Object sources being copied


    Description of Figure 2-10 follows
    Description of "Figure 2-10 Status of Object sources being copied"

  23. Click Next and provide schema details.
  24. Specify schema details.
    Refer to the table for Schema details.

    Table 2-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.
    No. of threads for recompilation

    Specify the number of threads that would be used to compile the objects. The value is defaulted to 4, if no value is given.
  25. 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 2-12 Information Message on Successful Connection


    Description of Figure 2-12 follows
    Description of "Figure 2-12 Information Message on Successful Connection"

  26. 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 2-13 Parameter Table


    Description of Figure 2-13 follows
    Description of "Figure 2-13 Parameter Table"

  27. 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 2-14 Grant Previlege Details


    Description of Figure 2-14 follows
    Description of "Figure 2-14 Grant Previlege Details"

  28. Click Generate Report to grant privilege to an item in the schema.
    The installer creates a SQL file grantScript.sql containing the script for granting the privileges in the Logs folder.
  29. You can use this file to get the access.
    Only system user can execute the file grantScripts.sql for granting privileges.
  30. You can view the count of the objects already present in the Database.
    The screen displays the count of the objects.

    Figure 2-15 Count of the Objects in the Database


    Description of Figure 2-15 follows
    Description of "Figure 2-15 Count of the Objects in the Database"

  31. On objects count screen, select the objects and click Drop to drop the selected objects. As you drop the objects, the count in this screen is updated. Click Drop All to drop all the objects at once.
  32. Click Drop Log to view the drop log.
    The details of the drop process are logged in a file Drop_All.log in the destination directory under the folder DBLogs.
  33. Click Next after the count of objects being updated.
    The screen displays the status of the objects being compiled.

    Figure 2-16 Status of DDL object being compiled


    Description of Figure 2-16 follows
    Description of "Figure 2-16 Status of DDL object being compiled"

  34. Click Load DDL to compile the table, sequences and type objects.
  35. Click DDL Log button to view the DDL logs.
    You can rectify the missing DDL objects and recompile them either manually or by redoing the DDL compilation using Installer.
    The log file LoadDDL.log will be available in the destination directory under the folder DBLogs.
  36. For SMS setup, specify the following details.
    For other schema setup, these details will be skipped.

    Table 2-3 Scheduler DDL objects compilation

    Field Description
    Include Scheduler DDLs

    Check this box to include scheduler DDLs.

    If you do not need to include the scheduler DDLs, leave this field unchecked.
    Scheduler DDL Source Path

    Specify the location of the tables_oracle.sql folder, which is available in the extracted quartz.jar.

    Note: Quartz is an open source job scheduling service. You can use Quartz to create schedules for executing jobs whose tasks are defined as standard Java components. You first need to download the file quartz.jar and extract it to the local machine.

    In the extracted folder, find the location of the folder dbTables and enter that path in the field Scheduler DDL Source Path.

    Refer the Release document for version and download url for quartz.

    The following screen is displayed.

    Figure 2-17 Compile Scheduler DDL Objects


    Description of Figure 2-17 follows
    Description of "Figure 2-17 Compile Scheduler DDL Objects"

  37. Click Load Scheduler DDLs to compile the files and click Next.
  38. Click Load Objects button.

    Note:

    You can rectify the missing objects and recompile them either manually or by redoing the Application object compilation using Installer.
    The installer loads the functions, procedures, views, triggers and packages as per your selection and compiles them. The installer loads the DDL and application objects based on the schema type selected.

    Figure 2-18 Status of Object sources being compiled


    Description of Figure 2-18 follows
    Description of "Figure 2-18 Status of Object sources being compiled"

  39. Click Objects Log button to view the log.
    The log file LoadAppObj.log will be available in the destination directory under the folder DBLogs.
  40. Click Next to view the list of invalid objects in the DB.
    The following screen is displayed.

    Figure 2-19 Invalid Lists in DB


    Description of Figure 2-19 follows
    Description of "Figure 2-19 Invalid Lists in DB"

  41. Click Invalid List button to view the count of invalid objects.
    The installer creates the file InvalidList.txt in the destination directory under the folder DBLogs.
  42. You can use Recompile button to do a cyclic recompilation. This will reduce the invalid objects count.
    The Installer allows you to use Recompile button multiple times, in order to reduce the invalid objects count.
  43. In case if the invalids still exist, use the recompile option after running the Cross Schema Scripts Utility.
    Refer the topic Cross Schema Scripts for running the Cross Schema Scripts Utility.