Results for “activity_item_type”

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

Overview

WF_ACTIVITY_ATTRIBUTES_TL is the translation table for WF_ACTIVITY_ATTRIBUTES within the Oracle E-Business Suite workflow engine, owned by the APPLSYS schema and classified under the FND — Application Object Library product. Workflow activities are the executable units that make up a workflow process, and each activity may be configured with one or more attributes that supply runtime parameters, prompts, or default values. The base table WF_ACTIVITY_ATTRIBUTES stores the language-independent definition of those attributes, while WF_ACTIVITY_ATTRIBUTES_TL stores the language-specific display text associated with them. In a multilingual EBS deployment, every translatable attribute row exists once in the base table and once per installed language in the _TL table, with LANGUAGE distinguishing each translation row.

From a dimensional modeling perspective, the FK structure is satellite-leaning: the table hangs off the WF_ACTIVITY_ATTRIBUTES parent by its full business identity, making it a descriptive satellite of the activity-attribute definition rather than an independent hub or a many-to-many link.

Key Information Stored

The table carries twelve documented columns. The composite business identity — and the columns that determine which attribute a translation belongs to — are ACTIVITY_ITEM_TYPE (the workflow item type, such as an order or requisition type), ACTIVITY_NAME (the internal name of the workflow activity), ACTIVITY_VERSION, and NAME (the internal attribute name). LANGUAGE identifies the translation language using the standard NLS language code. DISPLAY_NAME and DESCRIPTION hold the translated, end-user-visible text used when the activity attribute is presented in a workflow notification or configuration form. SOURCE_LANG records the language from which the row was originally seeded, which is significant for translation-maintenance tooling such as the XLIFF export/import utilities.

Two unique indexes are documented: WF_ACTIVITY_ATTRIBUTES_TL_PK on ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_VERSION, NAME, LANGUAGE, and ZD_EDITION_NAME, and WF_ACTIVITY_ATTRIBUTES_TL_U2 on DISPLAY_NAME and the same identity columns. The _PK represents the true row identifier, while _U2 acts as a secondary business-key candidate guarding against duplicate display text per attribute. The remaining columns — PROTECT_LEVEL, CUSTOM_LEVEL, SECURITY_GROUOP_ID (note the documented spelling), and ZD_EDITION_NAME — carry Oracle seed-data protection, customization level, security grouping, and editioning metadata respectively. There is no standalone surrogate sequence key; identity is entirely business-key driven.

Common Use Cases and Queries

Reporting against this table is most often performed to audit translated workflow attribute text, verify translation completeness, or extract activity-attribute metadata for documentation and integration. A typical query joins the translation to the base table to confirm that every base attribute has a row for each language:

• Translation completeness check: select base rows from WF_ACTIVITY_ATTRIBUTES left-joined to WF_ACTIVITY_ATTRIBUTES_TL on ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_VERSION, and NAME, filtering where DISPLAY_NAME is null for a given LANGUAGE.
• Language-specific extraction: query DISPLAY_NAME, DESCRIPTION, and NAME filtered by ACTIVITY_ITEM_TYPE and LANGUAGE to produce localized attribute documentation.
• Duplicate or conflicting text detection: group by the identity columns plus LANGUAGE and compare DISPLAY_NAME values, leveraging the WF_ACTIVITY_ATTRIBUTES_TL_U2 constraint.
• Source-language reconciliation: compare SOURCE_LANG against LANGUAGE to identify rows that have not been re-translated after a base-language update.

Related Objects

The dominant relationship is the foreign key from WF_ACTIVITY_ATTRIBUTES_TL to WF_ACTIVITY_ATTRIBUTES on ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_VERSION, and NAME. The parent in turn belongs to the broader workflow definition family: WF_ACTIVITIES (activity catalog per item type and version), WF_ITEM_TYPES, and WF_ITEM_ATTRIBUTES for item-type-level attribute definitions. Runtime presentation of translated text flows through WF_NOTIFICATIONS and the notification mailer, while multilingual maintenance is supported by the FND translation and XLIFF export utilities. Administrators typically inspect these rows through the Workflow Builder configuration screens, which read the _TL table to render localized prompts.