Search Results assigning_role




Overview
Explore in AI Chat

Overview

APPS.WF_ALL_USER_ROLE_ASSIGNMENTS is a reporting and integration view within the Oracle E-Business Suite Workflow (WF) schema. It exposes the assignment of roles to users as maintained by the Oracle Workflow directory service, presenting each relationship in a denormalized, human-readable form. In EBS 12.1.1 and 12.2.2 the view is owned by APPS and is a synonym-based presentation over the WF_USER_ROLE_ASSIGNMENTS base object. Its purpose is to make the user-to-role mapping directly queryable without requiring callers to resolve internal relationship identifiers or numeric codes.

The most significant transformation performed by the view is the translation of the RELATIONSHIP_ID column. When RELATIONSHIP_ID equals -1, the view returns the literal 'DIRECT', indicating an explicitly granted assignment. Any other value returns 'INHERITED', indicating that the role was acquired indirectly — for example through a group or role hierarchy. This DISTINCT rendering of assignment origin is the primary reason the view exists rather than querying the synonym directly.

Underlying Base Objects

The documented base object is WF_USER_ROLE_ASSIGNMENTS, referenced through a synonym. No joins to other tables are documented in the ETRM view text: the SELECT list reads from a single source. The view therefore does not itself aggregate across WF_ROLES, WF_USERS, or WF_USER_ROLES; enrichment with user or role attributes requires additional joins by the consumer.

Because the view is defined over the synonym, its behaviour tracks the underlying assignment table in lockstep with the Workflow directory synchronization and role assignment APIs. The view is read-only in practice; all mutations occur through Workflow directory service APIs or the base table.

Key Columns

Common Use Cases and Queries

Typical uses include security reviews (which users hold a privileged role), access certification reporting, and troubleshooting notifications that fail to route. The query below lists active direct assignments for a given role:

  • SELECT user_name, role_name, assigning_role, start_date, end_date, assignment_reason FROM apps.wf_all_user_role_assignments WHERE role_name = :p_role AND start_date <= SYSDATE AND (end_date IS NULL OR end_date > SYSDATE)
  • To isolate explicit grants only, add AND DECODE(RELATIONSHIP_ID,-1,'DIRECT','INHERITED') = 'DIRECT'.
  • To audit recent changes, filter on last_update_date >= :p_since and order by last_updated_by.

Because the view returns only user-role pairs, pairing it with FND_USER for employee details or WF_ROLES for role display names is common. All queries should respect the date window to avoid counting expired assignments.