Search Results gl_period_sets

Overview

The GL_PERIOD_SETS table is a foundational data object within the Oracle E-Business Suite (EBS) General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for calendar definitions, also known as accounting calendars. An accounting calendar defines the fiscal year structure, including its periods (e.g., months, quarters), and is a critical component for financial reporting and transaction processing. The table's primary role is to store the unique definition of each calendar, which is then referenced by numerous other entities across the financial ecosystem, including ledgers, journals, and subledger accounting.

Key Information Stored

The table's structure centers on uniquely identifying and describing each accounting calendar. The primary key is the PERIOD_SET_ID, a system-generated unique identifier. The most critical user-facing column is PERIOD_SET_NAME, which stores the unique name of the calendar (e.g., "Calendar 2024", "4-4-5 Retail Calendar"). This name is the key referenced by foreign keys in dependent tables. Other important columns typically include LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY for audit purposes, along with descriptive fields. The table itself defines the calendar container, while the detailed period information (start date, end date, period type, etc.) is stored in the related GL_PERIODS table.

Common Use Cases and Queries

The primary use case is the setup and maintenance of accounting calendars, which is a prerequisite for defining a ledger in the General Ledger. Common reporting and validation queries involve listing calendars and their associations. For instance, to retrieve a list of all defined calendars, a simple SELECT statement such as SELECT period_set_name FROM gl.gl_period_sets ORDER BY period_set_name; is used. A more complex, practical query links this table to the Sets of Books or Ledgers to identify which calendar is assigned to a specific ledger: SELECT sob.name ledger_name, gps.period_set_name FROM gl_sets_of_books sob, gl_period_sets gps WHERE sob.period_set_name = gps.period_set_name;. This is essential for troubleshooting period-opening issues or validating configuration.

Related Objects

As indicated by the foreign key metadata, GL_PERIOD_SETS is a central reference point for several key tables. Its most significant relationship is with GL_SETS_OF_BOOKS (or the upgraded GL_LEDGERS in later setups), which assigns a calendar to a ledger. The GL_PERIODS table holds the detailed period definitions for each calendar. Other dependent objects include GL_DATE_PERIOD_MAP for date-to-period mapping, PA_PROJ_PERIOD_PROFILES in Projects, and GL_CONCURRENT_SCHEDULES. This wide range of foreign key references underscores the table's critical role as a shared master data source for fiscal timeframes across Oracle EBS financials and related modules.