Message Oracle QSM-02084 - DISTINCT clause on a duplicate sensitive aggregate function

ERRORDISTINCT clause on a duplicate sensitive aggregate function
CAUSEThe capability in question is not supported when the materialized view uses the DISTINCT clause in this context.
ACTIONRe-phrase the query to avoid the use of the DISTINCT clause.