I need to query all the users who doesn’t have a base profile. Please some one help me how to get the data. any table or view where i can get this information?
Userlevel 7
+21
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.