My Oracle Support Banner

REP-300: Not A GROUP BY Expression On Oracle Database 12.2 (Doc ID 2551269.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Reports Developer - Version 11.1.2.2.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


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

Changes

 

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
Changes
Cause
Solution
References


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