Oracle Error Message
QSM-02004: grouping column omitted from SELECT list
Reason for the Error
The 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.
Solution
Include all GROUP BY expressions in the output select list.