Results for “ghr_groupbox_users”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view APPS.WF_GBX_UR is an Oracle E-Business Suite database object owned by the APPS schema and classified under the FND — Application Object Library product. Its documented status is VALID in both Oracle EBS 12.1.1 and 12.2.2. The ETRM description defines it as the "Bulk Sync Directory Service User Role View for Role Orig System GBX," identifying it as a flattened, read-only projection of Groupbox membership data that is consumed by the Oracle Workflow Directory Service bulk synchronization process.

In Oracle EBS, the Workflow Directory Service (WFDS) maintains a cached representation of users, roles, and their relationships so that notifications, approval routing, and role resolution can be performed efficiently. The "bulk sync" mechanism refreshes that cache by reading from adapter views that expose user-to-role assignments in a standardized format. WF_GBX_UR is one such adapter: it presents Groupbox memberships — where each Groupbox represents a role and each Groupbox user represents a role member — as a uniform set of user/role association rows. This allows the synchronization program to load GBX-originated assignments without custom code. The view is therefore a reporting and integration surface rather than a transactional object, and it is typically referenced by Workflow configuration, diagnostic queries, and custom extracts that need to reconcile Workflow role membership with the underlying Groupbox tables.

Underlying Base Objects

Per the documented metadata, WF_GBX_UR is defined over three objects, each referenced through an APPS synonym: FND_USER, GHR_GROUPBOXES, and GHR_GROUPBOX_USERS. The view's SQL text joins them as follows:

• GHR_GROUPBOX_USERS GBU — the membership (junction) table linking a user name to a Groupbox identifier.
• GHR_GROUPBOXES GBX — the Groupbox header table, supplying the Groupbox name and ID that become the role name and role identifier.
• FND_USER U — the application user repository, supplying the employee identifier and validating that the user is a recognized EBS user.

The join predicates are GBU.GROUPBOX_ID = GBX.GROUPBOX_ID, GBU.USER_NAME = U.USER_NAME, and the filter U.EMPLOYEE_ID IS NOT NULL. The inner joins mean that only memberships referencing a valid user record having a non-null employee ID are returned; orphaned Groupbox user rows or users without an employee assignment are excluded. Because the base objects are referenced via synonyms, the view resolves against the same underlying tables regardless of the specific 12.1.1 or 12.2.2 environment, and the documented reference list is identical across both releases.

Key Columns

The view projects the following columns, using hard-coded literals to standardize the origin system values expected by the Workflow Directory Service:

• USER_NAME — the EBS user name from GHR_GROUPBOX_USERS and FND_USER.
• USER_ORIG_SYSTEM — literal 'PER', indicating the user originates from the PER (Human Resources) system.
• USER_ORIG_SYSTEM_ID — the employee ID from FND_USER.
• ROLE_NAME — the Groupbox name from GHR_GROUPBOXES.
• ROLE_ORIG_SYSTEM — literal 'GBX', identifying the role origin system as Groupbox.
• ROLE_ORIG_SYSTEM_ID — the Groupbox ID from GHR_GROUPBOXES.
• START_DATE and EXPIRATION_DATE — both projected as TO_DATE(NULL), indicating no effective dating is supplied by this view.
• SECURITY_GROUP_ID — projected as NULL.
• PARTITION_ID — constant 10, the partition identifier used by the synchronization framework.

The uniform column set aligns WF_GBX_UR with other origin-system adapter views, enabling the bulk sync process to consume it through a common interface.

Common Use Cases and Queries

Typical uses include auditing Groupbox membership, validating which memberships are visible to Workflow synchronization (bearing in mind the EMPLOYEE_ID IS NOT NULL filter), and feeding custom notifications or extracts. A basic query listing all synchronized Groupbox role assignments is:

• SELECT user_name, role_name, role_orig_system_id FROM wf_gbx_ur ORDER BY role_name, user_name;

To list members of a specific Groupbox role by its Groupbox ID:

• SELECT user_name, user_orig_system_id FROM wf_gbx_ur WHERE role_orig_system_id = :groupbox_id;

To compare the synchronized view against the raw membership table and surface excluded rows:

• SELECT gbu.user_name FROM ghr_groupbox_users gbu WHERE NOT EXISTS (SELECT 1 FROM wf_gbx_ur v WHERE v.user_name = gbu.user_name);

These queries should be executed with APPS-level read privileges, and results are subject to the view's documented join and filter conditions.