Results for “glbv_gl_accounting_calendars”

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

Overview

GLBV_GL_ACCOUNTING_CALENDARS is a read-only General Ledger view that exposes the accounting period sets (calendars) defined in an Oracle EBS instance. Its purpose is to present a clean, minimal listing of period set names together with their descriptive text, so that users and downstream tools can reference the accounting calendars available for transaction and reporting purposes without querying the underlying setup table directly. In the ETRM documentation for release 12.2.2, the object is classified under the GL — General Ledger product and is marked as "Not implemented in this database," indicating that it is a view definition shipped with the application rather than a physical database object created during installation.

The view is particularly relevant to queries involving date ranges such as "From 01/12/2025 To 31/12/2025." Report parameters that prompt for a period or date range are typically validated against the accounting calendar, and this view supplies the list of calendar names used to drive such selections.

Underlying Base Objects

According to the documented view text, GLBV_GL_ACCOUNTING_CALENDARS is defined over the base setup table GL_PERIOD_SETS, aliased within the view as GL_ACCOUNTING_CALENDAR. The ETRM metadata lists no other referenced base objects. The view is created with the READ ONLY clause, which means it cannot be used to insert, update, or delete rows in the period set table.

GL_PERIOD_SETS stores the header-level definition of each accounting calendar: the unique period set name and its description. It is the parent of the period-level definitions held in GL_PERIODS, which carry the individual accounting period names, start dates, and end dates. Because GLBV_GL_ACCOUNTING_CALENDARS is built only over the header table, it exposes calendar-level information and does not itself provide period start or end dates. Date range logic, such as the 01/12/2025 to 31/12/2025 example, is resolved through GL_PERIODS, while the calendar identity comes from this view.

Key Columns

• ACCOUNTING_CALENDAR — The name of the accounting period set. This value corresponds to the PERIOD_SET_NAME column of GL_PERIOD_SETS and uniquely identifies each calendar defined in the ledger setup. It is the value typically entered or selected when a report or concurrent program asks for a calendar.
• DESCRIPTION — The descriptive text associated with the period set, taken from the DESCRIPTION column of GL_PERIOD_SETS. It provides a human-readable explanation of the calendar, such as the fiscal year convention or the calendar type in use.

No additional columns are documented. The view intentionally restricts the projection to these two attributes, keeping the interface stable and simple.

Common Use Cases and Queries

The primary use case is populating a list of valid accounting calendars for a parameter list of values, or resolving the description of a calendar referenced in a report. A straightforward listing of all calendars is produced with:

• SELECT accounting_calendar, description FROM glbv_gl_accounting_calendars ORDER BY accounting_calendar;
• SELECT accounting_calendar FROM glbv_gl_accounting_calendars WHERE description LIKE '%Fiscal%'; — locating calendars by descriptive keyword.
• SELECT p.period_name, p.start_date, p.end_date FROM gl_periods p, glbv_gl_accounting_calendars c WHERE p.period_set_name = c.accounting_calendar AND p.start_date >= TO_DATE('01/12/2025','DD/MM/YYYY') AND p.end_date <= TO_DATE('31/12/2025','DD/MM/YYYY'); — joining the view to GL_PERIODS to resolve the actual periods covered by a requested date range.

Because the view is read-only and light in structure, it is safe for reporting and integration use. All results shown above reflect the documented metadata for this object in Oracle EBS 12.2.2.