Search Results pa_period_mask_details




Overview
Explore in AI Chat

Overview

The PA_PERIOD_MASK_DETAILS table is a core data definition table within the Oracle E-Business Suite Projects (PA) module. It functions as a child table to PA_PERIOD_MASKS_B, storing the detailed configuration rules that define how periodic project data—such as costs, revenue, or commitments—is aggregated and displayed across time periods for reporting and inquiry purposes. A period mask acts as a template that determines the number of periods to show relative to a given anchor date (e.g., the current period or a project start date) and whether to display data for past, current, or future periods. This table holds the individual components that make up each mask, enabling flexible period-based reporting configurations that are critical for project analysis and financial roll-ups.

Key Information Stored

The table's structure is defined by its primary key, which consists of PERIOD_MASK_ID and FROM_ANCHOR_POSITION. The PERIOD_MASK_ID is a foreign key that links each detail record to its parent definition in PA_PERIOD_MASKS_B. The FROM_ANCHOR_POSITION column is a numeric identifier that establishes the order or sequence of the period range defined by the detail record. While the provided ETRM metadata does not list all columns, typical columns in such a configuration table would include TO_ANCHOR_POSITION, PERIOD_TYPE (e.g., PAST, CURRENT, FUTURE), and NUMBER_OF_PERIODS. Together, these columns define a contiguous block of periods (e.g., "show 6 past periods") that, when combined with other detail records for the same mask, create a complete reporting timeline.

Common Use Cases and Queries

This table is primarily referenced by the application's reporting engines and inquiry forms when constructing period-based data displays. Administrators may query it to audit or understand the active period mask configurations. A common reporting use case involves joining to PA_PERIOD_MASKS_B to retrieve the user-friendly name of the mask. For example, to list all details for a specific period mask, one might use the following SQL pattern:

  • SELECT detail.*, mask.PERIOD_MASK_NAME FROM PA.PA_PERIOD_MASK_DETAILS detail, PA.PA_PERIOD_MASKS_B mask WHERE detail.PERIOD_MASK_ID = mask.PERIOD_MASK_ID AND mask.PERIOD_MASK_NAME = 'Standard 12-Month View';

Data in this table is typically maintained via the application's user interface for defining period masks, not via direct SQL manipulation.

Related Objects

The PA_PERIOD_MASK_DETAILS table has a direct and essential relationship with its parent table, as documented in the ETRM metadata.

  • PA_PERIOD_MASKS_B: This is the parent table containing the master definition of the period mask. The relationship is enforced by a foreign key where PA_PERIOD_MASK_DETAILS.PERIOD_MASK_ID references PA_PERIOD_MASKS_B. A period mask definition in the parent table will have one or more detail records in this table defining its period ranges.

While not listed in the provided excerpt, this table is also foundational for various project reporting views and online analytical processing (OLAP) cubes that present time-phased project performance data.

  • Table: PA_PERIOD_MASK_DETAILS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIOD_MASK_DETAILS,  object_name:PA_PERIOD_MASK_DETAILS,  status:VALID,  product: PA - Projects ,  description: This table stores the various period mask details to be used for displaying periodic data ,  implementation_dba_data: PA.PA_PERIOD_MASK_DETAILS , 

  • Table: PA_PERIOD_MASK_DETAILS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIOD_MASK_DETAILS,  object_name:PA_PERIOD_MASK_DETAILS,  status:VALID,  product: PA - Projects ,  description: This table stores the various period mask details to be used for displaying periodic data ,  implementation_dba_data: PA.PA_PERIOD_MASK_DETAILS , 

  • Table: PA_PERIOD_MASKS_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIOD_MASKS_B,  object_name:PA_PERIOD_MASKS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the various period mask definitions to be used for displaying periodic data ,  implementation_dba_data: PA.PA_PERIOD_MASKS_B , 

  • Table: PA_PERIOD_MASKS_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIOD_MASKS_B,  object_name:PA_PERIOD_MASKS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the various period mask definitions to be used for displaying periodic data ,  implementation_dba_data: PA.PA_PERIOD_MASKS_B , 

  • View: PA_FP_WEBADI_PRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_PRD_V,  object_name:PA_FP_WEBADI_PRD_V,  status:VALID,  product: PA - Projects ,  description: This view is used in Financial Planning webadi download to get start date and end date for each periods based on period masks. ,  implementation_dba_data: APPS.PA_FP_WEBADI_PRD_V , 

  • View: PA_FP_WEBADI_PRD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_PRD_V,  object_name:PA_FP_WEBADI_PRD_V,  status:VALID,  product: PA - Projects ,  description: This view is used in Financial Planning webadi download to get start date and end date for each periods based on period masks. ,  implementation_dba_data: APPS.PA_FP_WEBADI_PRD_V ,