Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide

Skip Headers

Contents

Administer EBS and Endeca Data

Pre-Requisites

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

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).
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.

In Oracle E-Business Suite, set the profile option FND_ENDECA_CLOVER_URL to http://<endeca_hostname>:7006/clover.
Run the script 'storeCloverLoginInFndVault.sh' 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.
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.
The 'EBS-Endeca Administrator' responsibility provides the following menu options for the 'Run ETL graphs' concurrent program:
- Submit Requests
  
  Clicking 'Submit Requests' enables users to launch a concurrent request. After selecting 'Single Request' and clicking 'OK', the submit request form displays. After selecting 'Run Clover ETL Graphs' into the Name field, users are prompted to specify the application 'Sandbox' (e.g. eam or icx-iproc) and the 'Graph Type' (Full.grf or Incremental.grf). Users can submit requests to run immediately by clicking 'Submit'. After submitting a request, the status of this request can be tracked using the 'View Requests' and 'Monitor' menu options.
- Schedule
  
  Clicking 'Schedule' allows users to schedule one or more requests to launch the concurrent program 'Run Clover ETL Graphs'. Users are prompted to specify the application 'Sandbox' (e.g. eam or icx-iproc) and the 'Graph Type' (Full.grf or Incremental.grf). Users can submit the request to run immediately by clicking 'Submit' or can specify additional concurrent request options by navigating through the options pages after clicking 'Next'. After submitting a request, the status of this request can be tracked using the 'View Requests' and 'Monitor' menu options.
- Monitor
  
  This menu option allows users to access the list of concurrent requests that they have submitted in the Oracle E-Business Suite. By default 'All My Requests' displays requests submitted within the last seven days. You can modify the query criteria by clicking the 'Advanced Search' button to specify requests to display. Users can click the 'Details' icon and then the 'View Log' button to view the concurrent request log file for the submitted concurrent request.
- View Requests
  
  Clicking 'View Requests' launches the View Requests form in the Oracle E-Business Suite. This enables users to search for a specific request or all of their concurrent requests. Clicking 'View Log' displays the log file for that concurrent request.
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

Navigate to Endeca Studio (see your System Administrator to obtain the Endeca Studio URL, user id, and password).
Login as Studio Admin (admin@oracle.com). The default password is welcome123.
Go to the Control Panel.
Click the Users link.
Click on EBS User Name.
Click on the Roles link.
Click Select Link.
Select the Administrator Role.
Click the Save button.