Discoverer in Oracle Applications

for viewer it is

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

Hi,

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

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

Version
$ORACLE_HOME/Discwb4

$ string

Hi,

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

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

Version:

Goto $ORACLE_HOME/Discwb4

$ string

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

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.

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

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

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

Atul

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

Mudasir,
Its now available at

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

Atul

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

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

hi atul
how to configure workflow and Discoverer,

i mean , my discoverer reports to schebuled based on events

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

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

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

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

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

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

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

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

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

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

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

Hi,

how to integrate OLAP Report with Oracle application in 11.5.10.2

Hi,

How to integrate OLAP report with Oracle applications 11.5.10.2

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

How to connect to discoverer viewer in Release 12?

what abt release 12

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

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

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.

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

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

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

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

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

@ronjubd please follow the above steps …

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

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?

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

[…] 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 […]

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

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

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

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/

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

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/

Hi Atul,

ok. I’ll do that.

Thanks a lot for your help.

Regards,
Avadhut

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

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.

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