Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Discoverer in Oracle Applications
    Sunday, November 05, 2006
    Register for R12 upgrade
    One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of putting some bits and pieces for you on Discoverer and later on How to Integrate Discoverer 10g with Oracle Apps 11i. So lets start this discussion about overview & things you should know about Discoverer as Apps DBA.

    Whats is Discoverer Server ?
    Discoverer is and ad hoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)

    What should I know about Discoverer as an Apps DBA ?
    Though each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.

    What is EUL ?
    You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.

    Technical things about discoverer in Apps ..
    --In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4
    --Script to start discoverer server is under $OAD_TOP/admin/scripts/$CONTEXT_NAME
    -- This script in turn start discoverer processes which can be start by under $ORACLE_HOME/discwb4/util (This script is different from
    -- calls scripts like, ,, to start gatekeeper, locator, oad & osagent resp.
    -- In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)

    Quiz to reader :
    A. How will you find discoverer version in Apps ?
    B. What URL you use to access Disco viewer & Disco plus .

    Post your answers via comments

    Stay tuned to check
    How to install 10g Discoverer & configure with Oracle Applications 11i
    Coming Soon .....

    *************Important Note*************
    Now you can subscribe Email Notification For New Post on this Site
    --Check on right Menu Bar of Page under E-mail Subscription enter your email ID
    --click on "subscribe".
    --It will open new window to verify (If pop up blocker is enabled , allow for this session)
    --You have to type text message displayed on pop up window
    --"click on complete subscription".
    Final step is to Verify in your mail box that you only asked for Subscription.
    Go to your inbox , you should see a mail with Subject "Activate your Email Subscription to:.. "Open that mail &
    click on link in mail
    If you don't see this mail in your inbox then check your Junk eMail Folder
    Click on this link
    Relax & you will get notification in your mail box as soon I post new Topic here .

    Labels: , ,

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 2:00 AM  
    • At 10:36 PM, Anonymous Anonymous said…

      for viewer it is


    • At 4:29 AM, Anonymous Anonymous said…





      $ string –a dis4pr | grep –i ‘discoverer version’

    • At 4:31 AM, Anonymous Anonymous said…





      Goto $ORACLE_HOME/Discwb4

      $ string –a dis4pr | grep –i ‘discoverer version’


    • At 7:53 AM, Blogger Atul Kumar said…

      Thanks a lot for comments,

      Second answer is correct one .





      $ string –a dis4pr | grep –i ‘discoverer version’

      Please mention your name if possible for your feedback & answers

    • At 3:20 PM, Anonymous santosh said…

      hi atul
      I want to use the discoverer4i in my existing apps. So after starting the discoverer server does it have a default user and password provided by oracle to access for the first time.

    • At 3:23 PM, Blogger Atul Kumar said…

      Hi Santosh,
      You can use sysadmin or apps user to access dscoverer .

      Ask Discoverre Functioanl analyst to grant EUL access to any other Application users which you created later .


    • At 7:48 AM, Anonymous Anonymous said…

      Please tell me what is the URL if i have to access Oracle 10g.

    • At 8:05 AM, Blogger Atul Kumar said…

      Hi Anonymous,
      We are going to cover this in my coming post on how to configure Apps with Discoverer 10g


    • At 1:45 PM, Blogger Mudasir Waraich said…

      Hi Atul,
      When should we expect your upcoming post on this. As I would be really interested to read.

    • At 3:18 PM, Blogger Atul Kumar said…

      Its now available at


    • At 11:31 AM, Anonymous Anonymous said…

      Just wanted to share the below

      The location for looking for dis4pr is $ORACLE_HOME/diswb4/bin

      where ORACLE_HOME -> 8.0.6. Oracle Home

    • At 4:43 AM, Anonymous Anonymous said…

      Thanks for information. I would like to ask that we have oracle discoverer 4.1.37 version, so how to upgrade to I heard that there is a patch for this, would you elaborate more on this.


    • At 10:22 AM, Anonymous Anonymous said…

      hi atul
      how to configure workflow and Discoverer,

      i mean , my discoverer reports to schebuled based on events

    • At 10:38 AM, Blogger Atul Kumar said…

      You mean you want to configure Disco & workflow with apps or any other thing ?

      If this is 11.5.9 and higher disco & WF are already integrated with Apps

    • At 10:39 AM, Blogger Atul Kumar said…

      Do you wish to upgrade it to 4.1.37 (This is obsolete & desupported now) I would suggest you to configure 10g Disco with Apps which I am going to cover in a day or two by 18 Feb 07 in this blog

    • At 5:59 AM, Anonymous Anonymous said…

      Hi Atul,
      I have created EUL using Discoverer 10g Administrator, but my server side is running 9i AS can I still use Discoverer Plus/Viewer to show reports based on 10g EUL?

      Thanks Anand

    • At 1:59 PM, Blogger Atul Kumar said…

      Your Discoverer Desktop Admin version is 10g and EUL on server is 9i. As soon as you try to connect to 9i Server it will display message that You are using old version of EUL kindly upgrade & it will upgrade EUL on server to 10g

    • At 11:21 PM, Anonymous Anonymous said…

      .HI Atul

      Can you tell me about the Single Sign on facility with Orale Discoverer 4i and Oracle APPS release 11i (11.5.10)

      How I am gonna setup SSO (Single Sign on to Discoverer Plus From ORacle APPS 11i)

    • At 11:27 PM, Blogger Atul Kumar said…

      Hi anonymous, for configuring sso with any oracle apps component only certified way is to use sso server which comes with 10g AS . so Install 10g AS & use 10g AS for & sso with 10g AS in apps .

      Another option is to use 10g Disco itself (install 10g AS with disco option) follow metalink note # 313418.1 Using Discoverer 10.1.2 with Oracle E-Business Suite 11i when you install 10g disco install infra first (sso & oid) and then install disco middle tier & configure disco 10g with apps

    • At 9:12 AM, Anonymous Anonymous said…

      could you please explain more about discoverer like why do we use it? if its for reporting, we have CM and reports server for such functionality...why use disco then???also what do you mean by analysis??

    • At 11:56 AM, Blogger Atul Kumar said…

      Hi Anonymous,
      Discoverer is for Business Intelligence reporting .

      These are more complex reports & mainly targeted for OLAP kind of reports . Soon you might see discoverer being replaced by BIEE (Business Intelligence Enterprise Edition) build on siebel analytics

    • At 4:39 AM, Blogger Kriz said…

      Hi Atul,
      Thanks for the great info.
      I have a query.
      Iam using Disc 10 on Apps 10 and access Disc Viewer via a URL call from Custom form.
      I have created Disc reports using LOGIN_A and granted access to some users.
      But if there is a any session issue in Viewer it is still asking the LOGIN_A's pwd even though I logged in using one of the granted user name.
      Please help;

    • At 5:52 AM, Blogger Atul Kumar said…

      Hi Kriz,
      Are you talking about application server 10g or applications 11i ?

      Raise any questions/issues at

    • At 5:43 PM, Blogger sarilla said…


      how to integrate OLAP Report with Oracle application in

    • At 5:48 PM, Blogger sarilla said…


      How to integrate OLAP report with Oracle applications

    • At 10:54 AM, Anonymous Anonymous said…

      This is Krishna, will you please tell me how we register the discoverer reports. i have followed the process but it is giving some errors.


    • At 10:50 AM, Anonymous Anonymous said…

      How to connect to discoverer viewer in Release 12?

    • At 10:51 AM, Anonymous Anonymous said…

      what abt release 12

    • At 7:58 PM, Blogger Atul Kumar said…

      Use http://hostname.domainname:http_port/discoverer/viewer

    • At 6:17 PM, Anonymous Anonymous said…

      How i will configure oracle discoverer 1og with oracle apps 12i. how oracle user will be permitted to access the responsibility

    • At 7:25 PM, Anonymous Anonymous said…

      I everyone,

      I would like to know how to get à paper shema of the table relation created by the sysadmin in Discoverer.

      Is there a tool that do it ?

    • At 4:52 PM, Anonymous Anonymous said…

      good see a lot of info exchanging between u guys on discoverer which i wasnt even aware of

    • At 6:56 AM, Blogger krishna said…


      First of all thanks for sharing the such a useful information across the blog.

      I would like to know the Whether we can install on linux x86 that is 11i instaces server, is yes where i will get the Discoverer 10g on linux Software.

      Thanks in advance
      Krishna Kumari

    • At 7:05 AM, Blogger Atul Kumar said…

      We have moved to so kindly check on new site and raise your doubts there

    • At 1:13 PM, Anonymous Anonymous said…

      client is using discoverer viewer to access reports and most of the users use the same id to login to viewer edition to access the reports.

      I do know that in Viewer we’ll need to turn off anything that allows the user to save changes/preferences as what they are saving is not only for themselves, but everyone else using that ID to access the reports.

      can you tell me what attibuites we need to change in discoverer viewer Configuration file for this.

      Anuj malhotra

    • At 4:01 PM, Blogger alka said…

      Dear expert;
      I'm new to both Oracle Apps and Discover 10g; I've installed oracle application server on a linux box(as_linux_x86_bi_101202);
      I try to access to discoverer by browsing but i can go far. could some one help me with the basic

    • At 4:52 PM, Blogger alka said…

      Hi all;
      When I try to logon logon a DB, I recieve following error message:
      Attempt 1. CORBA protocol : 0 of 1 processes started. Hint: An administrator can further diagnose connection problems by running the "checkdiscoverer" script under ORACLE_HOME/discoverer/util.
      and when I run the ; I get following message:
      /home/oracle/Home/jdk/bin/java: error while loading shared libraries: cannot open shared object file: No such file or directory

      thanks for the help

    • At 6:07 AM, Anonymous Anonymous said…

      Nice blog! keep it up!
      web application

    • At 2:19 PM, Anonymous Anonymous said…

      Does anyone know about a solution for the CORBA-error described by Alka?

    • At 2:08 PM, Anonymous Anonymous said…


      When i am trying to login the Discoverer..its throwing following error..

      Authentication Failed.
      (You do not have access to any End User Layer tables)

      HOw i can give acess ??

    Post a Comment
    << Home
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar