Apps To Fusion

In this article, Pramod walks you through all the required steps from Installing Discoverer, to setting up End User Layer and logging in as Apps User to discoverer.
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)