Upgrading Application Database

1.1 Upgrading Application Database

An upgrade is a process of updating an existing version to its higher version. For example,upgrading Oracle Financial Services Lending and Leasing from 14.11.0.0.0 to 14.12.0.0.0

Before you start with the upgrade process, execute the following grants as sys user. This facilitates to have materialized view to be created in OFSLL:

grant CREATE MATERIALIZED VIEW TO ${USERID};

Note:

Oracle Financial Services Lending and Leasing also supports direct upgrade from 14.10.0.0.0 to 14.12.0.0.0 version.

To upgrade from 14.11.0.0.0 to 14.12.0.0.0, refer to Upgrade to 14.12.0.0.0 section below.
To upgrade from 14.10.0.0.0 to 14.12.0.0.0, perform the below steps and then continue with instructions in Upgrade to 14.12.0.0.0 section.

To perform Direct Upgrade from 14.10.0.0.0 to 14.12.0.0.0, do the following:

In OFSLL 14.12.0.0.0 Release Bundle, navigate to ofslldb.zip\infrastructure\indexes and delete the file ‘upgrade_in_rel_ofsll_14_12_0_0_0.sql’
Copy ‘upgrade_in_rel_ofsll_14_10_0_0_x_to_14_12_0_0_0.sql’ file available under ofslldb_p8.zip\data_fix folder to OFSLL 14.12.0.0.0 Release Bundle \ofslldb.zip\infrastructure\indexes folder.
In the folder ofslldb.zip\infrastructure\tables, delete the file'upgrade_tb_rel_ofsll_14_12_0_0_0.sql'.
Copy 'upgrade_tb_rel_ofsll_14_10_0_0_x_to_14_12_0_0_0.sql' file available under ofslldb_p8.zip\data_fix folder to \ofslldb.zip\infrastructure\tables folder.
Create one sql folder each under ofslldb.zip\seed_data\us\combination_data and ofslldb.zip\seed_data\us\system_data to move the respective sql files in the next step.
Copy the file 'upgrade_seed_data_combination_14_10_0_0_x_to_14_12_0_0_0.sql' available under ofslldb_p8.zip\data_fix folder to \ofslldb.zip\seed_data\us\combination_data\sql\.
Copy the file 'upgrade_seed_data_system_14_10_0_0_x_to_14_12_0_0_0.sql' available under ofslldb_p8.zip\data_fix folder to \ofslldb.zip\seed_data\us\system_data\sql\.

This topic consists of the following sections:

Parent topic: Upgrade Oracle Financial Services Lending and Leasing Database