Looking Towards the BI Apps 11g Part 1 : BI Apps 11g Product Roadmap

July 11th, 2012 by

Whilst this blog is most well known for articles on OBIEE, ODI, Essbase and data warehousing, many of the projects we work on are actually Oracle BI Applications implementations, out of our offices in the UK, India, USA and Australia. Recently we’re getting asked more and more about the product roadmap for the BI Applications, with questions typically around whether ODI will be supported going forward, whether ODI will actually replace Informatica, and whether customers can actually upgrade to BI Applications 11g now. So over the next three postings, I’ll be looking at what’s coming up for the Oracle BI Applications, answering some questions around migrations and technology platforms, and looking at what we can do as customers and developers to get ourselves ready for BI Apps 11g.

I’ll add the links in as the postings are published, but here’s the topics and links for the other parts of the series:

For anyone new to Oracle BI or Oracle’s packaged applications, the Oracle BI Applications take the Oracle Business Intelligence Enterprise Edition platform and use it to deliver sets of predefined ETL routines, dashboards and analyses all built on a common, dimensional data model. Oracle BI Applications is licensed per module (Financials, Supply Chain etc) and separate to the BI Apps purchase you also need to license Informatica PowerCenter, a third-party ETL tool that Oracle resells, and these ETL routines are orchestrated by an Oracle product called the Data Warehouse Administration Console, or DAC, which maintains a central record of what ETL routines are required to load your data. For some background into the BI Applications 7.9.x series, take a look at this Introduction to the Oracle BI Apps posting back from 2008, and this one on what’s in the Oracle BI Applications data warehouse from around the same time.

When Oracle acquired Siebel back in 2007, from a BI perspective Siebel had two main product lines; Siebel Analytics, which became the foundation for Oracle Business Intelligence Enterprise Edition, and Siebel Business Analytics, which more or less is what the Oracle BI Applications are today. Siebel Business Analytics covered areas such as sales analytics, service and contact centre analytics as well as ERP areas such as financials and supply chain; if you’re interested in a bit of history, here’s an original Siebel Business Analytics brochure back from 2005 that’s details both the Business Analytics and Analytics products. In fact, the CRM and ERP parts of Siebel Business Analytics had different data models, with the ERP content originally coming from Informatica Warehouse, a product Informatica sold alongside PowerCenter and their own query tool, Informatica PowerAnalyzer (and which Informatica themselves acquired through a company called Influence Software, which they acquired back in the late 90’s). Already well underway by the time of the Oracle acquisition was “Project Tenerife”, to merge the two data models together, with the product then becoming the Oracle BI Applications that we know today.

Now though, there are three distinct development branches of the BI Applications, and a fourth one that had just one release and then ended:

  • Oracle BI Applications 7.9.6.x (currently at, the mainstream version of the BI Applications with modules covering Oracle EBS, Peoplesoft, JD Edwards and Siebel source applications (often referred to as  “Applications Unlimited” sources, due to their legacy nature but Oracle’s commitment to support them forever)
  • Oracle BI Applications 11.1.1.x (currently at, the next-generation version of the BI Applications that currently only sources data from the Oracle Fusion Applications, but in time will cover the Applications Unlimited sources as well
  • Oracle BI Applications 7.9.7.x, which sources data from SAP and has a much smaller amount of analytic modules, but unlike the other two BI Apps branches uses Oracle Data Integrator (ODI) for the data integration tasks, not Informatica PowerCenter.

Those of you with long memories might also remember a branch of the BI Apps back in 2009 that sourced data from Oracle EBS but used Oracle Data Integrator as the data integration tool; Oracle BI Apps turned out to be a one-off release though, with no further modules, sources or targets covered, but was interesting as a preview of how Oracle might tackle an eventual move to ODI as the ETL tool, and also it highlighted those areas where ODI didn’t have the required functionality to replace Informatica. We covered the release in quite a bit of details when it first came out, and you can read some background to it in four blog posts that set out an introduction to the release, technology changes to accommodate ODI as an alternative to Informatica PowerCenter, data loading and customisation.

Oracle have also stated some long term plans and objectives for the BI Applications:

  • To enable customers to choose between either Informatica PowerCenter, or Oracle Data Integrator, as their data integration tool
  • To eventually support Applications Unlimited customers within the BI Apps 11g release as well, so that it will cover Oracle EBS, Oracle Fusion Applications, Siebel CRM, Peoplesoft and JD Edwards
  • To try and reduce the total cost of ownership for the BI Apps, particularly around areas such as setup and configuration, and the customisation process
  • Increase the scope and depth of the subject area modules, move ETL to as near to real-time as possible, and also make it practical to run the BI Applications in the cloud.

As of Collaborate’12 in April 2012 in Las Vegas, the current release roadmap for these three development branches was presented by Florian Schouten, Oracle’s Senior Director, Product Management/Strategy in charge of BI Apps as looking like this:


What this is telling us is a few things:

  • There’ll probably be one more major BI Apps 7.9.6.x release, more as a tidy-up and integrating all bug fixes, extensions etc. This will then be the terminal release for this branch of the BI Apps
  • At some point in the next twelve months, there’ll be a release of the BI Applications 11.1.1.x that will support Apps Unlimited customers but will only use Oracle Data Integrator as the data integration tool.
  • Later on in the next twelve months, there will be a further 11.1.1.x release that will also offer Informatica as the ETL tool for Apps Unlimited customers. 

This has a few implications and things to be aware of:

  • At the point where the 11.1.1.x release supports Apps Unlimited customers but only through ODI, you’ll be able to start new, green-field BI Apps projects covering both the Fusion Apps and Apps Unlimited data sources, but there’ll be no migration path to take you from Informatica to ODI, so existing BI Apps customers using Apps Unlimited sources will need to wait for the next release before moving to BI Apps 11g
  • When the subsequent 11.1.1.x release comes along, again within a twelve month (planned) timescale, existing Apps Unlimited customers will them be able to move to 11g as Informatica will be supported again. There’s still be no (automated) Informatica to ODI migration path though, so the current thinking is that if you’re on Informatica, you’ll stay on Informatica

Going forward from this point, the plan is to offer all modules and all sources through both Informatica and Oracle Data Integrator, with no forced migration from one to the other. SAP customers using the 7.9.6.x product will stay for the time being in their own development stream, continuing to use ODI as their data integration engine, with the aim being to merge the SAP stream back into the BI Apps 11.1.1.x series in due course.

So now we know a bit more about the roadmap, what does Oracle BI Applications 11g look like, and what new end-user, development and administration tools can we expect to see? Stick around for a couple of days and we’ll cover this topic next in the series.


  1. Venkat Says:

    Thanks Mark,
    I have couple of questions on this subject
    1. What is the motivation/requirement for customers who are on BI Apps 7.9.6.x to migrate to BI Apps 11.1.1.x? I can see OBIEE 11G platforms is certified with BI Apps 7.9.6.x and the future releases of BI 11G will also be certified with BI Apps 7.9.6.x as and when they release. Informatica 9.1.x also certified with BI Apps 7.9.6.x.

    What is the extra benefit of upgrading to BI Apps 11.1.1.x?

    2. As per my knowledge of BI Apps, it is with Infa 8.6.1, where as BI Apps 7.9.6.xcustomers are are on higher version (9.0.x/9.1x). Infa upgrade could be an issue until BI Apps comes with Infa 9.1.x
    3. Apart from the extra JEE Applications (Configuration Manager, Functional Setup Manager etc), what is the real benefit of upgrading 7.9.6.x customer solution to BI Apps Does this version come with extra content for Fin/HR/Proc etc?

    Thanks in advance,

  2. Mark Rittman Says:

    Hi Venkat

    1. At this point, apart from generally staying on the most recent release we don’t know what the benefits for current customers will be in moving to BI Apps 11g – but presumably any new modules, capabilities, updates to EBS source versions etc will come into the BI Apps 11.1.1.x releases rather than endless extensions to 7.9.6.x. Don’t forget thought that this is all some while off – within 12 months of Collaborate – and the first version of BI Apps 11.1.1.x that includes 7.9.6.x modules and functionality will be ODI-only, with no INFA migration path – support for INFA in this release stream will come later in the 12 months.

    2. Presumably, by the the time that BI Apps 11.1.1.x incorporates modules and the ability run ETL using INFA, i.e. existing customers will migrate, BI Apps 11.1.1.x will have moved to INFA 9.1.x or higher to bring the INFA versions together.

    3. See answer to 1) – Existing BI Apps 11.1.1.x is focused on Fusion Apps sources and customers, so what BI Apps 11.1.1.x will include when it begins to support 7.9.6.x customers, we just don’t know – at this point release sequencing and general plans to bring streams together have been announced, but not what modules or BI Apps 11.1.1.x will contain after Apps Unlimited customers come into the release.


  3. Narendra Says:

    Hi Mark,
    while trying to open the following page “Siebel Business Analytics brochure back from 2005″, it is prompting for credentials. Could you please by pass it.
    Appreciated it.

  4. Paul Says:

    Thanks Mark.

    We are on OBIA 7.9.6 Financial Analytics for JDE. Do you think it would be advisable for us to try and move off the INFA OEM version that comes with OBIA and onto a full INFA licence so that we can extend / customise our OBIA instance as opposed to trying to migrate it to ODI?



  5. Mark Rittman Says:

    Hi Narendra

    I’ve corrected the link, it shouldn’t ask you for credentials now.


  6. Mark Rittman Says:


    My understanding of the INFA OEM license is that it allows you to extend the OBAW through customizations etc; it’s just that you can’t also use it for general-purpose ETL on other projects, target databases etc. So I don’t think you’d need to get the extra license for what you’re looking to do – all customers need to make customizations, as long as what you’re running is still part of the OBAW and managed by the DAC, I’d say you were covered (though Oracle are the only people who can 100% confirm this, of course).


  7. Florian Schouten Says:

    Hi Mark,

    Your response to Paul is accurate. Thanks,


  8. Richard Black Says:

    Mark, Thank-you so much to laying this all out, it’s very helpful. It’s also rare for me to find such clarity. R.

  9. Mark Rittman Says:


    You’re welcome,


  10. Denim Says:

    Nice look out on BI Apps… Thanks for sharing this Article.

  11. Mark Whitlock Says:

    Great article Mark,

    Do you (or anyone else) see any reason for a company currently using Informatica to switch to ODI from a functionality or total cost of ownership point of view?

Website Design & Build: tymedia.co.uk