Oracle Error Message
QSM-02194: CASE expressions present in materialized view
Reason for the Error
The capability in question is not supported when the materialized view contain CASE expressions.
Solution
Re-phrase the query to avoid the use of CASE expressions.