My Oracle Support Banner

E-QR: PS Query Giving "ORA-00979: Not A GROUP BY Expression" Error When Using Aggregate Function and (+) Join Operator (Doc ID 2118085.1)

Last updated on JULY 27, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.55 [Release 8.4]
Information in this document applies to any platform.


When attempting to run queries that contain aggregate functions and (+) join operator, the following error occurs:

"A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=979, Message=ORA-00979: not a GROUP BY expression (50,380)"

The issue can be reproduced at will with the following steps:
1. Log in to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Run a query that contains aggregate functions and Oracle's proprietary join (+) operator
4. Notice the error




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.