Relational Operator - Set-Difference (Except/Minus) in Oracle.
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
Error at Line: 72 Column: 6
Verify that you don't have an ORDER BY clause in one of your query.