When configuring the Oracle probe, you may notice that after configuring and testing a query, the "checked value" field does not allow you to select non-int values (only int-type values are available on the list)
UIM 20.4 and later
Working as designed
This is working as designed, Oracle's probe "checked value" does not support non-int type values.
However, there is a workaround for this issue.
You can modify the query to convert the output from YES to 1 and NO to 0 and then you will be able to use this in the checked value field.