My Oracle Support Banner

"ORA-00979: Not A GROUP BY Expression" After Upgrade to Database 12C (Doc ID 2005725.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (APEX) - Version to [Release 4 to 5]
Information in this document applies to any platform.
@ Checked for relevance for APEX 4.2.6 on 01 June 2018


After upgrading the database to, logging into APEX and selecting "Administration" --> "Monitor Activity" ---> "Active Sesssion"
Returns error ORA-00979 : not a GROUP BY expression.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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