Oracle Message QSM-02011 - a HAVING clause is present

ERRORa HAVING clause is present
CAUSEThe capability in question is not supported when the materialized view uses a HAVING clause.
ACTIONRemove the HAVING clause.