Results for “wf_local_roles_tl”

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

Overview

WF_LOCAL_ROLES_TL is a translated (language-specific) table in the APPLSYS schema of Oracle E-Business Suite, owned by the FND – Application Object Library product. It stores the translatable descriptive attributes of workflow roles and users maintained by the Oracle Workflow directory services layer. The table's "_TL" suffix indicates that it holds one row per language for each base role record, supplying display-oriented text such as the role display name and description while the base table WF_LOCAL_ROLES holds the language-independent identity and routing attributes.

Functionally, WF_LOCAL_ROLES_TL supports the role resolution and notification infrastructure used across Oracle Workflow, Oracle Applications notifications, and approval routing. When a notification is dispatched, the display names and descriptions rendered to recipients are resolved from this table for the session language. The documented physical schema for ETRM 12.2.2 records 13 columns and a single unique index, WF_LOCAL_ROLES_TL_U1, spanning NAME, ORIG_SYSTEM, ORIG_SYSTEM_ID, LANGUAGE, and PARTITION_ID. This composite uniqueness constraint defines the business key: a role is uniquely identified by its name, originating system, originating identifier, language, and partition. Because the table resolves descriptive text per language rather than expressing a relationship between two distinct entities, the heuristic Data Vault classification mined from its foreign-key structure is standalone; from a modeling perspective it is most naturally treated as a satellite of the role hub, dependent on the parent role identity rather than a link between roles.

Key Information Stored

The table's columns separate identity, descriptive text, and audit metadata:

• NAME – The internal role or user name; part of the unique business key WF_LOCAL_ROLES_TL_U1 and the principal join attribute back to the base WF_LOCAL_ROLES record.
• DISPLAY_NAME – The user-facing label presented in workflow notifications, approval lists, and directory lookups for the given language.
• DESCRIPTION – Free-text description of the role or user, also language-specific.
• ORIG_SYSTEM and ORIG_SYSTEM_ID – Identify the source system and the originating record identifier for the role. ORIG_SYSTEM_ID carries a foreign key to HZ_ORIG_SYSTEMS_B, connecting workflow roles to the Trading Community Architecture origin registry.
• PARTITION_ID – The directory partition to which the role belongs; foreign key to JTF_FM_PARTITION_X_REQUEST. This supports partitioned role resolution in large multi-organization or multi-tenant directories.
• LANGUAGE – The language of the row's NAME, DISPLAY_NAME, and DESCRIPTION, and a component of the business key.
• OWNER_TAG – A tag identifying the owning context or application of the role.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard FND audit columns recording who created and last modified each translated row and when.

No separate surrogate primary key column is documented in the ETRM column list; the unique index WF_LOCAL_ROLES_TL_U1 establishes the business-key candidate, and the base role identity resides in WF_LOCAL_ROLES.

Common Use Cases and Queries

Typical usage centers on resolving human-readable labels for roles and users during notification rendering and directory reporting. A common pattern joins the translated table to the base role table filtered by the session language:

• Display name lookup: SELECT r.name, t.display_name FROM wf_local_roles r, wf_local_roles_tl t WHERE r.name = t.name AND r.orig_system = t.orig_system AND r.orig_system_id = t.orig_system_id AND t.language = USERENV('LANG');
• Role inventory reporting: List distinct roles by originating system, joining ORIG_SYSTEM_ID to HZ_ORIG_SYSTEMS_B to obtain the source-system name.
• Partition analysis: Aggregate roles by PARTITION_ID to assess directory partition distribution and load.
• Translation completeness audits: Compare row counts per LANGUAGE against the base WF_LOCAL_ROLES population to detect missing translations or stale DISPLAY_NAME values.
• Change tracking: Query LAST_UPDATE_DATE and LAST_UPDATED_BY to report on recent directory maintenance activity.

Related Objects

The most significant dependencies and joins are:

• WF_LOCAL_ROLES – The base (non-translated) role table; join on NAME, ORIG_SYSTEM, and ORIG_SYSTEM_ID to combine identity and language-independent attributes with translated text.
• WF_LOCAL_USER_ROLES – Maps users to roles; used with this table to render role assignments with display names.
• WF_ROLES – Higher-level role definition table referenced during workflow role resolution.
• HZ_ORIG_SYSTEMS_B – Referenced by ORIG_SYSTEM_ID; supplies the originating-system definition for each role.
• JTF_FM_PARTITION_X_REQUEST – Referenced by PARTITION_ID; provides partition context for role resolution.
• WF_USERS and WF_NOTIFICATIONS – Consume role display names when presenting notifications and approval actions to recipients.