Oracle EBS Endeca Extension - Error encounter in new Installation

If integration is not done properly below are the list of possible errors which you might encounter :

1.     Endeca Menus are not enable:

Error Message/Description:

Endeca related menus are not available/ visible in EBS application.

Cause:

Required roles are not assigned to responsibility and grant are not given to the role to view Endeca pages.

Solution:

Add roles to responsibilities and provide grants as well. Refer oracle note id Doc ID 1614014.1 -> APPENDIX B: adding roles to responsibilities and setting security.

2.     Profile option FND_ENDECA_INTEGRATOR_URL is not defined:

Error Message /Description:

When we run concurrent program from EBS it got error out saying Profile value is not set for FND_ENDECA_INTEGRATOR_URL.

Cause:

Profile option is not set.

Solution:

Set value: Clover URL.

3.     Concurrent Program Completed with Error :

Error Message/Description:

Server returned HTTP response code: 401 for URL:

Cause:

Not able to ping URL from EBS.

Solution:

 Validate clover login credential stored in FND vault.

SQL to validate credential in FND vault:

select fnd_vault.get ('endeca_integrator_admin','clover_userName') from dual;

                select fnd_vault.get ('endeca_integrator_admin','clover_password')  from dual;

(Note: If there is no data in above sql queries then you have to run script to store clover credential in FND vault. For more information please refer Document ID: 1470151.1 )

        

       4.         Graphs are Finished but no Data in EBS Endeca pages:

                         Error Message/Description :

 Unable to execute the EQL query that generates the chart data. See the application log for details, or contact a system administrator.

Cause:

Configuration issue.

Solution:

Validate EidConfig.properties , portal-ext.properties and Studio.log and confirm each values mention to build EBS – Endeca integration.

Check value for FND_SESSION_MANAGEMENT using below Sql query value is case sensitive.

Select FND_SESSION_MANAGEMENT.getsessioncookiename() from dual .

Verify same in portal-ext.properties and eidconfig.properties file if any discrepancy found update value and bounces studio manager.

File location:

/u01/Oracle/quickInstall/EidConfig.properties

/u01/Oracle/Middleware/user_projects/domains/portal-ext.properties.

5.     Clover graph fail to load data for sandbox: AP

Error Message/Description:

                Clover graph failed to load data for AP.

Cause:

Endeca Aging Template not set to any templatei.e “AP: Endeca Aging Template”.

Solution:

Perform Setup for Template and set profile option value “ AP: Endeca Aging Template”