QSM-02220
File Change Tracking (FCT) FAST REFRESH is not possible if HAVING clause includes a subquery.
Cause
This capability is not supported because the materialized view query HAVING clause includes a subquery.
Action
Avoid using a subquery in the HAVING clause.