Query throwing ORA-00979 not a group by expression in oracle 11g 11.2.0 but it works fine in 10g

CAUSE- Its i a bug in oracle 11g  bug number 9411496

Action to be performed to resolve this issues is 

SOLUTION 1

*Firsrt of all create the pfile from spfile 

*Then in pfile set the hidden parameter  “_FIX_CONTROL”=’5520732:OFF’ in the pfile

* This parameter disable a given bug number

*_FIX_CONTROL is a undocumented parameter  that can be used to turn off/on a particular bug fix identifier.

*Now, We run the query and it successfully gives a result

SOLUTION 2

 set the parameter optimizer_features_enable to a previous version of Oracle, ’11.1.0.7′ for example

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE='11.1.0.7';

Thank you very much,