Message Oracle QSM-02025 - no aggregate functions

ERRORno aggregate functions
CAUSEThe capability in question is not supported when the materialized view uses no aggregate functions.
ACTIONRe-phrase the query to use aggregate functions.