0 Replies Latest reply: Jun 27, 2013 10:08 AM by user12997203 RSS

    Biaaps datawarehouse migration from 7.9.6.2 to 7.9.6.4

    user12997203

      what is the best approach to perform this migration.

       

      current version that i am having:

      BI APPS 7.9.6.2(Financial,Projects and SCM)

      EBS 11.5.10

      Informatica 8.6

      Dac 10g

      Database for OBAW 10g

      Datawarehouse has 5 years of data sourcing  from ebs 11.5.10 and is up and running.

       

      our source system has been re implemented with ebs r12 and all the old data that is in ebs 11.5.10 has not been migrated to ebs r12.

      I have installed biapps 7.9.6.4 platform with obiee 11g and indormatica 9 and dac 11 with oracle database 11g and is also up and running.

       

      I am not bothered about the migration of DAC,INformatica and OBIEE but i would like to know the best approach to migrate the data from the old warehouse(db version 10g) to the new warehouse(oracle db version 11g) and to be used in the analysis going forward.

       

      I went through the following link from oracle and it shows that we need to upgrade the datawarehouse to 7.9.6.3 and then to 7.9.6.4 within the same source i.e 7.9.6.2 to 7.9.6.3 for ORA11i and 7.9.6.2 to 7.9.6.3 for ORA12.

       

      In my case my source system has also been migrated to ebs r12.are there any data model differences for 7.9.6.4 for ebs r12 compared to ebs 11.5.10.

       

      http://docs.oracle.com/cd/E35287_01/bia.7964/e35270/upgr_oracle.htm#CHDJEHIJ