My Oracle Support Banner

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

Last updated on FEBRUARY 17, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.