Search Results gl_info




Overview
Explore in AI Chat

Overview

APPS.GL_INFO is a utility package body within the Oracle E-Business Suite General Ledger schema. Its role is to centralize the retrieval of fundamental ledger configuration and period-related reference information that other General Ledger and subledger components require at runtime. Rather than embedding repetitive SELECT statements across forms, concurrent programs, and dependent packages, Oracle encapsulates the access logic within GL_INFO so that callers obtain consistent results for period names, ledger attributes, budget and encumbrance identifiers, lookup meanings, and consolidation definitions.

In ETRM metadata the object is classified with an API classification of OTHER, and the package body is marked VALID. It is documented as not being referenced by any database object directly, yet the metadata also records that it is referenced by 36 other packages within the APPS schema. This apparent contradiction is resolved by the distinction between compile-time dependencies and runtime calls: GL_INFO functions as a shared helper invoked dynamically by numerous General Ledger and related modules, making it a foundational but internal component rather than a public outward-facing API.

Key Procedures and Functions

Seven documented program units are exposed by the package body:

  • GL_GET_PERIOD_DATES — Returns the start and end dates associated with a given accounting period, allowing callers to derive the date range for reporting, validation, and transaction defaulting.
  • GL_GET_LEDGER_INFO — Retrieves descriptive and control attributes for a specified ledger, including its name, chart of accounts context, and related configuration values.
  • GL_GET_BUD_OR_ENC_NAME — Returns the name of either a budget or an encumbrance type, supporting user-friendly display of these identifiers.
  • GL_GET_LOOKUP_VALUE — Fetches the meaning or description of a value from the General Ledger lookup set, providing consistent lookup translation.
  • GL_GET_FIRST_PERIOD — Determines the first period defined for the relevant ledger or period set, typically used to establish opening balances or the earliest available accounting period.
  • GL_GET_FIRST_PERIOD_OF_QUARTER — Returns the first period belonging to a specified quarter, supporting quarterly reporting and close processes.
  • GL_GET_CONSOLIDATION_INFO — Retrieves consolidation definition details, enabling consolidation mapping and reporting logic.

The metadata does not document parameter lists for these units; accordingly, only their purpose is described here.

Tables Accessed

GL_INFO reads from several core General Ledger tables through APPS synonyms:

  • GL_LEDGERS — Source of ledger definition, currency, and chart of accounts information.
  • GL_PERIOD_STATUSES — Provides period names, statuses, and open/closed state used in period-date and first-period lookups.
  • GL_BUDGET_VERSIONS — Supplies budget version names for GL_GET_BUD_OR_ENC_NAME.
  • GL_ENCUMBRANCE_TYPES — Supplies encumbrance type names for the same function.
  • GL_CONSOLIDATION — Provides consolidation definition records.
  • GL_LOOKUPS — Supplies lookup code meanings used by GL_GET_LOOKUP_VALUE.

The package additionally depends on GL_MESSAGE and standard SYS constructs.

Usage Notes

GL_INFO is typically invoked from Oracle Forms, concurrent programs, and custom PL/SQL that needs reliable ledger and period reference data. Because it is called by 36 packages, it should be treated as a stable internal dependency; changes to its behavior can propagate widely across General Ledger and subledger functionality. Customizations should reference the package rather than duplicating its queries, and developers should validate any override against both 12.1.1 and 12.2.2 environments given the documented version coverage.