Oracle Message QSM-02117 - missing GROUPING_ID or GROUPING functions on GROUP BY column(s)

ERRORmissing GROUPING_ID or GROUPING functions on GROUP BY column(s)
CAUSEThe capability in question is not supported when the materialized view uses grouping sets but omits the relevant GROUPING_ID or GROUPING functions.
ACTIONRe-phrase the query to include the relevant GROUPING_ID or GROUPING functions.