Search Results igc_cbc_summary_bal_v




Overview
Explore in AI Chat

Overview

IGC_CBC_SUMMARY_BAL_V is an APPS-owned database view within the Oracle E-Business Suite IGC (Contract Commitment) module. As documented in the ETRM metadata, it is defined "based on je_lines_bal_all view for Account Inquiry Summary Balances block." In practical terms, the view presents aggregated general ledger commitment and budget balances organized by summary account hierarchy, enabling Oracle EBS reporting and integration routines to display summarized period, quarter, and year-to-date balances for the Contract Commitment Account Inquiry Summary Balances block.

The view carries a VALID status and exists under the APPS schema in both Oracle EBS 12.1.1 and 12.2.2 environments. It is particularly relevant to users searching for "qtd_balance," since one of its key columns exposes the quarterly balance (QTD_BALANCE) as an aggregated measure alongside PTD_BALANCE and YTD_BALANCE. By consolidating balances across detail code combinations into summary code combinations, the view reduces the volume of rows presented in inquiry screens while preserving meaningful financial totals.

Underlying Base Objects

The documented base objects referenced by the view are:

Joins to GL_ENCUMBRANCE_TYPES, GL_BUDGET_VERSIONS, GL_SUMMARY_TEMPLATES, and GL_LOOKUPS are outer joins (+), allowing balances to surface even when optional descriptive attributes are absent.

Key Columns

Common Use Cases and Queries

The view primarily supports the Contract Commitment Account Inquiry Summary Balances block, where users require period, quarter, and year-to-date totals rather than individual journal lines. A typical query retrieving quarterly balances for a given ledger and period is:

  • SELECT code_combination_id, period_name, quarter_num, SUM(qtd_balance) qtd_balance, SUM(ytd_balance) ytd_balance FROM igc_cbc_summary_bal_v WHERE set_of_books_id = :p_sob AND period_name = :p_period GROUP BY code_combination_id, period_name, quarter_num;

Other practical scenarios include reconciling budget versus encumbrance balances by budget version, reporting by summary template to align with account hierarchy rollups, and filtering by ACTUAL_FLAG to distinguish actual versus budget batches. Because balances are grouped at the summary code combination level, the view is well suited for inquiry screens and dashboard-style reporting where aggregated "qtd_balance" values are the primary requirement.