Oracle Error Message
QSM-02002: DISTINCT aggregate measure in SELECT list
Reason for the Error
The capability in question is not supported when the materialized view uses the DISTINCT qualifier on an aggregate function.
Solution
Remove the DISTINCT qualifier.