5 Post-Upgrade Tasks

Review the upgrade changes in warehouse schema and data and perform the suggested changes.

If you are upgrading from Oracle BI Applications 11.1.1.10.3PS3 to 11.1.1.10.3PS4, no DDL changes are required. You just need to make sure that the PB4 (Patch Bundle 4) is applied before you perform the in-place upgrade.

If you are upgrading from Oracle BI Applications 11.1.1.10.3/11.1.1.10.3PS2 to 11.1.1.10.3PS4, it's recommended that you check and execute the listed DDL changes and apply the PB2 (Patch Bundle 2) before proceeding with the in-place upgrade.

Grant DBMS_CRYPTO privilege to Warehouse schema user; 
Grant execute on DBMS_CRYPTO to %_DW; 

After the in-place upgrade process completes, login to the ODI repository and run the GENERATE_DW_DDL scenario in incremental mode. Make sure the Oracle BI Applications 11.1.1.10.3PS4 ODI repository Model is in sync with the target warehouse schema.

If you have configured the Domain home outside the old Oracle Home, you can delete the old Oracle Home. If you have configured the Domain home within the old Oracle Home, don’t remove the old Oracle Home. See How to Remove or Disable an Old Oracle Home?