Search Results wf_fnd_usr_ur




Overview
Explore in AI Chat

Overview

The WF_FND_USR_UR view is a public Oracle E-Business Suite database object owned by the APPS schema and classified under the FND – Application Object Library product. Its status is VALID, and it is available in Oracle EBS releases 12.1.1 and 12.2.2. The view presents a unified, flattened representation of user and role information drawn from the Oracle Workflow directory services model. In the Workflow architecture, every entity that can participate in a workflow — a person, an application user, or a role — is represented as a "role" in the WF_LOCAL_ROLES table. The WF_FND_USR_UR view bridges the FND_USER application user record to that Workflow role model, exposing the mapping between an EBS user name and its corresponding Workflow role identity. It is primarily used by Workflow notification routing, directory synchronization, and reporting queries that need to resolve users and roles across the two subsystems.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base objects: FND_USER and WF_LOCAL_ROLES, both referenced through synonyms in the APPS schema. The view text is a UNION ALL of two branches. The first branch joins FND_USER to WF_LOCAL_ROLES PARTITION (PER_ROLE) on the condition USR.EMPLOYEE_ID = PER.ORIG_SYSTEM_ID, and additionally filters on the date range so that only currently active role assignments are returned. This branch handles users linked to a human resource (HR) person record. The second branch selects from FND_USER alone, filtered by USR.EMPLOYEE_ID IS NULL, and assigns a synthetic origin system of 'FND_USR' with the USER_ID as the origin system identifier. In both branches the user name is carried through as both the user name and role name, producing a normalized row shape.

Key Columns

  • USER_NAME – The FND_USER user name identifying the application user.
  • USER_ORIG_SYSTEM – The origin system for the user, set to 'PER' for HR-linked users and 'FND_USR' for standalone users.
  • USER_ORIG_SYSTEM_ID – The identifier of the user in its origin system; the HR ORIG_SYSTEM_ID for person-linked users, or USER_ID otherwise.
  • ROLE_NAME – The workflow role name, which maps to the user name in this view.
  • ROLE_ORIG_SYSTEM – The origin system of the role, again 'PER' or 'FND_USR'.
  • ROLE_ORIG_SYSTEM_ID – The identifier of the role in its origin system.
  • START_DATE / EXPIRATION_DATE – The effective date range of the user and role association.
  • SECURITY_GROUP_ID – Reserved for security group scoping; NULL in both branches.
  • PARTITION_ID – A partition indicator; a constant value of 1 is returned.

Common Use Cases and Queries

The view is typically used to enumerate users with their associated Workflow role identity, to troubleshoot workflow notification recipients, and to reconcile FND_USER entries against Workflow directory roles. A common query lists all users and their origin system classification:

  • SELECT user_name, user_orig_system, role_orig_system_id FROM wf_fnd_usr_ur ORDER BY user_name;
  • SELECT * FROM wf_fnd_usr_ur WHERE user_orig_system = 'PER'; — returns only users linked to an HR person record.
  • SELECT * FROM wf_fnd_usr_ur WHERE user_orig_system = 'FND_USR'; — returns standalone users with no employee association.
  • SELECT user_name FROM wf_fnd_usr_ur WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date, TRUNC(SYSDATE)) AND NVL(expiration_date, TRUNC(SYSDATE+1));

Because the view already applies an active-date filter on the PER_ROLE branch, results reflect currently valid role assignments for HR-linked users, making it suitable for integration extracts and directory reporting.