← All tables
Oracle EBS/Security/FND
FND_USER_RESP_GROUPS
User ↔ responsibility assignments — which responsibilities each user holds and for what date range.
Key Columns
USER_IDRESPONSIBILITY_IDRESPONSIBILITY_APPLICATION_IDSTART_DATEEND_DATE
Used In
FND
Notes
In practice most code queries the FND_USER_RESP_GROUPS_DIRECT view over this table.
Related
EBS security: users and responsibilities
EBS accounts are FND_USER; access is granted by assigning responsibilities (FND_RESPONSIBILITY_TL) through FND_USER_RESP_GROUPS. Profile options (FND_PROFILE_OPTION_VALUES) tune behaviour per site / responsibility / user.