Oracle Error Message
QSM-02201: PCT FAST REFRESH is not possible if there is a self join or self cartesian product in query
Reason for the Error
The capability in question was not supported because the materialized view query contained self join of self cartesian product in the query.
Solution
Rephrase the query to avoid the use of self joins or self cartesian product in the query.