Oracle Error QSM-01526: query rewrite is disabled for equivalence, string

Oracle Error Message

QSM-01526: query rewrite is disabled for equivalence, string

Reason for the Error

Query rewrite could not use this equivalence, because this equivalence was created as disabled.

Solution

Enable this equivalence using alter_rewrite_equivalence procedure from package, dbms_advanced_rewrite.