Results for “pa_resource_lists_tl”

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

Overview

PA_RESOURCE_LISTS_TL is the translation (TL) table for resource lists in the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. A resource list is a reusable grouping of people, organizations, or roles that drives project staffing, assignment validation, and resource search functionality within Oracle Projects. Because resource list names and descriptions must be presented to users in their own language, Oracle stores the translatable text attributes separately from the base transactional record.

PA_RESOURCE_LISTS_TL holds the language-dependent columns — NAME and DESCRIPTION — keyed by RESOURCE_LIST_ID and LANGUAGE. The base or "all" record resides in PA_RESOURCE_LISTS_ALL_BG, which carries the non-translatable attributes and the canonical list identifier. This split follows Oracle's standard multi-language (MLS) architecture, in which one row is stored per installed language for each translatable entity.

From a Data Vault modeling perspective, the metadata's FK-based heuristic classifies this object as a link, since it resolves associations between the base resource list (via RESOURCE_LIST_ID) and language definitions (via LANGUAGE and SOURCE_LANG). In practice, the table also behaves as a satellite of descriptive text attached to the base resource list, so modelers should treat the classification as a suggestion rather than a definitive role.

Key Information Stored

The documented physical schema comprises 11 columns in the PA schema, with a primary-key index PA_RESOURCE_LISTS_TL_PK on RESOURCE_LIST_ID and a unique business-key index PA_RESOURCE_LISTS_TL_U1 on (RESOURCE_LIST_ID, LANGUAGE, ZD_EDITION_NAME).

• RESOURCE_LIST_ID — surrogate/foreign identifier linking the row to the parent resource list in PA_RESOURCE_LISTS_ALL_BG; part of the primary key.
• LANGUAGE — the FND_LANGUAGES code identifying the language in which NAME and DESCRIPTION are stored.
• SOURCE_LANG — the FND_LANGUAGES code of the source language from which the translation was derived, used by the translation framework.
• NAME — the translated display name of the resource list.
• DESCRIPTION — the translated descriptive text of the resource list.
• ZD_EDITION_NAME — edition discriminator supporting Oracle's edition-based redefinition; it participates in the unique business key.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording modification metadata.
• CREATION_DATE, CREATED_BY — standard WHO columns recording initial row creation.

The business-key candidates (RESOURCE_LIST_ID, LANGUAGE, ZD_EDITION_NAME) uniquely identify a translated resource list record per language and edition, while RESOURCE_LIST_ID alone forms the physical primary key.

Common Use Cases and Queries

Reporting on resource lists in a specific language is the most frequent use. A typical query joins the base table to the translation table, filtering on LANGUAGE and edition:

• Resource list lookup for staffing screens: SELECT rl.resource_list_id, tl.name, tl.description FROM pa_resource_lists_all_bg rl, pa_resource_lists_tl tl WHERE rl.resource_list_id = tl.resource_list_id AND tl.language = USERENV('LANG')
• Translation completeness audit: compare the count of PA_RESOURCE_LISTS_TL rows per LANGUAGE against installed languages in FND_LANGUAGES to find missing translations.
• Change tracking: filter on LAST_UPDATE_DATE to identify recently modified names or descriptions for reconciliation against data-load or migration scripts.
• Edition-aware extraction for 12.2.2, joining on ZD_EDITION_NAME to isolate the active edition.

Because NAME and DESCRIPTION are stored only here for non-base languages, any interface or discoverer report that presents resource list text must query this table rather than the "_ALL_BG" base table.

Related Objects

• PA_RESOURCE_LISTS_ALL_BG — parent base table; joined on PA_RESOURCE_LISTS_TL.RESOURCE_LIST_ID = PA_RESOURCE_LISTS_ALL_BG.RESOURCE_LIST_ID.
• FND_LANGUAGES — referenced twice, through PA_RESOURCE_LISTS_TL.LANGUAGE and PA_RESOURCE_LISTS_TL.SOURCE_LANG.
• PA_RESOURCE_LISTS_TL_PK / PA_RESOURCE_LISTS_TL_U1 — primary and unique indexes enforcing row identity and the multilingual business key.
• PA_RESOURCE_LIST_MEMBERS — member assignments that reference the resource list; text for these lists is resolved through this TL table.
• Oracle Projects resource-list UI and concurrent programs — consume translated names via the standard MLS view layer built on this table.