In-Depth: Using Discoverer 10g with the E-Business Suite Release 11i

[Oct 9, 2007:  Discoverer 10g is the latest version certified for both E-Business Suite Release 11i and 12.  See this certification announcement for full details.]

Oracle Discoverer is one of our most popular Oracle Business Intelligence tools for the E-Business Suite.  With a relatively small amount of training, it allows end-users to create Excel-like workbooks that answer business questions like, "How did sales of our Ultimate Titanium Turnip Twiddler improve over last year for the western region?"

Discoverer 10 Screenshot:

Discoverer Architectures in a Nutshell

Discoverer is installed on a physically-standalone server or in a new ORACLE_HOME on an existing E-Business Suite Oracle9i Application Server application server.

Discoverer 10g Architecture:

A prepackaged Discoverer End-User Layer for the E-Business Suite is installed in the E-Business Suite database.  This End-User Layer is a metadata repository contains business views that expose meaningful business concepts to end-users, shielding them from the complexity of the E-Business Suite data model.

Discoverer workbooks provide users with graphical and tabular analytic options to analyze existing data to make business decisions.

Summary of Discoverer Components
  • Power users use Discoverer Plus or Discoverer Desktop to create new workbooks
  • Regular business analysts use the browser-based Discoverer Viewer to analyze data
  • Casual end-users monitor business data via workbooks displayed in Discoverer Portlets in Oracle Portal
  • System administrators use the Windows-based Discoverer Administrator to manage the Discoverer End-User Layer
What's Wrong with Discoverer 4i?

Until recently, E-Business Suite users were restricted to using Discoverer 4i.  While still usable and useful, Apps DBAs know that Discoverer 4i has three major drawbacks:
  1. Discoverer 4i will be desupported in October, 2006
  2. Discoverer 4i can create heavy loads on your middle-tier and database
  3. It's elderly -- your users really want Discoverer 10g instead
Upgrading to Discoverer 10g

You can address all three of those drawbacks now:  Discoverer 10g is the latest release available, is easier to manage, and has a significantly smaller application-tier and database-tier operational profile than previous releases.

We certified Discoverer 10g ( with the E-Business Suite last year.  Although procrastination is often an effective workload management technique, there's no reason to postpone your installation or upgrade any longer:  this is a very worthwhile upgrade.

Discoverer 10g is also one of the easiest components in Oracle Application Server OracleAS 10g to install with the E-Business Suite.  The process is straightforward:
  1. Install Discoverer 10g on a physically standalone server from your existing Discoverer 4i server

  2. Run the Discoverer 10g eulapi utility with the -AUTO_UPGRADE parameter.  This creates a copy of your existing Discoverer 4i, and then upgrades the copy to the Discoverer 10g End-User Layer format.  Your original Discoverer 4i End-User Layer remains untouched. 
Minimal User Acceptance Testing Needed

If you installed Discoverer 10g on a standalone server, you can run Discoverer 4i and 10g simultaneously.  This means that your end-users can compare their Discoverer 4i and 10g workbooks side-by-side. 

User acceptance testing for your upgrade should take no time at all... and it's possible that your end-users may even be able to use your upgrade to justify that beautiful 21" LCD monitor to support this effort.  It's nice to make new friends, isn't it?

Optional Integration with Oracle Single Sign-On & Oracle Internet Directory 10g

Discoverer 10g can be installed in two different modes:

  1. The first and easiest method is to install it independently of Oracle Single Sign-On and Oracle Internet Directory 10g.  The advantage to this is that you can be running with Discoverer 10g extremely quickly, with minimal changes to your E-Business Suite environment.
  2. The second method requires your E-Business Suite environment to be integrated with OracleAS 10g and Single Sign-On first.  This admittedly takes more effort, but has the additional advantage of allowing Discoverer and the E-Business Suite to be integrated with third-party LDAP and single sign-on solutions.

Integration with Oracle Portal

If you go to the extra effort of integrating your E-Business Suite environment with OracleAS 10g and Portal, your end-users will be able to publish their workbooks and create executive dashboards like this:

Discoverer 10g Portlets Dashboard:

Getting a Lexus For Free

I'm not a licencing professional, but my understanding is that Discoverer maintenance fees cover the latest versions... for free.  In other words, if you're licenced for Financials Intelligence or any other E-Business Suite Business Intelligence product, you should be able to upgrade to Discoverer 10g with no extra costs.

If that applies to you, then this is equivalent to being able to trade in your rusty Toyota Accord for a free new Lexus. 

If you don't know what your licencing terms are, I'd recommend that you contact your Oracle account manager for more information.

Good luck with your upgrade.

Related Articles:


Question in the context of integration of OEBS with "Oracle Application Server OracleAS 10g R2" and autoconfig.
What are the planes for Oracle AS 10G R2 configuration management.
AS have got it own DCM tool.
Are you going to integrate AutoConfig with DCM?
Can you please connemt on that question?

Posted by Yury Velikanov on May 07, 2006 at 11:51 PM PDT #

Yury,We're looking at the relationship between AutoConfig and DCM for both Release 12 and Fusion.  Most of these plans are still under wraps right now, but I'll post updates as soon as they're cleared for public consumption.Regards,Steven

Posted by Steven Chan on May 08, 2006 at 03:52 AM PDT #

Hi Steven,
I was interested in your comment about Discoverer and the Business Intelligence Products. Do you know if this works the other way? For example, if I am currently licensed for Discoverer can I enable the intelligence business views and use the Discoverer EUL?


Posted by Mark on July 11, 2006 at 08:31 AM PDT #

Mark, As far as I know, it doesn't work the other way.  Even if you have a Discoverer licence, you must obtain BIS licences before using the Apps BIS (Business Intelligence System) products such as Financials Intelligence.That said, I'm not a licencing professional, and these areas can be byzantine.  If there's any doubt in your mind about what you can use, I know that your friendly neighbourhood Oracle account manager would be delighted to help.  ;-)Regards,Steven 

Posted by Steven Chan on July 11, 2006 at 08:31 AM PDT #

Hi Steve,

Quick question on the subject of Discoverer on 10g with the E-Business suite. I we stick it on a seperate server with 10g infrastruture and looks like we may do a bit of SSO as well there do we have to licence that server at $30k a processor as well.

I was under the impression apps server costs were not charged on top of financials licencing is this not the case??

Thanks for your assistance your blog is a great site.

Posted by Doug Murphy on December 08, 2006 at 01:15 AM PST #

Hi, Doug,In general, if you've licenced an E-Business Suite product that uses Discoverer 10g (e.g. a Business Intelligence product such as Financials Intelligence), that should include the Discoverer 10g licence.In general, if you wish to use Single Sign-On 10g (and Oracle Internet Directory 10g), that will require additional licencing.That said, I'm not a licencing professional and contracts for your specific company may have special options for things like Oracle Application Server 10g usage.  So, the safest way of getting a definitive answer to your question is to ask your Oracle account manager to look into this for you.Thanks for the feedback on our blog; glad to hear that you're finding it useful.Regards,Steven 

Posted by Steven Chan on December 08, 2006 at 09:22 AM PST #

Is there any further documentation on the EUL and/or report content for 11.5.10, Discoverer 10.1.2? I'm implementing some reporting for HR and would like to analyse whether I can use the seeded HR EUL and reports, but am finding it difficult to find the correct level of detail to do this.
The EUL looks like it now has 'analytics' business areas - are these new in a later release? Do they need and further set-up that I should be aware of?
Many thanks, Kate

Posted by Kate Aubon on August 18, 2008 at 09:26 PM PDT #

Hi, Kate,

Although I used to own the central Business Intelligence core services almost a decade ago, I no longer consider myself a BI authority. As far as I'm aware, the most up-to-date description of the End-User Layer workbooks and content is still contained within the various "____ Intelligence" manuals (e.g. "Customer Intelligence", "Sales Intelligence") available here:

I hadn't heard of any new analytics content being introduced into the preseeded Discoverer End-User Layer, let alone for HRMS. Perhaps the best way of getting an authoritative answer would be for you to log a formal Service Request against the appropriate Intelligence product team -- e.g. HRMS -- to get one of the functional specialists engaged.

Good luck with this one.


Posted by Steven Chan on August 19, 2008 at 08:51 AM PDT #

Hi Steve, I have a question about the Discoverer upgrade.

Do we need to upgrade to discoverer 10 g viewer and plus edition ? or we can continue to use Cilent version of the Desktop edition of discoverer ?

Any power point slides link which cover Discoverer upgrade will help.

Posted by Harish Gulati on August 17, 2009 at 10:11 AM PDT #

Hi, Harish,

Note 313418.1 states:
The OracleAS Infrastructure might be on the same machine as the Business Intelligence and Forms type installation or on a different machine. This installation type includes Discoverer Server 10g, Discoverer Plus 10g, and Discoverer Viewer 10g.

If you have any difficulty with your Discoverer upgrade, your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our Discoverer specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.


Posted by Steven Chan on August 19, 2009 at 04:37 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016