Oracle Message QSM-02134 - agg(expr) requires correspondng MAX(expr) function

ERRORagg(expr) requires correspondng MAX(expr) function
CAUSEThe capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the MAX function on the same argument.
ACTIONAdd the MAX function to the select list.