Pramod Bellamkonda is a technical Oracle Apps consultant with vast experience in OA Framework, Discoverer and other related technologies.
Feet free to get in touch with Pramod to avail his expert consulting services in US.
The steps for this article are as below. However to see these steps with screenshots, use this link to view PDF version.
Installing 10g (Client Version)
1) Right click on the zip file (as_windows_x86_bi_tools_101202)
2) Extract all to your comfortable directory on your PC’s
3) Click on the Extracted folder which has the same name (as_windows_x86_bi_tools_101202)
4) Click on the 10g set up icon and follow only the default settings.
(This installation creates a home “BIToolsHome_1” (If Default location is selected during install)
C:/oracle/BIToolsHome_1
4a) Put your TNS Names (obtain TNS Names from WVHomepage or from DBA)
NAVIGATE TO C:/oracle/BIToolsHome_1/network/Admin and put the TNS Names
5) Create a directory named “secure” in BIToolsHome_1 folder and put .dbc files in that directory
(Obtain .dbc files from DBA)
6) In “secure” directory put the .dbc files obtained from DBA
7) Right Click on My computer
a) Click on Properties TAB
b) Click on Environment Variables in ADVANCED TAB
c) Click on “NEW” Tab
d) Then create 2 new variables as shown below (User Variables)
Copy and paste the below:
FND_SECURE\secure
C:\oracle\BIToolsHome_1\secure
Copy and paste the below:
FND_TOP
C:\oracle\BIToolsHome_1\secure
After this goto Discoverer Administration Icon and click on it (do not log in) do the following (to log in as apps users this is mandatory )
Goto TOOLS>OPTIONS
applsyspub/pub
apps
Then log in to Disco administration edition
Goto FILE>CONNECT click on CONNECT
Enter Username, password and Database (Oracle Applications) and make sure the Oracle Applications User check box is checked.
After you click CONNECT it gives a LOV of Responsibilities , choose a Responsibility and click OK
Then Again Click on TOOLS > OPTIONS
Then Click on “Default EUL” tab
There might be more than one END USER LAYER here.
Now click on to DISCOVERER DESKTOP Edition icon
Goto TOOLS>OPTIONS
applsyspub/pub
apps
Then log in to Disco Desktop edition
Goto FILE> click on CONNECT TO DATABASE
Enter Username, password and Database (Oracle Applications) and make sure the Oracle Applications User check box is checked.
After you click CONNECT it gives a LOV of Responsibilities , choose a Responsibility and click OK
Then Again Click on TOOLS > OPTIONS
Use this to navigate LEFT or RIGHT to the EUL TAB (some Tabs may be hiding), Select Your EUL
So this doc provided
1) To install Discoverer 10g Admin + Desktop version
2) To Set Environment variables on your PC
3) To Use Discoverer as APPS User
4) To Set appropriate EUL (End-User Layer)
Comments
Thank you for posting an article on installing discoverer for apps.
I need some help with step 5 copy .dbc files and obtain these files from the DBA. Could you elaborate this step and tell me where exactly are the .dbc files placed so I can get these files.
Thank You.
Normally .DBC files I guess they are in $FND_TOP in the unix box.
--
Suha il
I need to configure an install package for Discoverer on a system that is used by more than one person. Is it ok to create System variables instead of User variables?
Tha nks.
i am using Discoverer 10g version (10.1.2.54.25) and Oracle Applications : 12.0.6. I have done all the environmental setup like FND_SECURE, ORACLE_HOME, i have checked my TNS entry for R12 also. and Gate way userid is Also given applsyspub/pub
the application user name i am using has sysadmin rights also.
still when trying to connect disco 10 desktop and Admin i am getting this Error - " Failed to connect to databse - Unable to connect to Oracle Application Database: Invalid Username/Passwo rd.
please help me on this...
Regard s
Dinesh Nair
It's bug in ORACLE DISCOVERER You need to install patch .. which is available on metalink ..
In case you need that patch number please send me E-mail
regards,
roch ak
I have the same problem as Dinesh Nair has been mentioned above. You suggested to apply a patch, could you please let me know the patch number, or if you could email the patch in a zip folder?
Thanks in advance.
email: apervez63hotmail.com
Reg: unable to connect to desktop invlaid useranme/passwo rd
Version: Discoverer client 10.1.2.x
Have you got the patch applied and fixed the issue you are facing.? If not, here is the direction.
Dis coverer Administrator and Desktop version is 10.1.2.48.18 are not certified with Oracle E-Business Suite Release 12.
You are required to apply the Oracle Discoverer 10.1.2.3 patchset 10.1.2.3 Patch # : 5983622
on your Discoverer Administration/ Desktop Edition home and then check.
beware: Its a quite BIG patch. :)
Please refer to the following document for the same, Note 373634.1 - Using Discoverer 10.1.2 with
Oracle E-Business Suite Release 12 5.3.2. Apply the latest certified Discoverer Administration Edition Patch.
Thanks,
Matt.
Good Day! I am facing problem in Discoverer report tool. There are some reports developed by one of our ex-collegue and those reports are not shared and the business area as well. We need to retrieve those report or get in to that business area to develop new reports.
It will be great if someone can help me.
Thank you
Sunil
when i am putting my user name , password and Database name..it returns me the same error.
can you please guide me , what steps i shall take to cross this error.
Thanks in Advance - sanjay
I have a patch for discoverer to be installed. I need to know where is it to be Installed.
In the database or in the Discoverer Client Machine?
Thank s
mrams19
This is actually awesome however that's why you consistently
crank out my pal. Wonderful messages that our company
may drain our pearly whites right into as well as truly head
to work.
I like this blog article and you know you are actually. Due to the fact that there is
so much involved however its like everything else, blogging can be actually extremely frustrating for a whole lot of folks.
Whatever requires time and all of us have the same amount of hrs
in a time so put all of them to really good make use of. Most
of us have to start somewhere as well as your plan is actually ideal.
Great portion and thanks for the mention listed here, wow ...
How trendy is that.
Off to share this blog post now, I yearn for all those brand new bloggers to view
that if they don't already possess a plan 10 they do right
now.
Here is my website; Lillie: https://www.storeboard.com/sameersuhail
RSS feed for comments to this post