jananif,

Please try the following:

select identity, description from fnd_user
where fndrr_user_client_profile_api.get_base_profile_id(identity) is NULL
and identity not like 'IFS%' and active = 'TRUE';

Steve

Please like this response if it helped you

Here are some more information about tables related to profiles.

fndrr_client_profile_tab => details about all available profiles

fndrr_user_client_profile_tab => mapping between the profile and the user. Important: the type of the profile can be determined by the value of the ordinal column. If it’s 1 then it’s a base profile, if it’s 0 then it’s a personal profile, 9 is for standard profile.

fndrr_client_profile_tab => content of the profile