Search Results wf_eng_list_roles




Overview
Explore in AI Chat

Overview

The APPS.WF_ENG_LIST_ROLES view is a directory-service integration object in Oracle E-Business Suite, owned by the Application Object Library (FND) product. Its documented purpose is to serve as the "Bulk Sync Directory Service Role View for Orig System ENG_LIST." In the Oracle Workflow and directory services architecture, a "role view" exposes an external source of roles and approval entities to the Workflow Directory Service so that they can be resolved, synchronized, and referenced by notification and routing logic. The view presents Engineering (ENG) change approval lists as workflow roles, allowing approval lists defined in the Engineering module to participate in the Workflow notification infrastructure under the originating system identifier 'ENG_LIST'.

The view is defined with status VALID in the APPS schema and is available in both the 12.1.1 and 12.2.2 releases. Because it is a view rather than a table, it holds no data of its own; it renders rows dynamically from its underlying base object at query time.

Underlying Base Objects

The view is defined over a single documented base object: ENG_ECN_APPROVAL_LISTS, which is referenced via a synonym in the APPS schema. This table stores Engineering Change Order (ECO) approval list definitions, including the approval list identifier, name, and description.

The view text selects specific attributes from ENG_ECN_APPROVAL_LISTS and projects them into the standard role-view column layout expected by the Workflow Directory Service bulk synchronization process. Notably, the view constructs a composite role key by concatenating the literal 'ENG_LIST' with a colon and the APPROVAL_LIST_ID, and it derives the ORIG_SYSTEM value as the constant 'ENG_LIST'. The STATUS is hard-coded as 'ACTIVE', several columns such as LANGUAGE, TERRITORY, EMAIL_ADDRESS, and FAX are returned as NULL, and USER_FLAG is set to 'N', indicating these entries represent roles rather than individual users. The PARTITION_ID column is populated with the constant 7.

Key Columns

  • NAME — Composite role identifier formed as 'ENG_LIST:' concatenated with APPROVAL_LIST_ID.
  • DISPLAY_NAME — Taken from APPROVAL_LIST_NAME; the human-readable label for the role.
  • DESCRIPTION — Taken from the DESCRIPTION column of the approval list.
  • NOTIFICATION_PREFERENCE — Hard-coded to 'QUERY'.
  • ORIG_SYSTEM — Constant 'ENG_LIST', identifying the originating system for directory synchronization.
  • ORIG_SYSTEM_ID — The APPROVAL_LIST_ID from the base table.
  • STATUS — Constant 'ACTIVE'.
  • USER_FLAG — Constant 'N', distinguishing these records as roles rather than users.
  • PARTITION_ID — Constant 7.
  • LANGUAGE, TERRITORY, EMAIL_ADDRESS, FAX, START_DATE, EXPIRATION_DATE, SECURITY_GROUP_ID — Returned as NULL or TO_DATE(NULL).

Common Use Cases and Queries

This view is most often used to inspect or validate the set of Engineering approval lists that will be propagated to the Workflow Directory Service during bulk synchronization. Administrators troubleshooting role resolution or notification routing for Engineering approvals query it directly to confirm the composite role names and their status.

A typical query lists all roles exposed by the view:

  • SELECT name, display_name, description, orig_system, orig_system_id, status FROM apps.wf_eng_list_roles ORDER BY display_name;

To locate the role corresponding to a specific approval list, the ORIG_SYSTEM_ID column may be filtered:

  • SELECT name, display_name FROM apps.wf_eng_list_roles WHERE orig_system_id = :approval_list_id;

Because the underlying base object is ENG_ECN_APPROVAL_LISTS, the view reflects the current state of approval list definitions at query time. Any insert, update, or deletion in the base table is immediately visible through the view, making it a reliable reference for both diagnostic and integration validation purposes.