Hello,
we have webcenter content and portal 12.2.1.3
SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationName  IN  ( 'Yes' , 'No' )   will fetch us records.
BUT
SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationIdentifierNumber  IN  (  45789 ,  23567 , 33445, 65432 )   -  why this query wont fetch us any records where we are expecting it to fetch 4 records. ?