Search Results pa_project_sets_tl_pk

Overview

PA.PA_PROJECT_SETS_TL is the multi-lingual support (MLS) translation table for project sets defined in Oracle Projects. Project sets are reusable groupings of projects that drive reporting, summarization, and access control across the Projects suite. Because Oracle EBS is deployed in global environments, the descriptive attributes of these sets — the set name and description — must be storable and printable in multiple installed languages. PA_PROJECT_SETS_TL fulfills that requirement by holding one translatable row per language per project set.

The table is owned by the PA schema and is documented as VALID in the ETRM 12.2.2 extract. It is a pure MLS companion to PA_PROJECT_SETS_B, which stores the language-independent (base) attributes. Its foreign keys to PA_PROJECT_SETS_B and to FND_LANGUAGES confirm that it exists only to supply translations for a parent set and to reference the installed language registry.

In Data Vault terms, the ETRM heuristic classifies this object as a link. This is a modeling suggestion: the table occupies an associative position, binding a project set (from the base table) to a language dimension, with descriptive payload attached to that combination. Modelers may alternatively treat it as a language-keyed satellite, but the heuristic classification is link.

Key Information Stored

The documented physical schema contains 10 columns. The most significant are:

• PROJECT_SET_ID — the identifier of the parent project set; part of the composite primary key and the FK to PA_PROJECT_SETS_B.
• LANGUAGE — the installed language (or source language) for which this row supplies a translation; the second component of the composite primary key and an FK to FND_LANGUAGES.
• SOURCE_LANG — the language from which the translation was derived; also references FND_LANGUAGES, marking the origin language of the row.
• NAME — the translated project set name; a business-key candidate through PA_PROJECT_SETS_TL_U2.
• DESCRIPTION — the translated descriptive text for the set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns that record who created and last modified each translation row and when.

The surrogate/business identifier is the primary key PA_PROJECT_SETS_TL_PK (PROJECT_SET_ID, LANGUAGE). Unique index PA_PROJECT_SETS_TL_U1 (PROJECT_SET_ID, LANGUAGE) mirrors the PK, while PA_PROJECT_SETS_TL_U2 (NAME, LANGUAGE) is the true business-key candidate, enforcing uniqueness of set names within a language.

Common Use Cases and Queries

Typical scenarios involve resolving a language-specific name for a project set, generating multilingual reports, and auditing translation completeness. A common pattern drills the set name for a given language:

• SELECT tlang.name, tlang.description FROM pa_project_sets_tl tlang, pa_project_sets_b b WHERE b.project_set_id = tlang.project_set_id AND tlang.language = USERENV('LANG') — joins the base set to its translation for the caller's session language.
• Comparing translated names against the base-language default to identify missing or stale translations, joining by PROJECT_SET_ID.
• Reporting all available language variants of a set by filtering on LANGUAGE against FND_LANGUAGES to restrict output to installed languages.
• Bulk auditing: counting translations per set to detect incomplete MLS coverage before a global deployment.
• Leveraging SOURCE_LANG to trace the origin of a translated row for data-quality reviews.

Because the table only stores descriptive text, transactional reporting should join through PA_PROJECT_SETS_B; direct queries against the TL table are appropriate only when a translated label is required.

Related Objects

• PA_PROJECT_SETS_B — the base (language-independent) table; join on PROJECT_SET_ID.
• FND_LANGUAGES — language registry; joined twice, via LANGUAGE and via SOURCE_LANG.
• PA_PROJECT_SETS_VL — the conventional MLS view that combines base and translated attributes for read-only access.
• PA_PROJECT_SET_ITEMS — defines the projects that belong to a set, joined indirectly through the base table.
• PA_PROJECTS_ALL — supplies the project members referenced by set contents.
• FND_LANGUAGE/FND_LANGUAGES_TL family — supports language naming and display in reports.
• Oracle Projects reporting views and concurrent programs that consume project sets resolve their labels through this table.