Configure Oracle Discoverer 11g with Oracle Apps R12.x.x

Please follow below procedure to configure Oracle Discoverer 11g with Oracle E-Business Suite R12.x.x.

  1.  Download Oracle Discoverer 11g (11.1.1.7.0) from the following URL:  http://www.oracle.com/technetwork/developer-tools/discoverer/downloads/index-095113.html
  2. Extract the downloaded file.
  3. For Windows 32-bit, run “Disk1\setup.exe”.
  4. For Windows 64-bit, run “Disk1\install\win64\setup.exe”.
  5. Install the software in a new Oracle home.
  6. Configure tnsnames.ora
  7. Create a new folder “secure” in the new Oracle home.
  8. SCP/FTP the .dbc file from $FND_SECURE folder to the new folder (secure)
  9. Go to Control Panel -> System -> Advanced system settings -> Environment Variables
  10. Set two new system environment variables as follows:
    1. FND_SECURE:   C:\oracle\product\11.1.1\disc11g\secure
    2. FND_TOP:  C:\oracle\product\11.1.1\disc11g
  11. Start Discoverer Desktop.
  12. Go to Tools -> Options -> Connection.
  13. Choose “Connect to both standard and applications EULs.”
  14. Enter the applications EUL settings (Usually APPLSYSPUB/PUB and APPS).

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."