Skip Headers
Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B40107-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

14 Oracle BI Discoverer and Oracle e-Business Suite

This chapter only applies to Discoverer Plus Relational and Discoverer Viewer. For more information about configuring Discoverer Plus OLAP, see Chapter 5, "Configuring Discoverer Plus OLAP".

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

For information about Discoverer and Oracle e-Business Suite certification, see Section E.3, "Discoverer and Oracle Applications certification".

Note: The terms Oracle Applications and Oracle e-Business Suite are used interchangeably in this chapter.

14.1 About Discoverer connections and Oracle e-Business Suite

Discoverer end users can connect to an Oracle Applications database using their Oracle e-Business Suite user ID and responsibility. End users can select an existing connection (that is, a stored set of database login details) or connect to Discoverer directly. For more information about connecting to Discoverer using an existing connection, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus.

Oracle e-Business Suite users can connect to Discoverer directly by selecting Oracle Applications from the Connect To drop down list in the Connect Directly area on the Connect to Discoverer page.

Figure 14-1 Discoverer Connect Directly area showing Oracle Applications selected using the Connect To drop down list

Description of Figure 14-1 follows
Description of "Figure 14-1 Discoverer Connect Directly area showing Oracle Applications selected using the Connect To drop down list "

When an end user connects as an Oracle e-Business Suite user (by selecting the Oracle Applications option from the Connect To drop down list), if the end user has more than one Oracle Applications Responsibility, Discoverer prompts them to specify an Applications Responsibility (for example, System Administrator).

Notes

14.2 About Discoverer private connections, Oracle Single Sign-On and Oracle e-Business Suite users

Oracle e-Business Suite (Oracle Applications) users that are associated with an Oracle Single Sign-On (SSO) user, can create and use Discoverer private connections without entering a password.

This section contains the following topics:

14.2.1 About conditions for enabling Oracle Applications users to create or use private connections when using SSO-enabled Oracle Applications databases?

Oracle Applications users can create or use private connections to Discoverer using Oracle Single Sign-On, when all of the following conditions are true:

  • Oracle Applications users must use Discoverer Version 10.1.2.1 (or later)

  • Oracle Single Sign-On must be installed and enabled for Discoverer

    For more information, see Section 13.8.1, "Using Discoverer with Oracle Single Sign-On".

  • Oracle Single Sign-On connections must be enabled for Oracle Applications users in Oracle Fusion Middleware Control (FMW)

    To enable Oracle Single Sign-On connections, select the Allow authenticated Oracle Single Sign-On users to create and use private connections to Oracle Single Sign-On-enabled Oracle Applications databases, without entering a password check box on the Discoverer Administration page in Oracle Fusion Middleware Control.

    For more information about how to enable connections to Oracle Single Sign-On-enabled Oracle Applications databases for Oracle Applications users in this Discoverer installation, see Section 14.2.2, "How to enable Oracle Applications users to create or use private connections to SSO-enabled Oracle Applications databases".

  • Discoverer must be running against an Oracle Single Sign-On-enabled Oracle Applications database

  • Oracle Applications users must be associated with an Oracle Single Sign-On user

    When you create or use private connections using Oracle Single Sign-On, you select an Oracle Applications user that is associated with an Oracle Single Sign-On user, and you are not prompted for password information.

14.2.2 How to enable Oracle Applications users to create or use private connections to SSO-enabled Oracle Applications databases

Oracle Applications users normally enter a password when creating or using private connections. However, Oracle Applications users that are associated with an Oracle Single Sign-On user can create and use Discoverer private connections without entering a password, when using an Oracle Single Sign-On-enabled Oracle Applications database.

To enable Oracle Applications users to create or use private connections to Oracle Single Sign-On-enabled Oracle Applications databases:

  1. Display the Fusion Middleware Control Discoverer Home page (for more information, see Section 4.1.3, "How to display the Fusion Middleware Control Discoverer Home page and Discoverer component Home pages").

  2. Select Administration from the Discoverer menu to display the Discoverer Administration page.

  3. Use the Allow authenticated Oracle Single Sign-On users to create and use private connections to Oracle Single Sign-On-enabled Oracle Applications databases, without entering a password check box to specify whether Oracle Single Sign-On is enabled for the Discoverer installation, as follows:

    • Select the check box to enable Oracle Applications users (that are associated with an Oracle Single Sign-On user to create and use private connections without entering a password (when using an Oracle Single Sign-On-enabled Oracle Applications database).

    • Clear the check box to disable Oracle Applications users (that are associated with an Oracle Single Sign-On user from creating and using private connections without entering a password (when using an Oracle Single Sign-On-enabled Oracle Applications database).

  4. Click Apply to save the details.

14.3 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:

AppsGWYUID and AppsFNDNAM are specified in the pref.txt configuration file (for more information, see Section A.1, "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 Oracle BI Discoverer service (for more information, see Section 4.3, "How to start, stop, and restart the Discoverer preferences server component using opmnctl").