The Oracle BI Application Blogs provides the latest and tips and tricks on Oracle BI Applications Product (OBIA)

BI apps is available now

Oracle Business Intelligence (BI) Applications is now available on the Oracle Software Delivery Cloud (eDelivery), and on the Oracle BI Applications OTN page. This is the second major release on the 11g code line leveraging the power of ODI, and certified with the latest version of Oracle BI Foundation

Highlights from the announcement.


What’s New

This new release of Oracle Business Intelligence Applications 11g adds:

1. Prebuilt Connector for Oracle Procurement and Spend Analytics with Oracle JD Edwards

2. Expanded functional content coverage across existing Oracle BI Applications

3. New utilities and enhancements to increase productivity and further drive down Total Cost of Ownership (TCO)

New Prebuilt Connector for BI Applications

· Oracle Procurement and Spend Analytics introduces a new adapter that provides out-of-box integration between Oracle Procurement and Spend Analytics and Oracle’s JD Edwards EnterpriseOne, enabling purchasing and sourcing organizations quickly identify savings opportunities and improve operational performance through decision-ready, best practice analytics.

New Content Enhancements:

Significant expansion of content improves existing Oracle BI Applications including:

· Oracle Human Resources Analytics expands analysis on HR programs and workforce performance with the introduction of Talent Management Analysis, to help HR and business managers assess talent strengths and build potential leaders by delivering greater insight into job profiles. Improvements to Absence Management,
new support for Workforce Frozen Snapshots and Workforce Flex Fields are also available.

· Oracle Financial Analytics improves company Financial Performance with the new Subledger Accounting Module, providing complete account balance analysis, including supporting reference balances and drill down to accounting transactions. Aging Snapshot restoration for Receivables and Payables, drilldown from Payables
to Purchase Orders, and Fixed Assets support for GL Posting Status are features also included in the release.

· Oracle Project Analytics expands insight into project-based data with new Earned Value Management Analysis, providing visibility for Project Stakeholders into Planned Value,  Earned Value, and Actual Cost. Analysis of variances and indices, derived from Cost and Schedule Variance, CPI, TCPI, SPI and TSPI, is also available.

· Oracle Supply Chain & Order Management Analytics introduces Costing and Inventory Turn support for Oracle JDE EnterpriseOne. In addition, the ability to save and restore the Inventory Snapshot when executing a full load is now supported.

· Oracle Student Information Analytics introduces new Financial Aid Analysis, containing term-based detail information associated with a student award such as amount, status, disbursement, and aid type.

· Oracle Manufacturing Analytics and Enterprise Asset Management Analytics have been re-introduced into the BI Applications data model. Although new with ODI, both modules provide now the same broad functionality available with BI Applications

· Unstructured Data for Information
– The BI Applications Data Model has been extended to include unstructured CRM and ERP text fields. Sample Information Discovery templates – including ODI interfaces and runtime security definitions –provide the ability to quickly create sample Information Discovery Applications from combined structured and unstructured data.

New Utilities and Enhancements to increase productivity and drive down TCO

· New Data Lineage Tool allows customers and implementers to track lineage from source to target – improving information transparency across their enterprise

· Configuration Management expands System Setup and Load Plan definition capabilities, including the registration of multiple instances for the same Product Line Version, UI enhancements to support DW connection configuration and Load Plan definition, and Load Plan definition migration.

Fact Partitioning IKMs and Parallel Index Builds are key performance Innovations introduced with this release. The former enables a feature that tags partitions so that only the indexes that need to be re-built during incremental loads are executed. The latter uses ODI parallel process so that Indexes can be built using multiple session (faster than and in addition to DB parallel).


Join the discussion

Comments ( 24 )
  • Naeem Akhtar Friday, May 9, 2014

    What about the Informatica Release of BI Apps which was said to be available within a year of OBIA release?

  • Venkat Gali Friday, May 9, 2014

    Hello Saurabh,

    Thanks for the update. Are there any plans to certify ODI 12C with OBIA I could see that ODI 12C has changed considerably with INFA style mappings and many more new features


    Venkat Gali

  • guest Friday, May 9, 2014


    We are working on it, apps will typically move to 12c stack with all other components together due to compatibility reasons.


  • guest Friday, May 9, 2014

    Hi Saurabh,

    Will there be other planned release with ODI 11g or the next releases will be using ODI 12C only ?



  • guest Friday, May 9, 2014

    Rel9 will use 11g for sure. We will go to 12 for entire stack together (obiee, odi, wls etc)

  • Shivanand Sunday, May 11, 2014


    Is there an upgrade path from Oracle BI Applications installed on Oracle BI Foundation Suite to Oracle BI Applications



  • Ed Martin Thursday, May 15, 2014

    I saw the note on the Data Lineage tool. Previously Oracle had a Data Lineage Document. It was good when starting a project because you could get a good understanding of the data, data conversions, and data flows. Will Oracle have a Data Lineage doucment for the OBIA versions going forward. The tool is good,but the document is excellent for the Project Requirements and Design Phases.

    Ed Martin

  • guest Friday, May 16, 2014

    Hi Ed

    The data lineage documents for various subject areas are available on the portal http://content.oracle.com/site/pd/fmw/products/bi/BIApps/index.html. You can refer to these for your analyses.


  • guest Tuesday, May 20, 2014

    I second the questions from Shivanand and Naeem,

    Is there an upgrade path from OBIA to The documentation on OTN only covers new installations.

    Also, when will any of the new OBIA 11g content be ported to the Informatica release (7.x)? The original message from Oracle was that Informatica releases would be ~12 months behind ODI releases, but we have not seen anything for 7.x yet. I'm sure that with the lack of any new 7.x developments, customers are starting to get nervous in terms of long term support for this branch.

    Many thanks,


  • guest Wednesday, May 21, 2014

    Hi Andy, Shivanand, Naeem

    To your query on upgrade, pls refer to Oracle BI Applications Upgrade Guide (Doc ID 1673221.1) on My Oracle Support. This document gives detailed info on steps to upgrade installations to



  • guest Wednesday, May 21, 2014

    Hi Ed

    Pls refer to My Oracle Support "OBIA 11g: Data Lineage Documentation for Oracle Business Intelligence Applications (Doc ID 1673715.1)" for all the data lineage documents. You should be able to access these documents directly.



  • Doug Ross Wednesday, May 21, 2014

    This link does not work for the data lineage:


  • guest Saturday, May 24, 2014

    Can BI Apps be used with Informatica PowerCenter? Can BI Apps user upgrade to this version?

  • guest Tuesday, June 10, 2014

    Can BI Apps be used with Informatica PowerCenter?


    Can BI Apps user upgrade to this version?


  • Amol Tuesday, June 10, 2014


    Is there a Demo or Sample Data in form of scripts or the database itself available for OBIA on ODI, if so where can I find it? By Demo Data I mean a Made up data for all Pre-built OOTB OBIA Dashboards and Reports in various modules like HR, Campus solution, Finance etc. (Not SampleApp)



  • guest Thursday, June 12, 2014

    I am also interested to know if BI Apps can be used with Informatica. What is the status of future releases for Informatica?



  • guest Tuesday, July 1, 2014

    I was wondering if anyone has done the upgrade from to If so, was it successful and what's the time-frame we are looking at?



  • guest Tuesday, July 15, 2014

    What is the typical time frame for configuring a single module of BI Apps?



  • guest Wednesday, August 20, 2014


    Depending on BI apps module and level of customization it may take 3 to 4 months. If you are planning to configure OOTB then 4 to 6 weeks would be max.


    Girish Kapur

  • guest Tuesday, October 7, 2014

    Where can i find a certification matrix for OBIA please?

  • Eric Tremblay Tuesday, November 25, 2014

    Where can I find information on customizing BI Apps ? I have the http://docs.oracle.com/cd/E51479_01/doc.111181/e51483/customizing.htm#i1027294 document but I'm trying to create a new dimension but I'm getting errors in the new SDE mapping ODI BI APPS ODI-15519 THE TARGET CANNOT BE CHANGED. I cannot change the target table... Not much documentation on how to do this.


  • guest Friday, December 12, 2014

    where can you find the information related to multiple instances connection for the same product line??

  • Veera Thursday, January 7, 2016


    Is there any update on ODI 12c with Bi apps release? We would like to know if BI apps is going to be in ODI 12c soon as we are waiting to upgrade from 7963 to ODI version.

  • guest Thursday, January 7, 2016

    The next major version of BI apps will be on ODI 12c. It will be either FA Rel12 compatible or Rel13.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.