Oracle Error Message
QSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to rule based
Reason for the Error
Query rewrite did not occur because the OPTIMIZER_MODE was set to RULE.
Solution
Change the optimizer mode using the OPTIMIZER_MODE parameter.