Oracle Error Message
QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause
Reason for the Error
The capability in question was not supported because the materialized view query contained an ORDER BY clause.
Solution
Rephrase the query to avoid the use of the ORDER BY clause.