Search Results functional_period_net_dr




Overview
Explore in AI Chat

Overview

The view APPS.IGC_CBC_DETAIL_BAL_V is a reporting construct within the IGC — Contract Commitment product family of Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). It is defined in the APPS schema with a status of VALID and is described in Oracle's ETRM documentation as a "View based on je_lines_bal_all view for Account Inquiry Summary Balances block." In practice, this view surfaces detailed general ledger balance information — period-to-date, quarter-to-date, and year-to-date amounts — together with the descriptive attributes required by the Contract Commitment Account Inquiry form, specifically the Summary Balances block. It therefore serves as a presentation layer that denormalizes balance data sourced from the commitment accounting inquiry infrastructure and enriches it with set-of-books currency, budget, encumbrance, and summary template context.

Underlying Base Objects

The view does not read directly from base tables. It is defined over a single primary inline source, IGC_CBC_JE_LINES_BAL_ALL_V (aliased CBC), and joins to a set of descriptive reference objects. Documented referenced objects include GL_ACCOUNT_HIERARCHIES, GL_BUDGET_VERSIONS, GL_ENCUMBRANCE_TYPES, GL_LOOKUPS, GL_SETS_OF_BOOKS, and GL_SUMMARY_TEMPLATES, along with the package IGC_CBC_INQUIRY_PKG. Most of these are referenced through synonyms; GL_LOOKUPS and GL_SETS_OF_BOOKS are referenced as views. The joins are predominantly outer joins keyed on SET_OF_BOOKS_ID, CODE_COMBINATION_ID, ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID, and TEMPLATE_ID, ensuring that balance rows are preserved even when the corresponding descriptive metadata is absent. The join to GL_LOOKUPS is filtered on LOOKUP_TYPE = 'BATCH_TYPE', driving the derivation of the SHOW_ACTUAL_FLAG column.

Key Columns

The projection exposes both measure and dimension columns. Balance measures include FUNCTIONAL_PERIOD_NET_DR and FUNCTIONAL_PERIOD_NET_CR (entered debit and credit for the period), plus PTD_BALANCE, QTD_BALANCE, and YTD_BALANCE. Period context is carried by PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM, and QUARTER_NUM. Accounting identity is established through SET_OF_BOOKS_ID, CODE_COMBINATION_ID, ACTUAL_FLAG, and AMOUNT_TYPE. Descriptive enrichment is provided by CURRENCY_CODE, ENCUMBRANCE_TYPE, BUDGET_NAME, and TEMPLATE_NAME. Of specific interest to callers searching SHOW_ACTUAL_FLAG: this column is populated from GL_LOOKUPS.DESCRIPTION (aliased L1), where LOOKUP_TYPE = 'BATCH_TYPE' and LOOKUP_CODE = ACTUAL_FLAG. It therefore translates the raw ACTUAL_FLAG code into a user-readable label for display in the Account Inquiry Summary Balances block.

Common Use Cases and Queries

The view is typically queried when replicating or diagnosing the Account Inquiry Summary Balances display, or when extracting commitment accounting balances for reconciliation and downstream reporting. A representative query retrieving balances with the friendly actual-flag label is:

  • SELECT set_of_books_id, code_combination_id, period_name, actual_flag, show_actual_flag, ptd_balance, qtd_balance, ytd_balance FROM apps.igc_cbc_detail_bal_v WHERE set_of_books_id = :sob AND code_combination_id = :ccid;
  • SELECT period_name, show_actual_flag, budget_name, encumbrance_type, ytd_balance FROM apps.igc_cbc_detail_bal_v WHERE period_year = :yr ORDER BY period_num;
  • SELECT DISTINCT show_actual_flag, actual_flag FROM apps.igc_cbc_detail_bal_v; — to enumerate the lookup mappings surfaced by the BATCH_TYPE lookup.

Because the view relies on outer joins to GL_LOOKUPS, SHOW_ACTUAL_FLAG will return NULL where no matching BATCH_TYPE lookup code exists for the ACTUAL_FLAG value, so consumers should coalesce or otherwise defend against nulls when displaying this column.