Oracle Error Message
QSM-02003: aggregate function nested within an expression
Reason for the Error
The capability in question is not supported when the materialized view contains an aggregate function invocation nested within an outer expression.
Solution
Re-phrase the expression such that the aggregate function invocation is not nested.