Oracle issues after upgrade to 12.2

If we look into the source of this view ctx_preference_values:
[sourcecode language=”sql” highlight=”6″]
create or replace view ctxsys.ctx_preference_values as
select /*+ ORDERED INDEX(dr$preference_value) */
u.name prv_owner
,pre_name prv_preference
,oat_name prv_attribute
,decode(oat_datatype, ‘B’, decode(prv_value, 1, ‘YES’, ‘NO’),
nvl(oal_label, prv_value)) prv_value
from
sys."_BASE_USER" u
,dr$preference
,dr$preference_value
,dr$object_attribute
,dr$object_attribute_lov
where prv_value = nvl(oal_value, prv_value)
and oat_id = oal_oat_id (+)
and oat_id = prv_oat_id
and prv_pre_id = pre_id
and pre_owner# = u.user#;
[/sourcecode]
and check PRV_VALUE from ctxsys.dr$preference_value:
[sourcecode language=”sql” highlight=”8″]
select pre_name, prv_pre_id,prv_value
from ctxsys.dr$preference
, ctxsys.dr$preference_value
, ctxsys.dr$object_attribute
where prv_pre_id = pre_id
and oat_id = prv_oat_id
and oat_datatype=’B’
and not regexp_like(prv_value,’^\d*$’)
/
PRE_NAME PRV_PRE_ID PRV_VALUE
——————————— ———- ———-
CTXSYS.JSONREST_GERMAN_LEXER 1098 YES
CTXSYS.JSONREST_GERMAN_DIN_LEXER 1104 YES

[/sourcecode]
we can find that the root cause of the problem is the line with decode(prv_value, 1, ‘YES’, ‘NO’)
and values ‘YES’ for preferences ‘CTXSYS.JSONREST_GERMAN_LEXER’, ‘CTXSYS.JSONREST_GERMAN_DIN_LEXER’.

Oracle tries to compare ‘YES’ with 1 in decode() and raises ORA-01722.