Search Results wf_item_types_tl_pk




Overview
Explore in AI Chat

Overview

The WF_ITEM_TYPES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Application Object Library (FND). It is owned by the APPLSYS schema and is integral to the Oracle Workflow technology stack. Its primary role is to store multilingual translations for the display attributes of workflow item types. An item type is a container that defines a specific workflow process, its components, and its runtime rules. This table enables the EBS application to present workflow-related information, such as process names and descriptions, in the language of the end-user, supporting global deployments. It operates as a child table to the base table WF_ITEM_TYPES, which holds the language-independent definition.

Key Information Stored

The table stores translated text for key descriptive attributes of workflow item types. Its structure is defined by two primary keys, ensuring data integrity for multilingual access. The most critical columns include NAME, which corresponds to the internal name of the item type from the WF_ITEM_TYPES table and forms part of the primary key with LANGUAGE. The DISPLAY_NAME column holds the translated, user-friendly name of the item type as seen in the application interface and is also uniquely constrained with LANGUAGE. The LANGUAGE column stores the standard Oracle language code (e.g., 'US' for American English). Additional columns typically found in EBS translation tables, such as SOURCE_LANG, DESCRIPTION, and LAST_UPDATE_DATE, are also present to manage translation sourcing and maintenance, though they are not explicitly detailed in the provided metadata.

Common Use Cases and Queries

This table is primarily accessed by the Oracle Workflow engine and the EBS application's runtime to display process information in the user's session language. Common functional use cases include generating translated reports on available workflow processes or troubleshooting display issues in multilingual environments. A typical query retrieves the translated display name for a specific item type and language. For example, to find the Spanish display name for the 'POAPPRV' item type:

  • SELECT display_name FROM apps.wf_item_types_tl WHERE name = 'POAPPRV' AND language = 'ES';

Another common pattern is to join this table with WF_ITEM_TYPES to get a complete language-specific view of all defined item types for a report:

  • SELECT b.name, t.display_name, t.language FROM apps.wf_item_types b, apps.wf_item_types_tl t WHERE b.name = t.name AND t.language = USERENV('LANG');

Related Objects

WF_ITEM_TYPES_TL has a direct foreign key relationship with its parent table, WF_ITEM_TYPES, joining on the NAME column. The primary key WF_ITEM_TYPES_TL_PK (NAME, LANGUAGE) uniquely identifies each translation row. The unique key WF_ITEM_TYPES_TL_UK2 (DISPLAY_NAME, LANGUAGE) ensures display name uniqueness per language. This table is also referenced by various Workflow APIs and views that present aggregated workflow metadata. Administrators should note that direct data manipulation (DML) on this table is strongly discouraged; modifications should be performed through the standard Oracle Workflow administration interfaces or supported APIs to maintain data consistency.