Oracle Error Message
QSM-02206: PCT FAST REFRESH is not possible because this query join may produce extra duplicate rows
Reason for the Error
The capability in question was not supported because the materialized view contained a join condition that can result in duplicate rows in the materialized view.
Solution
Rephrase the query to avoid the occurrence of duplicate rows in the materialized view.