This discussion is archived
6 Replies Latest reply: Jan 21, 2013 7:39 AM by 976369 RSS

Upgrade to BI apps 7.9.6.3

976369 Newbie
Currently Being Moderated
all,

I am a newbie to this forum. We are currently on 7.9.6.1 on BI apps and OBIEE 10g. We would be going to R12 as ebiz shortly. Now for the reporting side, is it advisable to "upgrade" to 7.9.6.3 or do a fresh install of 7.9.6.3 and run full loads on the mappings and see the dashboards as out of the box.

I understand that if we upgrade we have to update the metadata ( dac, infra, rpd and webcat) but how would they pick up the new mappings logic.

Any one facing similar issues .. please suggest!

thanks
*$
  • 1. Re: Upgrade to BI apps 7.9.6.3
    Ahsan Shah Expert
    Currently Being Moderated
    How much of 7961 have you customized and have you properly followed the proper development processes for OBIA (e.g keep INFA custom code in separate custom folders etc)? In general, you need to compare the effort of "7963 Reimplementaion + reapply customizations" versus "upgrade". There are several docs on Metalink and OTN that outline the upgrade steps and there are also some OBIEE 11g caveats with some of the OOTB OBIA RPD code. My advice is that if you dont have much 7961 ETL/DAC/OBIEE customization, a reimplementation may be better.

    Pls mark helpful or correct
  • 2. Re: Upgrade to BI apps 7.9.6.3
    976369 Newbie
    Currently Being Moderated
    that sounds logical. However, if we upgrade we would never get the new code base of BI apps right ? the new mappings and rpd. Is there a way that anyone has merged the same
    from the rpd and the bi apps 7.9.6.3 vanilla to the customized version upgraded ?

    Also, if we upgrade ( assuming that the OLTP source is unchanged) would it be advisable to run a full load as opposed to the upgrade of the data and resume the incremental ?

    thanks
    *$
  • 3. Re: Upgrade to BI apps 7.9.6.3
    Ahsan Shah Expert
    Currently Being Moderated
    check the upgrade guide for OBIA in this section:
    6.12.4 Merging the Oracle BI Repositories
  • 4. Re: Upgrade to BI apps 7.9.6.3
    976369 Newbie
    Currently Being Moderated
    As i understand there are 3 components involved

    1. Custom BI Rpd to be merged with 7.9.6.3 rpd
    2. Custom Infra mappings to be merged with 7.9.6.3 mappings
    3. Custom DAC plans to be merged with 7.9.6.3 dac plan.

    In the documentation its mentioned for point 1 as

    use OracleBIAnalyticsApps_79x.rpd + OracleBIAnalyticsApps.rpd + customer_OracleBIAnalyticsApps.rpd to get the Merged_Repository_OracleBI.rpd

    This is clear as its answered.

    For the Infra Mappings as mentioned in point 2

    Its mentioned that upgrade the customer_infra_mappings to 9.0.1 hotfix.
    copy the custom folders to the base_infra_mappings of 7.9.6.3.

    I am not sure whether this would work as the data model might change.
    Have anyone used the same.

    Also any clue about the point 3.

    Thanks
    *$
  • 5. Re: Upgrade to BI apps 7.9.6.3
    874368 Newbie
    Currently Being Moderated
    Hi all & *$

    Were you able to merge the RPDs?


    When I tried to merge the RPD after equalizing them I am having an issue : 'Finish' button is not enabled even after making decisions for all the conflicts.

    If someone was able to successfull merge please let me know.


    Thanks,
    Mod

    Edited by: 871365 on Jan 9, 2013 8:50 AM
  • 6. Re: Upgrade to BI apps 7.9.6.3
    976369 Newbie
    Currently Being Moderated
    hi mod,

    i have not gone to that extend yet .. before merging . i upgraded the customer rpd to 11g. Now the question is do i have to upgrade the rpd from /biapps/upgrade/OracleBIAPPS_7962 also ?

    if so whats the username and password ?

    thanks
    *$

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points