Search Results pa_period_masks_tl_pk

Overview

The PA_PERIOD_MASKS_TL table is a core data object within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It functions as a translation table, storing language-specific definitions for period masks used throughout the Projects application. A period mask is a formatting template that dictates how periodic data, such as financial or project performance information, is displayed to users in reports and inquiries. The table's primary role is to support the application's multilingual capabilities by providing translated descriptions of these masks based on the user's session language, ensuring consistent and localized data presentation across global deployments.

Key Information Stored

The table's structure is centered around a unique identifier and its corresponding translated text. The most critical column is PERIOD_MASK_ID, which serves as the primary key and the foreign key linking each translation row to its base definition in the PA_PERIOD_MASKS_B table. The table also includes standard Translation Table (TL) columns mandated by the Oracle Applications architecture. These typically include LANGUAGE and SOURCE_LANG to identify the language of the translated text and the original source language, respectively. The core data column is PERIOD_MASK_NAME, which holds the actual translated descriptive name of the period mask (e.g., "Month-Year", "Quarter-Year", "Week-Year") as it should appear in the user interface for the specified language.

Common Use Cases and Queries

This table is primarily accessed by the application's internal logic to resolve display labels. Common use cases include generating localized project reports, populating language-sensitive list of values (LOVs) for period mask selection, and ensuring period-based inquiry screens show appropriate labels. A typical query would join this table to its base table to retrieve all available masks for a user's language. For example, to list all period masks for the American English language code 'US':

• SELECT b.period_mask_code, tl.period_mask_name
• FROM pa_period_masks_b b, pa_period_masks_tl tl
• WHERE b.period_mask_id = tl.period_mask_id
• AND tl.language = USERENV('LANG');

Reporting or data extraction scripts that need to present period information with descriptive labels would also perform similar joins to this translation table.

Related Objects

The PA_PERIOD_MASKS_TL table has a direct and singular dependency on the PA_PERIOD_MASKS_B table, which stores the non-translatable base definitions. As documented in the provided metadata, the relationship is enforced by a foreign key constraint where PA_PERIOD_MASKS_TL.PERIOD_MASK_ID references PA_PERIOD_MASKS_B. This is a classic Oracle Applications Translation Table architecture pattern. The primary key for PA_PERIOD_MASKS_TL is named PA_PERIOD_MASKS_TL_PK and is defined on the PERIOD_MASK_ID, LANGUAGE, and SOURCE_LANG columns. The table is owned by the PA schema and is integral to the period display functionality within the Projects module.