Integrate with Oracle E-Business Suite

Publisher can leverage your E-Business Suite security to enable your users to log in to Publisher using their E-Business Suite credentials. The Publisher security integration recognizes the user's E-Business Suite responsibility and org_id combinations.

When users log in, they're prompted to select a responsibility. Reports that users run against the E-Business Suite data tables then filter the data based on their responsibility and org_id combination. Users can switch responsibilities and reporting organization while still logged in using the My Account dialog.

When you integrate with the E-Business Suite security, your E-Business Suite responsibilities appear as roles in the Publisher security center. You can then add Publisher catalog permissions and data access privileges to the imported roles/responsibilities. See Understand Publisher Users, Roles, and Permissions.

Follow these procedures to integrate Publisher with Oracle E-Business Suite:

Note:

Users cannot access or run reports that are stored on the E-Business Suite instance. Reports must reside in the Publisher catalog. The E-Business Suite data security is enforced when Publisher connects to the E-Business Suite data tables to retrieve the report data.

Publisher relies on information stored in the DBC file to connect to the E-Business Suite instance. Ensure that you can locate and have access to this file. The DBC file is typically located under the $FND_SECURE directory.