Hi,1 person found this helpful
In 11.5.10 the responsibilities user set up was moved to the workflow tables. The view FND_USER_RESP_GROUPS does not give the full details anymore.
You need to use either the FND_USER_RESP_GROUPS_ALL or FND_USER_RESP_GROUPS_DIRECT view.
Thank you very much. I used fnd_user_resp_groups_all.
the FND_USER_RESP_GROUPS or FND_USER_RESP_GROUPS_ALL are stand for what exactely?
FND_USER_RESP_GROUPS_ALL lists all users and against all responsibilities they ever had even if they no longer have them.
FND_USER_RESP_GROUPS lists only the users who have current, active responsibilities
All you need to do is SELECT * from each and you will see the difference.