Updating Oracle BI Apps 7.9.5.1 to 7.6

This is a compilation of information based on our current installation and based on the update and installation guide leading to a successful upgrade to 7.9.6. from 7.9.5.1.

Our source and target databases are Oracle.

This is just a synopsis of the steps we followed.

For a more detailed explanation you can visit OTN and download the relevant documentation.



1. You want to backup all existing information.

- DAC repository (thru DAC export option)

- DAC install folder

- BI Apps RPD

- BI Apps Catalogue

- Informatica repository



Remember all installation directories should be in locations which do not have a space in the location. eg: DO NOT install informatica or java in C:\Program Files. This will cause problems for DAC (which is needed to run the informatica mappings).



2. Uninstall the existing BI Applications and then restart your machine

3. Unset all informatica variables

4. Install BI apps 7.9.6

5. Install Informatica 8.6 + HotFix 4 - create integration and repository services if they do not exist. update Informatica repository

6. Install DAC - update DAC repository

7. Set parameters in DAC and Informatica to connect to databases

8. Check the pmrep and pmcmd connections

9. Build an execution plan with a single subject area (uncheck all options) to test that all connections are in place and then proceed to build with additional subject areas.