+11Dear Team,
Is there any specific window or other way that we can get the list of users connected with a specific profile or who are not connected ?
Wants to see the list who are not connected with the base profile or null?
Many thanks in advance.
Best regards,
Kalhari.
Best answer by Manulak
The base profile content and the users assigned can be viewed on Base Profile details screen.
To view users who are not connected with a base profile, simply create an SQL quick report with the following statement.
SELECT IDENTITY
FROM IFSAPP.FND_USER user_
WHERE user_.ACTIVE = 'TRUE'
AND IDENTITY NOT IN (SELECT IDENTITY
FROM IFSAPP.FNDRR_USER_CLIENT_PROFILE
WHERE ORDINAL = 1)
Alter the same to get customized results if required.
Looks like the profiles are defined in the table fndrr_client_profile_tab, and the profile/user assignments in fndrr_user_client_profile_tab, so you should be able to use these tables to write a query to give you the information you need.
+8The base profile content and the users assigned can be viewed on Base Profile details screen.
To view users who are not connected with a base profile, simply create an SQL quick report with the following statement.
SELECT IDENTITY
FROM IFSAPP.FND_USER user_
WHERE user_.ACTIVE = 'TRUE'
AND IDENTITY NOT IN (SELECT IDENTITY
FROM IFSAPP.FNDRR_USER_CLIENT_PROFILE
WHERE ORDINAL = 1)
Alter the same to get customized results if required.
+11Hi
Thank you very much for the detailed answer. It worked :)
Best regards,
Kalhari.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
