Results for “per_time_period_types_vl”

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

Overview

PER_TIME_PERIOD_TYPES_VL is a validation-level (VL) view in the APPS schema belonging to the PER — Human Resources product family. It exposes the definitions of time period types used throughout Oracle E-Business Suite for calendar and fiscal reporting structures, such as month, quarter, and year period types and the number of such periods per fiscal year. The _VL suffix indicates that this view joins a base table with its translation table, presenting translated descriptive text alongside the base row data. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration access point over these definitions without requiring consumers to resolve the underlying translation join themselves.

Underlying Base Objects

The view is defined over two documented base objects, both exposed through synonyms referenced by the view definition:

• PER_TIME_PERIOD_TYPES — the base operational table (aliased as B) holding the canonical period type rows and the majority of descriptive and audit columns.
• PER_TIME_PERIOD_TYPES_TL — the translation table (aliased as T) holding language-specific descriptive text.

The join condition links B.PERIOD_TYPE = T.PERIOD_TYPE and restricts the translation row to the session's current language via T.LANGUAGE = USERENV('LANG'). This is the standard Oracle EBS translated-view pattern: base attributes are read once from the unilingual table, while human-readable text is retrieved in the user's active language.

Key Columns

• ROW_ID — the base table row identifier (B.ROWID), useful for direct row addressing.
• PERIOD_TYPE — the unique key or code identifying the period type.
• NUMBER_PER_FISCAL_YEAR — the count of periods of this type occurring within a fiscal year.
• YEAR_TYPE_IN_NAME — controls whether the year value is incorporated into generated period names; this is the column most directly relevant to the user's search term.
• DESCRIPTION — translated descriptive text for the period type, sourced from the translation table.
• DISPLAY_PERIOD_TYPE — the translated display label for the period type, also from the translation table.
• SYSTEM_FLAG — indicates whether the period type is system-defined (seeded) or user-defined.
• Standard audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).
• Descriptive flexfield columns — ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20.

Common Use Cases and Queries

Typical uses include listing available period types for a calendar or fiscal configuration, verifying translation behaviour in a multilingual environment, and validating YEAR_TYPE_IN_NAME settings that affect period naming conventions. A basic query retrieving period type definitions and their translated labels is:

• SELECT period_type, number_per_fiscal_year, year_type_in_name, description, display_period_type FROM apps.per_time_period_types_vl;

To isolate system-defined period types:

• SELECT period_type, description FROM apps.per_time_period_types_vl WHERE system_flag = 'Y';

To inspect naming behaviour for fiscal periods:

• SELECT period_type, number_per_fiscal_year, year_type_in_name FROM apps.per_time_period_types_vl ORDER BY number_per_fiscal_year;

Because the view resolves the language join automatically, it is preferred over querying the translation table directly in reports and integrations that must honour the current user's language setting.