Poscc Error Attempting To Apply Security Filters - Failed To Parse EQL Query, Syntax Error

(Doc ID 2330690.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.4 version, Installation
When attempting to check Purchasing Data Discovery,
the following error occurs.

ERROR
-----------------------
An error occurred while attempting to apply security filters.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing Data Discovery > procurement operations > procurement
operations dashboard
2. system shows error:
An error occurred while attempting to apply security filters.
3. Check studio.log, see information below:
com.endeca.portal.lql.LQLException: Failed to parse EQL query: Syntax error,
unexpected Symbol

Also, see information below:
Return expression: (( not (org_id = 101 or org_id = 43876 or
org_id60213......AND ()
--seems issue possible caused by there is no condition in 'AND ()'

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot check Purchasing Data Discovery > procurement
operations > procurement operations dashboard without error message.

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