1.   介紹

1.1. 編寫目的

本文件用於記錄Discoverer Desktop安裝操作過程。

1.2. 文件說明

本文件包含Discoverer Desktop的安裝操作等內容。

1.3. 定義

 

1.4. 參考文件

2.   安裝Discoverer Desktop

解壓縮安裝檔案，執行setup.exe，如果提示不滿足安裝條件是否要繼續，輸入y回車：

彈出安裝介面如下：

點選“下一步”：

點選“下一步”：

點選“下一步”：

輸入安裝路徑，點選“下一步”：

點選“安裝”開始複製檔案，完成後點選“完成”退出安裝介面。

3.   配置Discoverer Desktop

進入安裝目錄下的network\admin目錄下，建立tnsnames.ora檔案，檔案內容如下：

prod =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.168.22.13)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = prod1)

    )

  )

開啟Discoverer Desktop：

點選“取消”，開啟“工具”->“選項”：

選擇“連線到標準EUL和應用產品”，點選“確定”。重新開啟Discoverer Desktop，選中Oracle應用產品使用者，“連線”處輸入“prod”，用EBS賬戶登入：

 

 

後下載11.1.3.0，切換到F:\Work\DISCOVERER\Disk1\install\win32目錄下：

 

 

 

 

 

 

 

 

 

 

 

4.    

 

The steps for this article are as below. However to see these steps with screenshots,  

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)

 

 

 

 

 

 

 

 

 

5.   參考：