Error Occurs When Running A Workbook In Discoverer 22.214.171.124 Or Earlier "ORA-00920 Invalid Relational Operator" Error Or "ORA-00936 Missing Expression"
(Doc ID 1146155.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Discoverer - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2016***
Running a workbook in Discoverer Plus or Viewer 184.108.40.206, or earlier, results in an ORA-00920 and/or ORA-00936 error.
Running the same workbook in Discoverer Desktop client 10.1.2.X is fine.
You may have also noticed that the query generated by Discoverer has something similar to the following in the where condition, which seems to be causing the problem:
AND (SYSDATE BETWEEN (o221437.EFFECTIVE_START_DATE)(+) AND (o221437.EFFECTIVE_END_DATE)(+))
Or you may see incorrect SQL in the log file when viewed in Oracle Application Server/Enterprise Manager (EM) Console:
WHERE o106789.month + 0 = o118113.month + 0
The problem is typically occurring on workbooks that use dates in a condition (where) clause.
You may have recently upgraded Discoverer 10g to the 11g version.
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
|If you are using Discoverer 220.127.116.11 or lower, you must first upgrade to 18.104.22.168.|
|If you are using Discoverer 22.214.171.124 or 126.96.36.199:|