Oracle Error Message
QSM-02035: no filter conditions are present in the HAVING clause
Reason for the Error
The capability in question is not supported when the materialized view includes no filter condition in the HAVING clause.
Solution
Re-phrase the query to include a join.