Oracle Error QSM-02004: grouping column omitted from SELECT list

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.