Results for “fnd_user_responsibility”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIS_USER_SECURED_ORGS1_V is a reporting view in the Oracle E-Business Suite Applications BIS product family. It joins the user responsibility assignment table (FND_USER_RESPONSIBILITY) against a secured organizations view (BIS_SECURED_ORGS1_V) and the responsibility definition table (FND_RESPONSIBILITY) to produce a flattened list of the organization identifiers and organization level short names that a given user can access through a given responsibility.
The view is designed to answer the recurring security question "which operating units (or other organization classification levels) can this user reach, and through which responsibility?" It exists because FND_USER_RESPONSIBILITY records only the user-to-responsibility mapping, while BIS_SECURED_ORGS1_V resolves the responsibility-to-organization security mapping. The view bridges the two, filtering out expired responsibility assignments and restricting to the current responsibility definition version. Although the ETRM metadata records that the object is "Not implemented in this database" in the documented environment, the view text and column list are preserved and describe the intended structure. In practice, BIS_USER_SECURED_ORGS1_V is used for security audits, user access reviews, and integration extracts where a consumer needs the effective set of secured organizations per user rather than per responsibility alone.
The view is read-only and exposes no write behavior; it reflects the live security configuration at query time.
Underlying Base Objects
The ETRM metadata identifies no separately documented base objects, but the embedded view text is explicit about the three sources referenced in the FROM clause:
- FND_USER_RESPONSIBILITY U — the user-to-responsibility assignment table, supplying USER_ID and RESPONSIBILITY_ID and the validity dates used for filtering. This is the same table referenced when the user searched for "fnd_user_responsibility," linking the view directly to that base object.
- BIS_SECURED_ORGS1_V S — the secured organizations view that resolves each responsibility to its authorized ORGANIZATION_ID and ORG_LEVEL_SHORT_NAME values.
- FND_RESPONSIBILITY R — the responsibility definition table, joined on RESPONSIBILITY_ID and constrained to R.VERSION = 'W' so that only the current working-version responsibility definition contributes rows.
Joins are performed on RESPONSIBILITY_ID between U and S, and between U and R. No outer joins are used, so only responsibilities that exist in all three sources appear in the result. The date predicates on U restrict output to assignments effective as of SYSDATE.
Key Columns
- USER_ID — the FND_USER identifier of the user holding the responsibility. Sourced from FND_USER_RESPONSIBILITY.
- RESPONSIBILITY_ID — the identifier of the responsibility through which access is granted. Sourced from FND_USER_RESPONSIBILITY and matched to both BIS_SECURED_ORGS1_V and FND_RESPONSIBILITY.
- ORGANIZATION_ID — the organization for which the responsibility carries security access, as resolved by BIS_SECURED_ORGS1_V.
- ORG_LEVEL_SHORT_NAME — the short name of the organization classification level (for example, operating unit level) associated with the secured organization, providing human-readable context for the ORGANIZATION_ID.
Common Use Cases and Queries
Typical uses include user access certification, segregation-of-duties analysis, and downstream extracts that must enumerate effective organization security per user. A basic query returns all secured organizations for a user:
- SELECT user_id, responsibility_id, organization_id, org_level_short_name FROM bis_user_secured_orgs1_v WHERE user_id = :p_user_id;
- SELECT responsibility_id, COUNT(*) FROM bis_user_secured_orgs1_v GROUP BY responsibility_id ORDER BY 2 DESC; — identifies responsibilities that grant the broadest organization access.
- SELECT DISTINCT user_id FROM bis_user_secured_orgs1_v WHERE organization_id = :p_org_id; — lists every user with access to a given organization.
Because the view already applies SYSDATE filtering and the R.VERSION = 'W' constraint, consumers do not need to re-implement assignment expiry or responsibility version logic. Join to FND_USER and FND_RESPONSIBILITY_TL for user names and responsibility display names when producing human-readable audit output.
-
Not implemented in this database·Explore BIS module →
-
Not implemented in this database·Explore BIS module →
-
APPS.WSMPINVL SQL Statements 12.1.1
-
APPS.WSMPINVL SQL Statements 12.2.2
-
PACKAGE BODY: APPS.WSMPINVL 12.1.1
-
PACKAGE BODY: APPS.WSMPINVL 12.2.2