Oracle Error Message
QSM-02063: aggregate function in mv
Reason for the Error
The capability in question is not supported when the materialized view uses an aggregate function.
Solution
Re-phrase the query to avoid the use of the aggregate functions.