FND_USER_RESP_GROUPS is no longer valid in 11.5.10.2
(Doc ID 858274.1)
Last updated on FEBRUARY 18, 2024
Applies to:
Oracle Application Object Library - Version 10.7 to 11.5.10.2 [Release 10.7 to 11.5]Information in this document applies to any platform.
Goal
The problem is that customer is unable to run an ad hoc report to summarize user profiles. The table that he used to use, FND_USER_RESP_GROUPS, no longer exists, and was replaced with FND_USER_RESP_GROUPS_OLD, which (not surprisingly) contains archived but unchanging data. One of our analysts told him "FND_USER_RESP_GROUPS is a view that can be opened from application only. This view is based on tables fnd_user wf_user_role_assignments_v wura and wf_user_roles." The application security works just fine - He just can't report on it and review it outside the application,(which has no function to summarize user\security profiles).
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |