Search Results pa_project_sets_tl_u1




Overview
Explore in AI Chat

Overview

PA.PA_PROJECT_SETS_TL is the multi-lingual support (MLS) translation table for project sets defined in Oracle Projects. A project set is a named collection of projects used for reporting, summarization, and batch processing across Oracle Projects and related modules. The base definition of a project set—its identifier and structural attributes—resides in PA.PA_PROJECT_SETS_B, while this table stores the language-dependent descriptive attributes, specifically the project set NAME and DESCRIPTION, for each installed language.

The table is owned by the PA schema, resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and is registered in FND Design Data as PA.PA_PROJECT_SETS_TL. Its status is VALID in Oracle EBS 12.1.1 and 12.2.2. From a heuristic Data Vault modeling perspective, this object classifies as a satellite: it hangs off the hub represented by PA_PROJECT_SETS_B and carries descriptive, language-qualified attributes keyed by PROJECT_SET_ID and LANGUAGE. The foreign keys to FND_LANGUAGES for both LANGUAGE and SOURCE_LANG reinforce its role as a reference-data-backed descriptive satellite rather than an independent hub or a transactional link.

Key Information Stored

The table holds ten documented columns. The most significant are:

  • PROJECT_SET_ID (NUMBER, 15, mandatory) – Unique identifier of the project set, joining back to PA_PROJECT_SETS_B. Part of the primary key PA_PROJECT_SETS_TL_PK (PROJECT_SET_ID, LANGUAGE).
  • LANGUAGE (VARCHAR2, mandatory) – The language code for the row's translated columns; the second component of the primary key. Foreign key to FND_LANGUAGES.
  • SOURCE_LANG (VARCHAR2) – The actual language in which the translated columns were originally entered, before any translation. Foreign key to FND_LANGUAGES.
  • NAME (VARCHAR2, 240) – The translated project set name, exposed to users in the current session language. This is a business-key candidate via unique index PA_PROJECT_SETS_TL_U2 (NAME, LANGUAGE).
  • DESCRIPTION (VARCHAR2, 2000) – Free-text translated description of the project set.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who columns for auditing row creation and modification.

The surrogate primary key is the composite (PROJECT_SET_ID, LANGUAGE). Two unique indexes act as business-key candidates: PA_PROJECT_SETS_TL_U1 (PROJECT_SET_ID, LANGUAGE) mirrors the primary key, while PA_PROJECT_SETS_TL_U2 (NAME, LANGUAGE) enforces uniqueness of the translated name within a language—preventing duplicate project set names per language. The user's search term "pa_project_sets_tl_u2" refers specifically to this second unique index on (NAME, LANGUAGE).

Common Use Cases and Queries

Typical usage centers on retrieving the display name and description of a project set in a specific language, resolving translation gaps against the source language, and validating naming uniqueness. A common reporting pattern joins the MLS row to its base row:

  • Retrieve a translated project set name: SELECT name FROM pa.pa_project_sets_tl WHERE project_set_id = :id AND language = USERENV('LANG');
  • Compare source versus translated content: SELECT source_lang, language, name, description FROM pa.pa_project_sets_tl WHERE project_set_id = :id ORDER BY language;
  • Detect translation coverage gaps by comparing available language rows against FND_LANGUAGES.
  • Investigate duplicate-name errors surfaced by the PA_PROJECT_SETS_TL_U2 index during project set creation or translation maintenance.
  • Build multi-language lookup listings ordered by NAME for a given LANGUAGE.

Because MLS tables can contain a row per language, reports should always filter on LANGUAGE to avoid Cartesian duplication.

Related Objects

  • PA.PA_PROJECT_SETS_B – Base table holding the language-independent project set definition; joined on PROJECT_SET_ID.
  • PA.PA_PROJECT_SETS_TL# – The underlying object referenced during DDL/maintenance operations.
  • FND_LANGUAGES – Referenced twice, via LANGUAGE and SOURCE_LANG, to validate installed languages and source language codes.
  • PA_PROJECT_SETS_TL_PK – Primary key constraint on (PROJECT_SET_ID, LANGUAGE).
  • PA_PROJECT_SETS_TL_U1 / PA_PROJECT_SETS_TL_U2 – Unique indexes supporting surrogate and name-based lookups respectively.