1. Upgrade Installation Guide
  2. Upgrade Oracle Financial Services Lending and Leasing Database
  3. Upgrading Application Database
  4. Upgrade to 14.12.0.0.0

1.1.1 Upgrade to 14.12.0.0.0

Choose 2 as the installer option at the Selecting the Install Type stage, then the script runs the upgrade installer.

Figure 1-1 Command prompt window 1


Description of Figure 1-1 follows
Description of "Figure 1-1 Command prompt window 1"

Respond to the prompts and continue. For more details, refer to Installing Upgrade section in Database Installation Guide.

While installing the upgrade, the installer performs the following tasks:

  1. Stop the running services, if any.

    Figure 1-2 Command prompt window 2


    Description of Figure 1-2 follows
    Description of "Figure 1-2 Command prompt window 2"

  2. In case you see the below prompt to stop the queue for loading objects, press Y and press Enter to confirm.

    Figure 1-3 Command prompt window 3


    Description of Figure 1-3 follows
    Description of "Figure 1-3 Command prompt window 3"

  3. In case the Schema is EBR (Edition based Redefinition) enabled,
  4. Install the upgrade.

    Figure 1-6 Command prompt window 6


    Description of Figure 1-6 follows
    Description of "Figure 1-6 Command prompt window 6"

  5. Recompile the invalid objects and complete installation.

    Figure 1-7 Command prompt window 7


    Description of Figure 1-7 follows
    Description of "Figure 1-7 Command prompt window 7"

  6. Install the database object of web services by referring to the instructions detailed in chapter 2 Installing WebServices Database Objects of WebServices Installation Guide.
  7. Grant access/permission by doing the following:
    • Grant java file permissions for the directory objects created by executing the script set_java_perms.sql available in dba_utils folder. For more information, refer to the process detailed in section 2.5 of Database installation guide.
    • Post upgrade, you need to execute the following db script available in dba_utils folder.
      • To provide access to all the new ‘Screens’ and/or ‘Web Services’ for a specific responsibility, execute set_screen_access.sql
      • To provide access to all the new Reports, Transactions, Correspondence for a specific responsibility, execute set_rpt_txn_cor_access.sql

    In the prompt, enter the user responsibility. You can also specify ALL to provide screen access to all the users in bulk.

    Further, you can customized the access through Setup > User > Access screen as detailed in Setup Guides.

    Note:

    • Post upgrade, if there are any invalid java stored procedures noticed, please recompile the respective units manually.
    • In case where ‘Edition based Redefinition’ (EBR) is enabled, the default edition of database is to be modified/switched to the new edition. This is to be done by system administrator only after both Database Patch and Webservices Patch objects are installed as mentioned in chapter 2 and chapter 4.2 and when all the database objects are in valid state.

Parent topic: Upgrading Application Database