Search Results quarter_num




Overview
Explore in AI Chat

Overview

APPS.IGC_CBC_JE_LINES_BAL_ALL_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the APPS schema. It is part of the Grants Accounting / Contracts and Budgeting component of the Public Sector (IGC) product family. The view consolidates journal entry lines into period-level balances and enriches them with currency-converted balance figures retrieved dynamically at query time. Its primary role is to present aggregated debit, credit, and derived PTD (period-to-date), QTD (quarter-to-date), and YTD (year-to-date) balances for a given account combination, ledger, budget version, and accounting period.

Because the monetary balance columns are populated via calls to a package function rather than stored columns, the view is effectively an inquiry-oriented reporting construct. It enables inquiry forms, reports, and dashboards that need summarized balances without materializing them in a permanent table.

Underlying Base Objects

The view is defined over two documented base objects:

  • IGC_CBC_JE_LINES (SYNONYM) — the principal data source supplying the raw journal entry line rows that the view aggregates. All grouping and summation occurs against this object.
  • IGC_CBC_INQUIRY_PKG (PACKAGE) — the PL/SQL package whose GET_FC_BALANCES function is invoked three times within the view's SELECT list to compute the PTD, QTD, and YTD balances.

The view does not eliminate duplicates across sources; instead, it groups IGC_CBC_JE_LINES rows by period, quarter, ledger, encumbrance type, budget version, account combination, period year, and the actual flag.

Key Columns

  • ACTUAL_FLAG — distinguishes actual vs. budget balances.
  • SET_OF_BOOKS_ID — the ledger (set of books) identifier in 12.1.1 / 12.2.2 terminology.
  • ENCUMBRANCE_TYPE_ID — identifies the encumbrance type for encumbrance balances.
  • BUDGET_VERSION_ID — the budget version defining which budget the balances pertain to; supplied by the user's search term and passed directly to GET_FC_BALANCES.
  • CODE_COMBINATION_ID — the account combination key.
  • PERIOD_NAME, PERIOD_NUM, PERIOD_YEAR, QUARTER_NUM — period and calendar attributes used for grouping and for the PTD/QTD/YTD calculations.
  • ENTERED_DR / ENTERED_CR — summed entered debit and credit amounts from IGC_CBC_JE_LINES.
  • AMOUNT_TYPE, STATUS — returned via MIN() aggregation, capturing the minimum value across the grouped rows.
  • PTD/QTD/YTD balance columns — calculated by IGC_CBC_INQUIRY_PKG.GET_FC_BALANCES using code_combination_id, set_of_books_id, budget_version_id, period_year, period_num, quarter_num, actual_flag, and encumbrance_type_id.

Common Use Cases and Queries

Typical uses include budget-vs-actual inquiry, encumbrance reporting, and grants funds-checking screens. The BUDGET_VERSION_ID column is frequently used as a filter, since it is a grouping key and a required argument to the balance function.

  • Filtering balances for a specific budget version, ledger, and account combination to reconcile PTD/QTD/YTD figures.
  • Joining to GL code combination and period views to translate IDs into descriptive account and period values.
  • Comparing actual and budget rows by filtering the ACTUAL_FLAG column.

Sample SQL:

  • SELECT period_year, period_name, budget_version_id, code_combination_id, SUM(entered_dr), SUM(entered_cr) FROM apps.igc_cbc_je_lines_bal_all_v WHERE budget_version_id = :p_version AND set_of_books_id = :p_ledger AND code_combination_id = :p_ccid GROUP BY period_year, period_name, budget_version_id, code_combination_id;
  • SELECT DISTINCT budget_version_id FROM apps.igc_cbc_je_lines_bal_all_v ORDER BY budget_version_id;

Because the PTD/QTD/YTD columns invoke a packaged function, queries should minimize returned row counts and bind the grouping columns to reduce function-execution overhead.