Oracle Error Message
QSM-02059: join may produce duplicate rows in mv
Reason for the Error
The capability in question is not supported when the materialized view contains a join condition that can result in duplicate rows in the materialized view.
Solution
Re-phrase the query to avoid the occurrence of duplicate rows in the materialized view.