EBS Sysadmin Primer: Oracle BI Discoverer 11gR1

[Editor: This is the fourth in a multi-part series from Nirzari Raichura, a senior member of our ATG Certification team, on essential Fusion Middleware concepts and tools for the EBS sysadmin]

Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.  We certified Discoverer 11g version (a.k.a. Patchset 2) with the E-Business Suite a few weeks ago.

With that recent certification, I think it's time to cover the installation and configuration of Discoverer 11g with E-Business Suite.  Discoverer 11g's integration with the E-Business Suite works identically to Discoverer 10g, and all of the business intelligence functionality continues to work as in previous Discoverer releases.  The major changes in this release come from Discoverer's installation dependencies on Oracle Application Server components.

As with other Fusion Middleware components, Oracle Weblogic Server is the required application server for Discoverer 11g.  Like Oracle Identity Management 11g, Discoverer is loosely-coupled with Fusion Middleware's database and application server components. 

Discoverer 11g Install comes bundled with Oracle Portal, Oracle Forms, and Oracle Reports, as in previous releases like Discoverer 10g.  Since it is loosely coupled with other Fusion Middleware components, you need to install a number of prerequisites prior to discoverer 11g install.

All of these middleware components have to be at the same version level to work together.  I have summarized these dependencies in the following table:

Table summarizing Discoverer 11g prerequisites
Related Articles



Oracle Reports, really? I thought Oracle Reports was replaced by BI Publisher? Is that only within EBS R12.1.2? Maybe this is the Reports Manager (FRM) introduced with and expanded in R12 to work with WebADI?

Sorry for all of the questions.

On another note, as soon as we can get the window to the the 11gR2 PSU #2 applied, I'll let you know how the Adv. Comp. testing is going...:-)


Posted by John Stouffer on August 09, 2010 at 08:38 PM PDT #


The majority of EBS reports have been migrated over to BI Publisher now, and BI Publisher is the recommended reporting solution within the E-Business Suite at this point. We continue to deliver Oracle Reports as part of the EBS techstack for legacy or customer reports that may still depend on that technology.

Good luck with your upgrade.


Posted by Steven Chan on August 10, 2010 at 12:58 AM PDT #


Thanks for the prompt response. The upgrade is going well with the one exception but I think we'll get past that issue or, at a minimum, be able to use it in some parts of our environment.

See you in San Fran.


Posted by John Stouffer on August 10, 2010 at 11:11 PM PDT #

Hi Steven,

There is some confusion from me about Discoverer/Weblogic installation. Can you tell me if we can use different Unix id to install the 2 products or we need to use same id? If we can use 2 id, do they both need to be in DBA group? In 10g, we use applmgr to install Discoverer on application server with different Oracle Home and profile. I can't find the document clearly indicate the installation ID requirement.
Also. is there any difference in the install as we are to use Discoverer 11G with Oracle E-business vs as standalone i.e. from the perspective of Unix ids?


Posted by Vivian on December 17, 2010 at 04:48 AM PST #


Oracle BI Discoverer has a multitier architecture so it is possible to install all tiers over multiple machines, to maximize performance and reliability. Logically you can install using different unix ids. You can refer to configuration guide for Oracle Business Intelligence Discoverer::



Oracle Fusion Middleware High Availability Guide: http://download.oracle.com/docs/cd/E14571_01/core.1111/e10106/classic.htm#CIHIEHDI

to get better idea of various topologies supported.

Let me know if you have any further questions,


Posted by Nirzari on December 19, 2010 at 06:57 PM PST #

Hi Trying to install oracle BI discoverer 11g so that i can integrate it with oracle EBS release 12. All the documention are complex and ignore the simple things for amatures. My Qn, they say Discoverer has to be installed in a different Oracle Home. But Can i have discoverer installed on the same Physical server with EBS?.

All the above Preliqisites Which ones do i install before intalling Discoverer, during the installation and after?


Posted by guest on January 11, 2012 at 05:04 PM PST #

Hi, Guest,

Yes, it's true that Oracle documentation tends to assume a reasonably-high level of expertise.

You can install Discoverer on an E-Business Suite application tier server. You should ensure that that server has sufficient disk space and available CPU and memory to handle both loads.


Posted by Steven Chan on January 13, 2012 at 08:50 AM PST #

Hi Steven, when you say that the majority of the EBS reports have been migrated over to BI Publisher, do you know what version of EBS this occurred in? We have Oracle Reports 6i and are going through an R12 upgrade. We were thinking of upgrading Oracle Reports to the latest version but it sounds like they may have already been upgraded to BI Publisher? Does BI Publisher come with EBS now?

Thank you!

- Troy -

Posted by Troy on January 31, 2012 at 12:38 PM PST #

Hi, Troy,

Apologies for the delay in responding to this.

I don't have a formal comparison to refer to, but my understanding is that nearly all of the EBS reports in EBS 11i were migrated to BI Publisher in R12.0.0. The later E-Business Suite R12.0.4 release completed the migration.

As of today, you should be planning on upgrading to EBS 12.1.3. All reports formerly run under Oracle Reports should be converted to BI Publisher in that release.

I'm not a licencing specialist, but my understanding is that a restricted use licence for BI Publisher comes with Oracle E-Business Suite Release 12. That licence allows you to run the prebuilt EBS reports. If you wish to develop custom BI reports, you should discuss the licencing implications with your Oracle account manager.


Posted by Steven Chan on February 09, 2012 at 10:31 AM PST #

Hi Steven -

Looking for information regarding certification of Discoverer with database 12c.



Posted by Chuck Seibert on October 05, 2013 at 10:41 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« June 2016