The ORA-00907 Error Appears When Running a Report
When using an Oracle 9.2 data source, under
certain circumstances, multiple or nested join operations may fail
and produce the following error.
ORA-00907: missing right parenthesisA query that uses both a left outer join and an ON clause condition returns zero values instead of null values.