Oracle Message QSM-02136 - agg(expr) requires correspondng VARIANCE(expr) function

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