Message Oracle QSM-02004 - grouping column omitted from SELECT list

ERRORgrouping column omitted from SELECT list
CAUSEThe capability in question is not supported when the materialized view contains a column or expression in the GROUP BY clause that is not also present in the list of output select expressions.
ACTIONInclude all GROUP BY expressions in the output select list.