Search Results pa_work_types_tl

Overview

The PA_WORK_TYPES_TL table is a core data object within the Oracle E-Business Suite (EBS) Projects module (PA). It provides multi-lingual support (MLS) for work types, which are user-defined classifications of project work (e.g., Analysis, Development, Testing). Its primary role is to store the translated names and descriptions of work types in multiple languages, enabling the system to present and report project data in a user's preferred language. This table operates in conjunction with its base table, PA_WORK_TYPES_B, which holds the language-independent attributes. The existence of this table is fundamental for global implementations of Oracle Projects where data must be maintained and accessed in more than one language.

Key Information Stored

The table stores translated textual attributes for each work type. Its structure is defined by a composite primary key consisting of WORK_TYPE_ID and LANGUAGE. The WORK_TYPE_ID column is a foreign key that links each row to a specific work type defined in the PA_WORK_TYPES_B table. The LANGUAGE column contains the ISO language code (e.g., 'US' for American English, 'DE' for German) and is a foreign key to the FND_LANGUAGES table, identifying the language of the translated text. A critical column is SOURCE_LANG, also referencing FND_LANGUAGES, which indicates the original language in which the data was entered. This allows the system to identify which translation is the source for subsequent translations. The core data columns typically include NAME and DESCRIPTION, which hold the translated work type name and its explanatory description, respectively.

Common Use Cases and Queries

A primary use case is generating reports or populating user interfaces with work type information in a session's current language. For example, a project summary report run by a German user would query this table to retrieve the work type names in German ('DE'). Common SQL patterns involve joining this table with its base table and filtering by the desired language. A standard query to retrieve all active work types for a specific language would be:

• SELECT b.WORK_TYPE_ID, tl.NAME, tl.DESCRIPTION
• FROM PA_WORK_TYPES_B b, PA_WORK_TYPES_TL tl
• WHERE b.WORK_TYPE_ID = tl.WORK_TYPE_ID
• AND tl.LANGUAGE = USERENV('LANG')
• AND b.END_DATE_ACTIVE IS NULL;

Another critical scenario is during the translation process itself, where administrators populate this table with new language records, ensuring the SOURCE_LANG is correctly set to maintain data lineage.

Related Objects

PA_WORK_TYPES_TL has direct, integral relationships with several key EBS objects. Its existence is dependent on the PA_WORK_TYPES_B table, as every translated record must correspond to a base work type definition; this is enforced by a foreign key constraint on the WORK_TYPE_ID column. Furthermore, it has two foreign key relationships with the application foundation table FND_LANGUAGES: one for the LANGUAGE column to validate the language code, and another for the SOURCE_LANG column. From a functional perspective, this table is referenced by various Oracle Projects application programming interfaces (APIs), user interface forms, and underlying views that present work type data. Any programmatic or reporting logic that displays a work type name in a multi-lingual environment will ultimately query this translation table.