Since we have upgraded to 15.4 (and Oracle 12c), we are seeing an weird behavior with CA Data extraction tool's output. We have been using it in 14.3 (with Oracle 11g) without issues and I am sure this is not a PWP/package error but more of an implementation error with the underlying SQL, but looking for some suggestions.
Long story short, one of the data extractions are failing since the upgrade with an error : [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00979: not a GROUP BY expression.
The SQL has correct group by expression: works still fine with 14.3/Ora 11g. Does anyone have the same error with data extracts since the migration to 15.4?
We are using SaaS.
Thanks in advance for your help/input!
DSomick : here you go !