Search Results gl_wf_roles_v




Overview
Explore in AI Chat

Overview

GL_WF_ROLES_V is a seeded Oracle E-Business Suite view owned by the APPS schema and categorized under the General Ledger (GL) product family. It is a Workflow-oriented role resolution view that presents a unified list of assignable roles drawn from two distinct sources: application users defined in FND_USER and responsibilities defined in FND_RESPONSIBILITY_TL. The view exists to bridge Oracle Workflow and Oracle Application Object Library (FND) so that workflow notification routing, approver assignment, and directory services can treat users and responsibilities as a single homogeneous set of roles.

The view carries a status of VALID in both EBS 12.1.1 and 12.2.2, and its definition is delivered as Oracle proprietary, confidential information. It exposes six columns—DISPLAY_NAME, NAME, DESCRIPTION, ORIG_SYSTEM, ORIG_SYSTEM_ID, and TYPE—which together form a normalized role descriptor compatible with the Oracle Workflow directory services abstraction. Because the view is read-only and defined purely as a UNION ALL of base synonyms, it imposes no storage overhead and always reflects current underlying FND data.

Underlying Base Objects

Per the ETRM metadata, GL_WF_ROLES_V is defined over two referenced base objects, both accessed through APPS synonyms: FND_USER (SYNONYM) and FND_RESPONSIBILITY_TL (SYNONYM). The first branch of the UNION ALL selects from FND_USER, filtering on the user's end date with the predicate NVL(USR.END_DATE, TRUNC(SYSDATE)) >= TRUNC(SYSDATE), which retains only users who are currently active or have no end date. The second branch selects from FND_RESPONSIBILITY_TL, restricted to APPLICATION_ID IN (0, 101, 275) and LANGUAGE = USERENV('LANG') so that only responsibilities belonging to the relevant applications and the session's language are returned.

Because both underlying objects are referenced as APPS synonyms, the view inherits the standard FND security and language-handling behavior of those tables. The fixed application filter (0, 101, 275) indicates the view is scoped to a specific functional grouping of responsibilities rather than the entire responsibility catalog.

Key Columns

  • DISPLAY_NAME — The human-readable label: USR.USER_NAME for user rows, or R.RESPONSIBILITY_NAME for responsibility rows.
  • NAME — The internal role key. User rows use USR.USER_NAME; responsibility rows use a concatenation 'FND_RESP'||APPLICATION_ID||':'||RESPONSIBILITY_ID, producing a globally unique identifier per responsibility.
  • DESCRIPTION — The description attribute from FND_USER or FND_RESPONSIBILITY_TL.
  • ORIG_SYSTEM — The source system designator. User rows return the literal 'FND_USR'; responsibility rows return 'FND_RESP'||APPLICATION_ID, identifying both the origin type and the owning application.
  • ORIG_SYSTEM_ID — The primary key in the originating system. For users this is USR.USER_ID; for responsibilities this is R.RESPONSIBILITY_ID. This column is the join key back to the source entity and is frequently the target of user searches.
  • TYPE — A literal classification: 'FND USER' for user rows and 'FND RESPONSIBILITY' for responsibility rows.

Common Use Cases and Queries

The view is typically queried to resolve workflow role membership, populate approver lists, or reconcile ORIG_SYSTEM_ID values back to FND_USER.USER_ID and FND_RESPONSIBILITY.RESPONSIBILITY_ID. A representative query resolving a role by its origin identifier is:

SELECT display_name, name, orig_system, orig_system_id, type FROM apps.gl_wf_roles_v WHERE orig_system_id = :p_id;

To list only active user-based roles:

SELECT display_name, name FROM apps.gl_wf_roles_v WHERE type = 'FND USER' ORDER BY display_name;

To enumerate responsibilities for the General Ledger application (APPLICATION_ID 101):

SELECT display_name, orig_system_id FROM apps.gl_wf_roles_v WHERE orig_system = 'FND_RESP101';

Because ORIG_SYSTEM_ID is not unique across source systems, filters should always qualify by ORIG_SYSTEM or TYPE to avoid ambiguity between a user ID and a responsibility ID that happen to share the same numeric value.