Results for “igcbv_cbc_budget_balances”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGCBV_CBC_BUDGET_BALANCES view is a read-only reporting object in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases. It is owned by the APPS schema and is delivered as part of the IGC (Contract Commitment) product family. The view presents period-to-date budget balances captured against contract commitment journal lines, restricted to budget data. Its defining filter, ACTUAL_FLAG = 'B', ensures that only budget-type rows are surfaced, distinguishing it from views that report actual or encumbrance activity.

The object is defined WITH READ ONLY, reinforcing its role as a query surface for reporting and integration rather than a transactional entity. It is intended for inquiry and analysis of budget consumption and available budget within contract commitment structures, and it links commitment budget activity back to the General Ledger chart of accounts, sets of books, and budget versions. Because it is registered in the ETRM metadata as a VIEW of status VALID, it can be referenced directly by custom reports, discoverer workbooks, and BI Publisher data models without reimplementing the underlying balance and account derivation logic.

Underlying Base Objects

The view is built from a join over five documented base objects:

• IGC_CBC_JE_LINES_BAL_PTD_V (VIEW) — the primary driver, supplying period-to-date balances, amounts, and the budget version and code combination identifiers.
• GL_CODE_COMBINATIONS (SYNONYM) — provides the chart of accounts segments through an inner join on CODE_COMBINATION_ID.
• GL_SETS_OF_BOOKS (VIEW) — supplies the set of books name and short name via an outer join on SET_OF_BOOKS_ID.
• GL_BUDGET_VERSIONS (SYNONYM) — supplies the BUDGET_NAME through an outer join on BUDGET_VERSION_ID. This is the object most commonly associated with the user search term gl_budget_versions.
• IGC_CBC_INQUIRY_PKG (PACKAGE) — the ContrAct Commitment inquiry package that underpins the balance derivation logic referenced by the view.

The relationship to GL_BUDGET_VERSIONS is the key dimensional link: it resolves a BUDGET_VERSION_ID to its human-readable BUDGET_NAME. Because the join is outer, rows whose budget version is not found in GL_BUDGET_VERSIONS are retained with a null budget name.

Key Columns

• ACTUAL_FLAG — the balance type indicator; always 'B' for this view.
• "_KF:GL_ACCOUNT" — a key flexfield marker ('_KF:SQLGL:GL#:GL_CODE_COMBINATIONS') enabling the GL account flexfield to be resolved by the Flexfields engine.
• BUDGET_NAME / BUDGET_VERSION_ID — the budget version label and identifier from GL_BUDGET_VERSIONS and the balance source view.
• PERIOD_TO_DATE_BALANCE, ENTERED_DR, ENTERED_CR — the period-to-date amount and its debit and credit components.
• PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUMBER, PERIOD_SET_NAME — the accounting period context.
• SET_OF_BOOKS_ID, SETS_OF_BOOKS_NAME, SETS_OF_BOOKS_SHORT_NAME — the ledger identity.
• CODE_COMBINATION_ID — the GL account combination key.
• CURRENCY_CODE, AMOUNT_TYPE, STATUS, DETAIL_SUMMARY_CODE — supporting attributes describing the balance row.

Common Use Cases and Queries

Typical scenarios include budget-versus-commitment reporting by account and period, obtaining a period-to-date budget balance for a specific budget version, and joining to GL_BUDGET_VERSIONS to list budget names for commitment budget lines.

A representative query retrieving budget balances with their budget version names for a given ledger and period:

• SELECT b.budget_name, b.period_name, b.period_year, b.sets_of_books_name, b.period_to_date_balance, b.code_combination_id FROM igcbv_cbc_budget_balances b WHERE b.set_of_books_id = :p_sob_id AND b.period_name = :p_period AND b.budget_name IS NOT NULL ORDER BY b.budget_name, b.period_name;

Because the view is read-only and pre-joined, it is suitable for direct use in Discoverer and BI Publisher reports without additional joins to GL_BUDGET_VERSIONS, GL_SETS_OF_BOOKS, or GL_CODE_COMBINATIONS. For account-segment display, expose the GL account flexfield via the "_KF:GL_ACCOUNT" marker rather than querying GL_CODE_COMBINATIONS independently.