My Oracle Support Banner

ORA-00904 WHEN TRYING TO OPEN AN WORKSHEET FOR AN USER THAT HAS FILTERS (Doc ID 2832264.1)

Last updated on JANUARY 06, 2022

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5.1 version, 


When attempting to open an worksheet as an user that has filters for a location level,
the following error occurs.

ERROR
-----------------------
ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR appserver.error: null com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLSyntaxErrorException: ORA-00904: "T_EP_E1_CUST_CAT_4"."T_EP_E1_CUST_CAT_4_EP_ID": invalid identifier at

Workaround
-----------------------
Worksheet is opening fine after removing the filters for the user.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench with an user that has filters
2. Try to open an worksheet
3. Does not return data

 

Note:
------

ORA-00904 can occur for other levels ID's, not only for T_EP_E1_CUST_CAT_4 .

 

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.