Results for “gl_period_types”

50+ results




Overview
Explore in AI Chat

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

Overview

GL_PERIOD_TYPES is a General Ledger reference table that defines the calendar period types used throughout Oracle E-Business Suite, such as Month, Quarter, Year, and any user-defined accounting period types. It is owned by the GL schema and resides in the Oracle General Ledger module. Every accounting calendar maintained in General Ledger is built upon one or more period types, and the table serves as the master list from which periods are generated and against which period names are validated.

Because GL_PERIOD_TYPES stores the canonical definition of period types that are referenced by balances, budgets, recurring journals, translation and archival processes, it behaves as a reference or lookup hub in a dimensional or Data Vault model. The metadata's heuristic classification of this object is hub, which reflects its role as the stable, business-keyed entity at the center of many foreign-key relationships. A Data Vault modeler could therefore treat GL_PERIOD_TYPES as a hub keyed on PERIOD_TYPE_ID or PERIOD_TYPE, with the dependent GL objects attached as satellites or links.

Key Information Stored

The table is defined with 18 documented columns. The most significant are:

Common Use Cases and Queries

Typical reporting and diagnostic queries join GL_PERIOD_TYPES to GL_PERIODS to resolve the period type behind an accounting period, or to GL_PERIOD_STATUSES to report open and closed periods by type.

SELECT pt.period_type_id, pt.period_type, pt.user_period_type,
       pt.number_per_fiscal_year, p.period_name, p.start_date, p.end_date
FROM   gl_period_types pt, gl_periods p
WHERE  pt.period_type_id = p.period_type
ORDER BY pt.period_type, p.start_date;

A frequent operational scenario is identifying which set of books or implementations use a given period type, since GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE and PA_IMPLEMENTATIONS_ALL.PA_PERIOD_TYPE both reference this table. Another common task is auditing balance rows in GL_BALANCES or GL_DAILY_BALANCES by period type to reconcile subledger and GL activity. Reporting solutions also resolve USER_PERIOD_TYPE to obtain the reporting-friendly name of each period granularity.

Related Objects

GL_PERIOD_TYPES is referenced by many GL and Projects objects through the PERIOD_TYPE column. The most significant dependents include:

  • GL_PERIODS.PERIOD_TYPE — the actual accounting periods built from each period type.
  • GL_PERIOD_STATUSES.PERIOD_TYPE — open/closed status per period and set of books.
  • GL_BALANCES.PERIOD_TYPE and GL_DAILY_BALANCES.PERIOD_TYPE — account balances summarized by period type.
  • GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE — the accounted period type assigned to each ledger.
  • GL_BUDGET_INTERFACE.PERIOD_TYPE and GL_BUDGET_INTERIM.PERIOD_TYPE — budget upload and interim budget processing.
  • GL_RECURRING_HEADERS.PERIOD_TYPE and GL_RECURRING_BATCHES.PERIOD_TYPE — recurring journal definitions.
  • GL_TRANSLATION_INTERIM.PERIOD_TYPE and GL_POSTING_INTERIM.PERIOD_TYPE — translation and posting interim tables.
  • PA_IMPLEMENTATIONS_ALL.PA_PERIOD_TYPE and PA_PROJ_PERIOD_PROFILES.GL_PERIOD_TYPE — Projects period profiles.

These relationships confirm the object's hub role, as it is joined through foreign keys for balance, budget, recurring journal, translation, and Projects reporting.