ORA-979 After Upgrading To 10.2.0.4 (Doc ID 873532.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Getting Below ORA-979 error after upgrading to 10.2.0.4 from 9.2.
.
SQL> select inventory_item_id , count(mpc_header_id)
2 from xxvfp_dis_mpc_fso_vt
3 group by inventory_item_id;
group by inventory_item_id
*
ERROR at line 3:
ORA-979: not a GROUP BY expression

Errorstack could be similar to

ksdpec PGOSF95__ksfpec kgesev kgesec0 qcuErroer qcuErroep erroep VInfreq__qecgoc
    VInfreq__qecgoc qecsel qecdrv kkqcttcalo kkqctdrvVM vopqbc vopqbc vopqbc vopdrv kkqctdrvTD
       kkqdrv kkqctdrvIT apadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock


Cause

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