ORA-00904 WHEN TRYING TO OPEN AN WORKSHEET FOR AN USER THAT HAS FILTERS
(Doc ID 2832264.1)
Last updated on AUGUST 17, 2022
Applies to:
Oracle Demantra Predictive Trade Planning - Version 12.2.5.1 and laterInformation 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 |