Results for “wf_activities_tl”

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

Overview

WF_ACTIVITIES_TL is the translation table for the Oracle Workflow activity definitions stored in APPLSYS.WF_ACTIVITIES_TL. In Oracle E-Business Suite 12.1.1 and 12.2.2, this table holds the language-specific descriptive text — display names and descriptions — associated with each workflow activity identified by its item type, internal name, and version. The base definitional attributes of an activity reside in the parent WF_ACTIVITIES table, while WF_ACTIVITIES_TL supplies the multilingual text required for a globalized, multi-language Workflow runtime and for translatable end-user presentation of notification and routing metadata. The table is owned by the APPLSYS schema, is flagged VALID, and belongs to the FND - Application Object Library product family.

From a heuristic Data Vault modeling perspective, this object is classified as standalone. It therefore does not decompose cleanly into a hub, link, or satellite pattern on its own; it is best treated as a descriptive satellite-like structure attached to the activity business key, retaining language-dependent attributes while sharing the parent activity key. It is not a transactional or junction entity.

Key Information Stored

The table carries eleven documented columns. The most operationally significant are the following:

• ITEM_TYPE — the workflow item type that scopes the activity. Part of the composite business key.
• NAME — the internal name of the activity, unique within an item type and version. Part of the business key.
• VERSION — the activity version, permitting multiple revisions of the same named activity.
• LANGUAGE — the NLS language code identifying which translation row is being read.
• DISPLAY_NAME — the translated, user-facing label for the activity, and also a component of the WF_ACTIVITIES_TL_U2 unique index.
• DESCRIPTION — the translated long description shown to users in Workflow administration and notification screens.
• SOURCE_LANG — the base language from which the translation was derived.
• PROTECT_LEVEL — the protection level controlling whether the row may be modified by customers.
• CUSTOM_LEVEL — the customization level indicating the degree to which the definition has been altered.
• SECURITY_GROUP_ID — links the translated row to a security group via FND_SECURITY_GROUPS, supporting multi-org/security-group isolation.
• ZD_EDITION_NAME — the editioning discriminator used in 12.2 online patching.

The primary key is WF_ACTIVITIES_TL_PK over ITEM_TYPE, NAME, VERSION, and LANGUAGE (extended with ZD_EDITION_NAME in the documented 12.2.2 physical schema). The unique index WF_ACTIVITIES_TL_U2 is defined over DISPLAY_NAME, ITEM_TYPE, VERSION, and LANGUAGE, making it a secondary business-key candidate.

Common Use Cases and Queries

The table is used primarily for resolving the translated name and description of a workflow activity in reports, notification templates, and administration interfaces. A typical lookup joins the translation table to its parent by the shared business key:

• SELECT a.name, t.display_name, t.description FROM wf_activities a JOIN wf_activities_tl t ON t.item_type = a.item_type AND t.name = a.name AND t.version = a.version AND t.language = 'US' WHERE a.item_type = :item_type;
• Reporting on activities lacking a translation for a given language, to support localization gap analysis.
• Auditing PROTECT_LEVEL and CUSTOM_LEVEL to identify customer-modified workflow definitions.
• Filtering by SECURITY_GROUP_ID to enforce security-group scoped Workflow visibility.

Related Objects

The most significant related objects follow directly from the documented relationships.

• WF_ACTIVITIES — the parent base table supplying activities; joined on ITEM_TYPE, NAME, and VERSION.
• FND_SECURITY_GROUPS — referenced by WF_ACTIVITIES_TL.SECURITY_GROUP_ID, the sole documented foreign key relationship.
• WF_ACTIVITY_ATTRS — activity attribute definitions that reference activity names.
• WF_ITEM_TYPES_TL — translations for the item types that scope these activities.
• WF_PROCESS_ACTIVITIES — process-to-activity associations using the same key columns.
• FND_LANGUAGES — supplies the valid LANGUAGE codes.