Search Results quarter_num




Overview
Explore in AI Chat

Overview

IGC_CBC_JE_LINES_BAL_ALL_V is an APPS-owned reporting view within the IGC - Contract Commitment product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents aggregated journal entry line balances combined with period-to-date (PTD), quarter-to-date (QTD), and year-to-date (YTD) fund-checking balance figures derived from the General Ledger. The view is primarily consumed by Contract Commitment inquiry and reporting screens, where it supplies summarized debit, credit, and cumulative balance information for a given accounting flexfield combination, set of books, budget version, and encumbrance type. Because it exposes ENCUMBRANCE_TYPE_ID as a grouping attribute, it is a key object for users tracing how commitments and obligations are classified and reported against specific encumbrance types.

Underlying Base Objects

The view is defined over two documented referenced objects:

The view groups by PERIOD_NAME, QUARTER_NUM, PERIOD_NUM, ACTUAL_FLAG, SET_OF_BOOKS_ID, ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID, CODE_COMBINATION_ID, and PERIOD_YEAR. The MIN(AMOUNT_TYPE) and MIN(STATUS) aggregates collapse multiple source rows into one row per grouping combination.

Key Columns

  • ACTUAL_FLAG — distinguishes actual versus budget balances (typically A/B/E).
  • SET_OF_BOOKS_ID — the ledger or set of books against which balances are reported.
  • ENCUMBRANCE_TYPE_ID — identifier of the encumbrance type (e.g., commitment, obligation) that classifies the rows; central to commitment reporting and to the user's search term.
  • BUDGET_VERSION_ID — the budget version associated with the balances.
  • CODE_COMBINATION_ID — the accounting flexfield combination key.
  • ENTERED_DR / ENTERED_CR — summed entered debit and credit amounts.
  • PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM — the accounting period and its position within the fiscal year and quarter.
  • AMOUNT_TYPE, STATUS — minimized descriptive attributes from the source rows.
  • PTD_BALANCE, QTD_BALANCE, YTD_BALANCE — cumulative fund-checking balances computed by IGC_CBC_INQUIRY_PKG.GET_FC_BALANCES.

Common Use Cases and Queries

The view supports commitment balance inquiries, period-end reconciliation, and encumbrance-type analysis. A typical query filters by set of books, period, and encumbrance type:

SELECT period_name, encumbrance_type_id, code_combination_id, entered_dr, entered_cred, ptd_balance, qtd_balance, ytd_balance FROM apps.igc_cbc_je_lines_bal_all_v WHERE set_of_books_id = :p_sob AND period_name = :p_period AND encumbrance_type_id = :p_enc_type;

Analysts also aggregate by encumbrance type to compare cumulative commitments, or join to GL code combination and encumbrance type lookup tables for descriptive reporting. Because the YTD, QTD, and PTD columns invoke a PL/SQL function per row, queries should be filtered tightly on SET_OF_BOOKS_ID, PERIOD_NAME, and ENCUMBRANCE_TYPE_ID to limit the volume of function calls and preserve performance.