Results for “fa_amount”

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

Overview

IGC_CBC_BAL_V is a reporting view owned by the APPS schema within the IGC (Contract Commitment) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. The view presents aggregated commitment, budget, actual, obligation, and funds-available balances for contract commitments, organized by set of books, budget version, and code combination. Its principal role is to expose balance data at two levels of granularity simultaneously: detail-level balances tied to the base accounting flexfield combinations, and summarized balances rolled up through the General Ledger account hierarchy. This dual presentation supports inquiry screens, funds-checking logic, and downstream reporting that requires either the transactional detail or the summarized hierarchy view.

The view is closely related to IGC_CBC_INQUIRY_PKG, the packaged API that drives Contract Commitment inquiry functionality in the EBS forms, and the "CBC" naming convention reflects the Commitment Budget Control processing area.

Underlying Base Objects

IGC_CBC_BAL_V is defined as a UNION of two SELECT statements. The first branch joins IGC_CBC_DET_BALANCES_V (itself a view, not a base table) to GL_ACCOUNT_HIERARCHIES, matching on DETAIL_CODE_COMBINATION_ID = CODE_COMBINATION_ID and on SET_OF_BOOKS_ID. This branch produces summarized rows keyed by the hierarchy's SUMMARY_CODE_COMBINATION_ID and aggregates the balance amounts using GROUP BY over set of books, summary combination, budget version, and template.

The second branch selects directly from IGC_CBC_DET_BALANCES_V without hierarchy rollup, emitting detail-level rows with a null template identifier via TO_NUMBER(''). The UNION therefore returns both detail and summarized records in a single result set. GL_ACCOUNT_HIERARCHIES appears as a synonym and IGC_CBC_DET_BALANCES_V is a supporting view; the documented referenced objects are GL_ACCOUNT_HIERARCHIES, IGC_CBC_DET_BALANCES_V, and IGC_CBC_INQUIRY_PKG.

Key Columns

• SET_OF_BOOKS_ID — identifies the ledger for the balance row.
• CODE_COMBINATION_ID — the accounting flexfield combination; summary combinations are substituted for rolled-up rows.
• BUDGET_VERSION_ID — the budget version against which commitment balances are measured.
• BUDGET_AMOUNT, COMM_AMOUNT, ACT_AMOUNT, OTH_AMOUNT, TOT_AMOUNT — the budget, committed, actual, other, and total amounts respectively.
• FA_AMOUNT — funds-available amount. This is the column users most often query (the search term "fa_amount" maps directly here), representing funds available after deducting commitments and actuals from budget.
• AMOUNT_TYPE — classification of the amount row (aggregated via MAX).
• PERIOD_NAME — the accounting period for the balance (aggregated via MAX).
• TEMPLATE_ID — the hierarchy template used for rollup; null for detail-level rows.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns (aggregated via MAX), useful for incremental extraction.

Common Use Cases and Queries

Typical usages include funds-availability inquiries, commitment balance reconciliation, and feeding reporting tools. Because detail and summary rows coexist, queries must filter on TEMPLATE_ID IS NULL for detail-only results or TEMPLATE_ID IS NOT NULL for hierarchy rollups.

To retrieve funds-available amounts for a ledger:

SELECT set_of_books_id, code_combination_id, budget_version_id, fa_amount, amount_type, period_name FROM apps.igc_cbc_bal_v WHERE set_of_books_id = :p_sob AND template_id IS NULL ORDER BY code_combination_id;

To obtain hierarchy summaries for a given template:

SELECT code_combination_id, SUM(fa_amount) fa_total FROM apps.igc_cbc_bal_v WHERE template_id = :p_template AND budget_version_id = :p_version GROUP BY code_combination_id;

Where the view is integrated with the Contract Commitment inquiry forms, IGC_CBC_INQUIRY_PKG reads these balances to present the commitment summary and available-funds figures to end users.