15 OracleBI Discoverer and Oracle e-Business Suite

Note: This chapter only applies to Discoverer Plus and Discoverer Viewer. For more information about configuring Discoverer Plus OLAP, see Chapter 6, "Configuring the Discoverer Catalog and Discoverer Plus OLAP".

This chapter explains how OracleBI Discoverer provides capabilities for integrating with Oracle e-Business Suite, and contains the following topics:

• Section 15.1, "About Discoverer connections and Oracle e-Business Suite"

• Section 15.2, "About Discoverer preference settings for Oracle e-Business Suite"

Note: For information about Discoverer and Oracle e-Business Suite certification, see Section D.1.2, "Discoverer and Oracle Applications certification".

15.1 About Discoverer connections and Oracle e-Business Suite

Discoverer is configured for a mixed application environment (i.e. where some users use Oracle e-Business Suite and some do not). In other words, in Connect To field on the login page (or Discoverer connection page), end users can select OracleBI Discoverer, Oracle e-Business Suite, or OracleBI Discoverer for OLAP (see screenshot below).

Figure 15-1 Discoverer login page with Connect To options displayed

Description of the illustration app1.gif

When an end user logs in as an Oracle e-Business Suite user, Discoverer prompts them to specify an Applications Responsibility (see figure below).

Figure 15-2 Specifying an Oracle e-Business Suite Responsibility in Discoverer

Description of the illustration app11.gif

Notes

• You cannot use Discoverer Plus OLAP with Oracle e-Business Suite security.

• For more information about Database Connection (DBC) files, see Oracle e-Business Suite System Administrator's Guide.

• You can also create public Oracle e-Business Suite connections using Application Server Control. For more information, refer to Section 4.6, "How to create public connections" or Oracle Application Server Control Help.

• A default Oracle e-Business Suite Gateway User ID (GWYUID), password, and Foundation Name (FNDNAM) is specified in the pref.txt configuration file (for more information, see Section 15.2, "About Discoverer preference settings for Oracle e-Business Suite").

15.2 About Discoverer preference settings for Oracle e-Business Suite

When you deploy Discoverer in an Oracle e-Business Suite environment, there are two preference settings that you can override in the pref.txt file:

• the AppsGWYUID preference specifies a Gateway User ID and Password (the default value is 'APPLSYSPUB/PUB')

• the AppsFNDNAM preference specifies a Foundation Name (the default value is 'APPS')

AppsGWYUID and AppsFNDNAM are the specified in the pref.txt configuration file (for more information, see Section A.1, "List of Discoverer file locations").

Note: After editing the pref.txt file, you must run the applypreferences script to apply the preference changes you have made, then stop and restart the OracleBI Discoverer service (for more information, see Section 5.3, "About starting and stopping the Discoverer Service").