Search Results pa_projects_erp_ext_tl_pk

Overview

PA_PROJECTS_ERP_EXT_TL is a translation table in the Oracle E-Business Suite Projects (PA) module, owned by the PA schema. It stores translated user-defined attribute (descriptive flexfield) data for both the project and task level, providing the language-specific values that correspond to the descriptive flexfield segments configured against projects and project elements. In a multi-language EBS deployment, this table allows each user-defined attribute caption or value to be maintained independently per installed language, so that reports and forms presented to users in different locales display the appropriate translation.

The object is a _TL (translated) table, which in EBS convention means it holds a language column and remains synchronized with a _B (base) counterpart keyed on the same surrogate. Here the base surrogate is EXTENSION_ID, and LANGUAGE determines the translated row. Within a Data Vault modeling heuristic, this table is best classified as a link table: it connects a language dimension (FND_LANGUAGES) to the project/task descriptive flexfield extension context, resolving the many-to-many association between extension definitions and installed languages while carrying the descriptive translation payload.

Key Information Stored

The table contains 51 documented columns. The most significant are:

• EXTENSION_ID — Surrogate identifier of the descriptive flexfield extension (attribute group) instance; part of the composite primary key PA_PROJECTS_ERP_EXT_TL_PK.
• LANGUAGE — The language of the translated row, also part of the primary key and part of the unique index PA_PROJECTS_ERP_EXT_TL_U1.
• SOURCE_LANG — The source language from which the translation originates (the base-language row), a foreign key to FND_LANGUAGES.
• PROJECT_ID — Foreign key to PA_PROJECTS_ALL, identifying the project to which the user-defined attribute belongs.
• PROJ_ELEMENT_ID — Foreign key to PA_PROJ_ELEMENTS, identifying the task or project element when the attribute is maintained at the task level.
• ATTR_GROUP_ID — Identifier of the attribute group (flexfield context) to which the translated attributes belong.
• TL_EXT_ATTR1 through TL_EXT_ATTR40 — Forty translated user-defined attribute columns holding the language-specific descriptive flexfield values for the extension row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns for audit and concurrency tracking.

The surrogate primary key is PA_PROJECTS_ERP_EXT_TL_PK (EXTENSION_ID, LANGUAGE), and the unique index PA_PROJECTS_ERP_EXT_TL_U1 (EXTENSION_ID, LANGUAGE) documents the same business-key candidate pair, ensuring one translated row per extension per language.

Common Use Cases and Queries

Typical uses include localized reporting of project and task descriptive flexfield values, audit of which languages have been translated, and reconciling translated attributes against their base rows. A representative query joining the translated rows to the language dimension and project:

• Retrieve translated attributes for a project in a specific language:
  SELECT p.segment1, tl.language, tl.tl_ext_attr1, tl.tl_ext_attr2
FROM pa_projects_erp_ext_tl tl, pa_projects_all p
WHERE tl.project_id = p.project_id
AND tl.language = 'US';
• Identify missing translations by comparing installed languages to rows present per EXTENSION_ID.
• Join to PA_PROJ_ELEMENTS to report task-level translated attributes for a given project element.
• Validate SOURCE_LANG versus LANGUAGE to detect translation drift or stale rows.

Related Objects

• PA_PROJECTS_ALL — joined via PA_PROJECTS_ERP_EXT_TL.PROJECT_ID = PA_PROJECTS_ALL.PROJECT_ID.
• PA_PROJ_ELEMENTS — joined via PA_PROJECTS_ERP_EXT_TL.PROJ_ELEMENT_ID = PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID.
• FND_LANGUAGES — referenced twice, via LANGUAGE and SOURCE_LANG.
• PA_PROJECTS_ERP_EXT_B — the base-language counterpart holding the untranslated extension values.
• FND_DESCRIPTIVE_FLEXS / FND_FLEX_VALUES_TL — the flexfield setup and value translations that provide the framework for the user-defined attributes.
• PA_PROJECTS_ERP_EXT_VL — the translated views layered over the base and translation tables for display.