Search Results gl_periods




Overview
Explore in AI Chat

Overview

The APPS.IGI_BUD_PROFILE_PERIODS_V view is a reporting and integration object within the IGI – Public Sector Financials International product family. It presents a denormalized, readable projection of budget profile period definitions that would otherwise require joining multiple Oracle General Ledger objects. The view resolves the accounting period names associated with each budget profile period by correlating stored budget profile rows against the current accounting calendar of the relevant set of books. In Oracle EBS 12.1.1 and 12.2.2, the view retains a status of VALID and is owned by the APPS schema.

Users searching on the term "gl_periods" typically arrive at this object because GL_PERIODS is the principal base object supplying the period name and period year attributes. The view is frequently consulted when tracing how period-number-based budget profile ratios map to human-readable period names.

Underlying Base Objects

The documented view metadata identifies four referenced base objects: GL_PERIODS (SYNONYM), GL_PERIOD_TYPES (SYNONYM), GL_SETS_OF_BOOKS (VIEW), and IGI_BUD_PROFILE_PERIODS (SYNONYM). IGI_BUD_PROFILE_PERIODS is the driving table holding the budget profile definition, including PROFILE_CODE, SET_OF_BOOKS_ID, PERIOD_NUMBER, and PERIOD_RATIO. GL_SETS_OF_BOOKS supplies the PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE, which determine the correct accounting calendar and period type for each set of books. GL_PERIODS provides the ENTERED_PERIOD_NAME and PERIOD_YEAR values used to resolve the period number into a displayed name.

The view text joins these objects on SET_OF_BOOKS_ID, PERIOD_SET_NAME, PERIOD_TYPE, PERIOD_NUM, and PERIOD_YEAR. A correlated subquery restricts the returned rows to the maximum PERIOD_YEAR available in GL_PERIODS for the applicable period set name, ensuring that only the most current calendar year is exposed. GL_PERIOD_TYPES is listed among the referenced objects in the ETRM metadata and supports period type validation within the underlying calendar model.

Key Columns

  • ROW_ID – The ROWID of the IGI_BUD_PROFILE_PERIODS record, exposed as the ROWID pseudocolumn for row-level identification.
  • PROFILE_CODE – The identifier of the budget profile to which the period row belongs.
  • SET_OF_BOOKS_ID – The ledger (set of books) against which the profile is defined.
  • PERIOD_NUMBER – The numeric period position within the accounting calendar, corresponding to GL_PERIODS.PERIOD_NUM.
  • PERIOD_RATIO – The budgetary distribution ratio assigned to the period within the profile.
  • PERIOD_NAME – The entered period name resolved from GL_PERIODS.ENTERED_PERIOD_NAME for the current period year.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard Oracle EBS audit columns inherited from IGI_BUD_PROFILE_PERIODS.

Common Use Cases and Queries

The view is commonly used to report budget profile period ratios in a period-name-readable form, or to validate that profile period numbers align with the current accounting calendar. A representative query is:

SELECT profile_code, set_of_books_id, period_number, period_name, period_ratio
FROM apps.igi_bud_profile_periods_v
WHERE set_of_books_id = :p_sob_id
ORDER BY profile_code, period_number;

Because the view filters on the maximum period year, it is well suited to current-year profile reviews. For historical comparisons, query the base IGI_BUD_PROFILE_PERIODS and GL_PERIODS objects directly, since the view is intentionally scoped to the latest calendar year available for each period set.

Oracle Proprietary, Confidential Information – Legal Notices apply.