Results for “rbs_version_id”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RBS_VERSIONS_TL is a translation (TL) table in the Oracle Projects (PA) schema that stores language-specific, version-specific descriptive information for Resource Breakdown Structure (RBS) versions. In Oracle EBS, an RBS defines the hierarchical classification of resources—such as people, organizations, or equipment—used for planning, budgeting, and reporting against projects. The _TL suffix indicates this table holds the translatable text attributes (primarily name and description) for each logical RBS version record maintained in the base table PA_RBS_VERSIONS_B. Because Oracle EBS supports multiple installed languages via the FND_LANGUAGES seed table, translated tables like this one carry one row per (business entity, language) combination, enabling multilingual access to the same underlying RBS definition.

From a data modeling perspective, the metadata's heuristic Data Vault classification is link. This reflects the table's associative role: it connects an RBS version identifier to a language, forming the junction that carries descriptive satellite-style attributes (NAME, DESCRIPTION) keyed by that pairing. Implementers designing a Data Vault layer may therefore treat it as a link between the RBS version hub and a language reference.

Key Information Stored

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

  • RBS_VERSION_ID — Surrogate foreign key to PA_RBS_VERSIONS_B, identifying the parent RBS version. It is part of the unique business key.
  • LANGUAGE — The language code of the translated row; foreign key to FND_LANGUAGES. Also part of the unique key.
  • SOURCE_LANG — The language from which the text was translated; foreign key to FND_LANGUAGES, typically the base/installation language.
  • NAME — The translated name of the RBS version, the principal user-visible label.
  • DESCRIPTION — The translated longer description of the RBS version.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns providing audit and concurrency tracking.

The documented unique index PA_RBS_VERSIONS_TL_U1 covers (RBS_VERSION_ID, LANGUAGE), confirming the composite business key: for any given RBS version, at most one translated row exists per language.

Common Use Cases and Queries

Typical reporting needs include producing a language-specific listing of RBS versions and joining translated labels to base-table attributes. A standard query pattern restricts the TL row to a single language to avoid duplicate rows per version:

  • Retrieve RBS version names for a locale:
    SELECT t.RBS_VERSION_ID, t.NAME, t.DESCRIPTION FROM PA_RBS_VERSIONS_TL t WHERE t.LANGUAGE = USERENV('LANG') AND t.SOURCE_LANG = USERENV('LANG');
  • Compare translations across languages for a single version by joining on RBS_VERSION_ID and filtering distinct LANGUAGE values.
  • Join to PA_RBS_VERSIONS_B on RBS_VERSION_ID to obtain non-translatable version attributes alongside the translated name.
  • Feed project resource reporting and budgeting extracts where the RBS version label must appear in the user's preferred language.

Because translations may not exist for every language, reporting SQL should use an outer join or a fallback to SOURCE_LANG to avoid missing labels.

Related Objects

The following objects are the most significant references based on the documented foreign keys and table relationships:

  • PA_RBS_VERSIONS_B — Base table holding the RBS version master record; joined on PA_RBS_VERSIONS_TL.RBS_VERSION_ID = PA_RBS_VERSIONS_B.RBS_VERSION_ID.
  • FND_LANGUAGES — Referenced twice, via LANGUAGE and SOURCE_LANG, supplying installed language definitions.
  • PA_RBS_ELEMENTS and related RBS element tables — define the resource hierarchy within a given RBS version and are contextually linked through the version identifier.
  • PA_RBS_VERSIONS_VL — The translated view typically exposed to forms and reports, which resolves the current-language row from this TL table.
  • PA_PROJECTS / PA_RESOURCE_* — Project and resource assignment tables that consume RBS structures for planning and budgeting.

Together these objects support the multilingual, versioned definition of resource breakdown structures central to Oracle Projects planning and reporting.