"ORA-00979: Not A GROUP BY Expression" After Upgrade to Database 12C
Last updated on JUNE 01, 2018
Applies to:Oracle Application Express (APEX) - Version 4.2.6.00.03 to 5.0.1.00 [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 188.8.131.52, logging into APEX and selecting "Administration" --> "Monitor Activity" ---> "Active Sesssion"
Returns error ORA-00979 : not a GROUP BY expression.
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 hundreds of Community platforms