My Oracle Support Banner

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 and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


On : version, Oracle Reports

When executing the Oracle Report ( RDF file on Oracle WLS 11g Release 1 ( 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

-- What Works
These reports work correctly on Oracle AS version 9.0.4


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.