Discoverer in Oracle Applications

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 addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh)
startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh 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 .

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

50 comments
Anonymous says November 5, 2006

for viewer it is

http://hostname.domainname:port/dicswb4/viewer

Reply
Anonymous says November 6, 2006

Hi,

Plus–http://hostname.domain:port/discwb4/html/english/welcome.htm

Viewer–
http://hostname.domain/discoverer4i/viewer

Version
$ORACLE_HOME/Discwb4

$ string

Reply
Anonymous says November 6, 2006

Hi,

Viewer–
http://hostname.domain:port/discoverer4i/viewer

Plus—-
http://hostname.domain/discwb4/html/english/welcome.htm

Version:

Goto $ORACLE_HOME/Discwb4

$ string

Reply
Atul Kumar says November 6, 2006

Thanks a lot for comments,

Second answer is correct one .

i.e.

Plus–http://hostname.domain:port/discwb4/html/english/welcome.htm

Viewer–
http://hostname.domain/discoverer4i/viewer

Version
$ORACLE_HOME/Discwb4

$ string

Reply
santosh says November 6, 2006

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.

Reply
Atul Kumar says November 6, 2006

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 .

Atul

Reply
Anonymous says November 7, 2006

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

Reply
Atul Kumar says November 7, 2006

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

Atul

Reply
Mudasir Waraich says January 2, 2007

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

Reply
Atul Kumar says January 2, 2007

Mudasir,
Its now available at

http://becomeappsdba.blogspot.com/2006/11/discoverer-10g-oracle-11i.html

Atul

Reply
Anonymous says January 17, 2007

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

Reply
Anonymous says February 13, 2007

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

Arizuddin
arizudding@rcjubail.gov.sa

Reply
Anonymous says February 13, 2007

hi atul
how to configure workflow and Discoverer,

i mean , my discoverer reports to schebuled based on events

Reply
Atul Kumar says February 13, 2007

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

Reply
Atul Kumar says February 13, 2007

Arizuddin
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

Reply
Anonymous says February 19, 2007

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

Reply
Atul Kumar says February 19, 2007

Anand,
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

Reply
Anonymous says February 22, 2007

.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)

Reply
Atul Kumar says February 22, 2007

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

Reply
Anonymous says February 27, 2007

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??

Reply
Atul Kumar says February 27, 2007

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

Reply
Kriz says May 10, 2007

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;
Thanks!!

Reply
Atul Kumar says May 11, 2007

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

Raise any questions/issues at http://teachmeoracle.com/forum

Reply
sarilla says May 23, 2007

Hi,

how to integrate OLAP Report with Oracle application in 11.5.10.2

Reply
sarilla says May 23, 2007

Hi,

How to integrate OLAP report with Oracle applications 11.5.10.2

Reply
Anonymous says June 26, 2007

Hi
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.

Krishna

Reply
Anonymous says August 28, 2007

How to connect to discoverer viewer in Release 12?

Reply
Anonymous says August 28, 2007

what abt release 12

Reply
praveen kumar says January 14, 2008

Hi atul,
While performing multi-node installation with load balancing,I got these errors on node 3 while running appl tier scripts..
node 1 db tier,node 2 appltier with forms 1,node 3 with froms 2:
addisctl.sh version 115.14

/d01/apps/prodora/8.0.6/vbroker/bin/osagent
Waiting for OAD to start…
Started OAD.
OAD logs messages to the file /d01/apps/prodora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /d01/apps/prodora/8.0.6/discwb4/util/locator.log.
Cannot bind to OAD. Re-starting…

OAD is stopped
Unable to stop Osagent. No process-id file found.
Locator is stopped
Unable to stop gatekeeper. No process-id file found.
Unable to stop any Discoverer Sessions. No process-id file found.
Unable to stop any Discoverer Preference. No process-id file found.
Unable to stop any Discoverer Collector. No process-id file found.
/d01/apps/prodora/8.0.6/vbroker/bin/osagent
Waiting for OAD to start…
Started OAD.
OAD logs messages to the file /d01/apps/prodora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /d01/apps/prodora/8.0.6/discwb4/util/locator.log.
Registering Discoverer Session
oadutil reg: Failed to bind to OAD
Registering the Collector
oadutil reg: Failed to bind to OAD
Applying preferences from file : /d01/apps/prodora/8.0.6/discwb4/util/pref.txt
Finished applying preferences

Closing down registry..
Registry File sync…
Registering Discoverer Preference Repository
oadutil reg: Failed to bind to OAD

addisctl.sh: exiting with status 1

.end std out.
Failed to Start OSagent.
Failed to Start OSagent.

Plz help m..

Reply
Syed says June 8, 2008

Install Oracle Discoverer Dektop & admin Version on Clinet PC. Its Connecting R12 DB but not Showing exisitng workbook.

Already ElU there.

Envirnoment : EBS R12 on Sun Solaris Multinode Arch.

Bottom point : Want to connect exisiting EUL user through newly install Desktop Discoverer on Clinet machine.

Reply
Atul says June 9, 2008

Syed

Check these two metalink notes and they will clear most of your doubts on discoverer with R12

435529.1 Oracle Enterprise Performance Foundation R12: Installing the Discoverer End User Layer (EUL) and Assigning Appropriate Workbook Security and Privileges

373634.1 Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12

Reply
ronjubd says September 1, 2008

Hi,
After running postclone, when try to start discoverer process i am getting the bellow error and discover dose not stat. Please help.

Executing service control script:
/apps/erp/erprodcomn/admin/scripts/ERPDR_wcterpa1/addisctl.sh start
script returned:
****************************************************
ERROR : Timed out( 300000 ): Interrupted Exception

addisctl.sh version 115.15

Oracle Discoverer OAD is not running (no process with PID 13762 )

Waiting for OAD to start…
Started OAD.
OAD logs messages to the file /apps/erp/erprodora/8.0.6/discwb4/util/oad.log.
Oracle Discoverer OSAGENT is not running (no process with PID 13780)

/apps/erp/erprodora/8.0.6/vbroker/bin/osagent
Started osagent.
Osagent logs messages to the file /apps/erp/erprodora/8.0.6/discwb4/util/osagent.log.
Oracle Discoverer LOCATOR is not running (no process with PID 13795 )

Discoverer Locator Started.
Locator logs messages to the file /apps/erp/erprodora/8.0.6/discwb4/util/locator.log.
Applying preferences from file : /apps/erp/erprodora/8.0.6/discwb4/util/pref.txt

****************************************************

Reply
Atul says September 1, 2008

Check logs from below files to find reason for addisctl.sh

/apps/erp/erprodora/8.0.6/discwb4/util/oad.log

/apps/erp/erprodora/8.0.6/discwb4/util/osagent.log

/apps/erp/erprodora/8.0.6/discwb4/util/locator.log

Reply
Rajat says September 1, 2008

Hi ,

Please follow this below steps that may help you to reslove the issue
Caused by old visibroker files in directory:
806_HOME/vbroker/adm/impl_dir/
File names:
impl_rep
impl_rep~
Some of the information in these files is not compatible with the version of visibroker being used.

Resolution
1.. Go into directory
806_HOME/vbroker/adm/impl_dir
2. rename 2 files using the following:
$ mv impl_rep impl_rep_sav
$ mv impl_rep~ impl_rep~_sav
3.. Start the Discover Services using
$OAD_TOP/admin/scripts//addisctl.sh start

Reply
Rajat says September 1, 2008

@ronjubd please follow the above steps …

Reply
ronjubd says September 2, 2008

Hi,

Thanks for your support.

I check the 3 log filse mentioned above. 2 of them are empty, and the contents of locator.log is:

LogFile Name = Locator.log
Created FileWriter = Locator.log
Mon Sep 01 12:47:13 GMT 2008 Locator: Locator is created.
Name = wcterpa1.waridtel.com.bd_8001OracleDiscovererLocator4
Mon Sep 01 12:47:13 GMT 2008 Locator Instantiated: 01-Sep-08 12:47:13 PM 369ms
Mon Sep 01 12:47:13 GMT 2008 Locator: _getPreferences() bind to preference object
Mon Sep 01 12:47:13 GMT 2008 Unable to bind to or retrieve information
from preference object wcterpa1.waridtel.com.bd_800
1OracleDiscovererPreferences4
Mon Sep 01 12:47:13 GMT 2008 Locator: IOR =
IOR:000000000000001349444c3a4443494c6f63617
46f723a312e300000000000010000000000

000076000100000000000d31302e3234342e33372e3
2360000c1810000005a00504d430000000000000013
49444c3a4443494c6f6361746f723a312e30000
00000003677637465727061312e776172696474656c2e6
36f6d2e62645f383030314f7261636c65446973636f76657
265724c6f6361746f723400
locator.log: END

—————-

I have also tried the steps given by Rajat, i got this steps in Metalink also… But this steps did not work.

We are configuring Application tier in a new Unix box. Is there any OS level configuration needs to check?

Thanks
Razib

Reply
nbkonda says October 23, 2008

I got a problem, when doing the patch update for our site, we started having trouble with the discoverer.
We use the web viewer version 10.2.0.2.
When I put the patch 7353782 I somehow broke the OC4J for the web interface.
You got any idea how to fix this?

Reply
Atul Kumar says October 24, 2008

What error message you get ?
Is it while starting oc4j or accessing application deployed on OC4J ?

Reply
» Discoverer with Oracle Apps R12 Online Apps DBA: One Stop Shop for Apps DBA’s says June 17, 2009

[…] Discoverer with Oracle Apps R12 Posted in June 17th, 2009 byAtul Kumar in discoverer, r12  Print This Post Oracle Discoverer is used to analyze data (ad hoc query, analysis, reporting and publishing) from selected business area like Financials, HR, Manufacturing …  For Discoverer basics click here […]

Reply
Avadhut says June 18, 2009

Hi Atul,

While installing Business intellegence and forms , we are facing an error ”
Error:*** Alert: This Oracle Internet Directory cannot be used because it does not have Single Sign-On registered. Please either install and configure Single Sign-On for this Oracle Internet Directory or specify another Oracle Internet Directory host name. *** ”

Can you please guide us on this?

We do want SSO to be implemented.

Thanks,

Regards,
Avadhut

Reply
Atul Kumar says June 18, 2009

@Avadhut,
Are you using existing OID (as OracleAS infrastructure) ?

If this is existing OID then it seems who so ever installed , did just OID part and not SSO. (Option1 – Install SSO from same disk and when it prompts for OID/LDAP then give this OID)

or
Install new OID/SSO from 10.1.4 Identity Management CD’s (select OracleAS Infrastructure component from installer options)

Reply
Avadhut says June 18, 2009

Hi Atul,

Thanks for the reply.

We are doing fresh installation from Stage.

During Infrastructure installation ; we selected : Oracle Internet Directory as the only option [ screen : select Configuration Otions]

and it installed without errors;

but during BI installation ; we faced the above mentioned error.

As mentioned earlier ; we do not want SSO to be implemented.

Let me know whether we are going in right direction.

Thanks ,

Regards,
Avadhut

Reply
Atul Kumar says June 18, 2009

If you don’t want SSO then there is no need to install OID even (No OarcleAS Infrastructure installation is required)

Download standalone version of Discoverer check name of component and download link in this post

http://onlineappsdba.com/index.php/2009/06/17/discoverer-with-oracle-apps-r12/

Reply
Avadhut says June 18, 2009

Hi Atul !!

Thanks for the info.

viz .. I have to directly install the business intelligence part ?

Doubt : one of the screens checks for OID credentials in BI installations .. how to skip that..

I’m sorry .. if my questions seems silly to you, but i’m new to discoverer thing.

Thanks.
Regards,
Avadhut

Reply
Atul Kumar says June 18, 2009

Avadhut,
As mentioned in my previous update you have to use standalone discoverer software (not the one you are using)

Download standalone version of Discoverer check name of component and download link in this post

http://onlineappsdba.com/index.php/2009/06/17/discoverer-with-oracle-apps-r12/

Reply
Avadhut says June 18, 2009

Hi Atul,

ok. I’ll do that.

Thanks a lot for your help.

Regards,
Avadhut

Reply
gaurav says June 7, 2010

have a report when I run in Desktop I can see the data, but when I run in Plus I cannot see any data.

Reply
Paul says June 29, 2010

Hi Atul,

Thanks for your docs on Discoverer.
I have a quick question:
Where can I find the latest patches for Discoverer version 10.1.2.55.26.

Thanks for your help.

Regards.

Reply
Franna5 says January 11, 2011

Is it possible to run discoverer reports in a sh script? Will I also be able to specify where it should drop the output?

Reply
Add Your Reply