Message Oracle QSM-01202 - query rewrite not possible when OPTIMIZER_MODE is set to rule based

ERRORquery rewrite not possible when OPTIMIZER_MODE is set to rule based
CAUSEQuery rewrite did not occur because the OPTIMIZER_MODE was set to RULE.
ACTIONChange the optimizer mode using the OPTIMIZER_MODE parameter.