REP-300: Not A GROUP BY Expression On Oracle Database 12.2
(Doc ID 2551269.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Reports Developer - Version 11.1.2.2.0 and laterOracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Symptoms
On : 11.1.2.2.0 version, Oracle Reports
When executing the Oracle Report (11.1.2.2.0) RDF file on Oracle WLS 11g Release 1 (11.1.1.5) Linux to Oracle Database 12.2, the code of a large number of reports in the query with GROUP BY returns the following error message:
REP-300: not a GROUP BY expression ORA-00979; not a GROUP BY expression
-- Error(s)
REP-300: not a GROUP BY expression
ORA-00979: not a GROUP BY expression
ORA-00979: not a GROUP BY expression
-- What Works
These reports work correctly on Oracle AS version 9.0.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 |