Skip Headers

Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide
Release 12.1 V5
Part Number E37993-08
Go to Table of Contents
Go to previous page
Go to next page

Implementation and Integration

Administer EBS and Endeca Data


Ensure you comply with following pre-requisites before you proceed with the rest of the integration steps:

  1. Installed and completed common configuration as described in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 (Doc ID: 1683053.1).

  2. Installed additional patches required for Oracle Projects Extensions for Oracle Endeca as described in Oracle Projects Extensions for Oracle Endeca Product Configuration Notes Document ID: 1470151.1

Filtering Components in Oracle Endeca

Oracle E-Business Suite Extensions for Oracle Endeca provide you various filtering options to enable you to filter and search for data. These filtering components are:

Search Box - Power users can configure the search to determine the data source, how to determine a matching record, and whether to support type-ahead. End users can use the search box to enter keyword to conduct a search. If multiple search configurations are available, end users can first select the search configuration that they want to use. The Search Within check box enables a search limited to the currently displayed data.

Guided Navigation - use this component to use attribute values to filter data. End users can select values in order to refine the current data to only include records with those values. For some attributes, end users can select multiple values. They also may be able to do negative refinement, to only include records that do not have a selected value.

Concurrent ETL Graphs

To enable concurrent ETL graphs

You must enable Oracle Endeca ETL graphs to be run from the Oracle E-Business Suite as a concurrent request.

  1. In Oracle E-Business Suite, set the profile option FND_ENDECA_CLOVER_URL to http://<endeca_hostname>:7006/clover.

  2. Run the script '' to add Clover login credentials in EBS Fnd Vault. The path is /u01/Oracle/quickInstall/bin/ in Build-12 QI of 12.1 V5.

    Note: The script automates the creation of the Clover login credentials process and prompts you to provide an EBS DB apps schema password, clover application user name and password. When you enter the values, the script connects to the EBS database using apps credentials, and stores the clover application login credentials in EBS FND_VAULT.

  3. The responsibility 'EBS-Endeca Administrator' allows an Oracle E-Business Suite user to access the concurrent program 'Run ETL graphs'. This provides the ability to run Full or Incremental graphs for a specified application sandbox. The system administrator can add this responsibility to any Oracle E-Business Suite user.

  4. The 'EBS-Endeca Administrator' responsibility provides the following menu options for the 'Run ETL graphs' concurrent program:

    Note: If the concurrent request for a longer running Full Load Graph displays as 'Completed, Error', then you can access the log file to determine the Run ID in Clover and the URL for the clover UI, and access the 'Executions History' through the Clover UI.

Assigning Administrator Role to E-Business Suite Users

Assigning Administrator Role to E-Business Users

Oracle E-Business Suite users do not have the Endeca Studio Administrator role assigned by default and therefore cannot modify Endeca Pages. If you have a requirement to allow E-Business Suite users to modify Endeca pages, then you must assign the Administrator role to the users.

To assign Administrator role to E-Business Suite users

  1. Navigate to Endeca Studio (see your System Administrator to obtain the Endeca Studio URL, user id, and password).

  2. Login as Studio Admin ( The default password is welcome123.

  3. Go to the Control Panel.

  4. Click the Users link.

  5. Click on EBS User Name.

  6. Click on the Roles link.

  7. Click Select Link.

  8. Select the Administrator Role.

  9. Click the Save button.

The E-Business Suite user should now have administrator privileges and access to Endeca pages.