Endeca Error Occurred While Attempting To Apply Security Filters (Doc ID 2179926.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to render ONT Endeca pages after using apps proxy account,
the following error occurs from studio.log.

ERROR
-----------------------
com.endeca.portal.data.DataSourceException: An error occurred while attempting to apply security filters
at com.endeca.portal.data.DataSource.execute(DataSource.java:731)
at com.endeca.portal.data.DataSource.execute(DataSource.java:358)
at com.endeca.portlet.resultstable.util.AbstractQueryProcessor.processLQLQuery(AbstractQueryProcessor.java:322)
at com.endeca.portlet.resultstable.util.DetailsQueryProcessor.getRecords(DetailsQueryProcessor.java:54)
Caused by: com.endeca.portal.data.security.MDEXSecurityException: Unexecpted exception in applySecurity
at oracle.apps.fnd.endeca.portal.security.extensions.EbsMDEXSecurityManager.applySecurity(EbsMDEXSecurityManager.java:264)
at com.endeca.portal.data.DataSource.execute(DataSource.java:722)
... 104 more
Caused by: java.lang.RuntimeException: invalid name pattern: ENDECA.ICX_TBL_VARCHAR240
at oracle.apps.geas.endeca.portal.security.extensions.handlers.impl.GeasontallSecurityHandler.getAccessibleContentOrgs(GeasontallSecurityHandler.java:61)
at oracle.apps.geas.endeca.portal.security.extensions.handlers.impl.GeasontallSecurityHandler.getFilterAttributeValues(GeasontallSecurityHandler.java:28)
at oracle.apps.fnd.endeca.portal.security.extensions.EbsMDEXSecurityManager.applySecurity(EbsMDEXSecurityManager.java:212)
... 105 more

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A. Responsibility Used:Order Management
B. Navigation: Endeca -> Endeca Order Management -> Open Orders
C. Issue Faced: See errors in the Information Discovery 'Open Orders' tab:
  Filters tab: A data source error has occurred
Open Orders: Metrix "This component requires additional configuration"
Open Orders: Holds "There was an error when trying to access the data source. Please confirm with your system administrator that the data source is available
Open Orders: Visualizations "Unable to execute the SQL query that generates the chart data. See the application log for details or contact a system administrator.
Open Orders Summary: An error occurred while attempting to apply the security filters.
D. Roles And Responsibility
  Order Management Endeca Access Role is Active.
E. Steps performed before issue in WebLogic Server (WLS) console
Updated data source details with user ENDECA[APPS] by replacing apps account.

All endeca pages are able to render fine except ONT pages and custom ONT pages.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms