Message Oracle QSM-02002 - DISTINCT aggregate measure in SELECT list

ERRORDISTINCT aggregate measure in SELECT list
CAUSEThe capability in question is not supported when the materialized view uses the DISTINCT qualifier on an aggregate function.
ACTIONRemove the DISTINCT qualifier.