Search Results funds_available_amt




Overview
Explore in AI Chat

Overview

APPS.IGC_CC_INTERFACE_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes the contents of the Funds Control (Budgetary Control) interface staging table used by the Grants Accounting / Contracts Commitment Control (IGC) product family. The view presents one row per commitment control transaction line staged for validation and posting into Oracle General Ledger, and is the principal access point used by concurrent programs, integrations, and custom extracts to inspect pending budgetary control activity before it is consumed by the Funds Checker engine. Because the object is defined as a view over the synonym IGC_CC_INTERFACE, it provides a stable, readable projection of the interface columns without requiring callers to reference the underlying physical table directly.

The view is documented in ETRM 12.2.2 with owner APPS and a single referenced base object, IGC_CC_INTERFACE (SYNONYM). No joins or filters are applied in the view text, so the row cardinality and grain equal those of the staging table itself.

Underlying Base Objects

The view is defined entirely over IGC_CC_INTERFACE, referenced through a synonym resolved in the APPS schema. The view performs a straight projection of the interface columns; there are no restrictive WHERE clauses, aggregation, or outer joins. As a result, any rows visible through the view are unvalidated or partially processed interface records awaiting acceptance or rejection by the budgetary control validation cycle. Administrators should treat the view as read-only for diagnostic purposes and avoid DML against it, as the base staging table is maintained by Oracle Funds Control programs.

Key Columns

Common Use Cases and Queries

Typical usage centers on reviewing funds-check outcomes and staging errors before posting. The following query identifies lines where funds availability has been computed:

SELECT CC_HEADER_ID, CC_ACCT_LINE_ID, CODE_COMBINATION_ID, BUDGET_AMT, COMMITMENT_ENCMBRNC_AMT, OBLIGATION_ENCMBRNC_AMT, FUNDS_AVAILABLE_AMT, CBC_RESULT_CODE, STATUS_CODE FROM APPS.IGC_CC_INTERFACE_V WHERE STATUS_CODE = 'N';

Integration developers frequently filter by set of books and period to reconcile amounts pending GL transfer, while support teams query by BATCH_ID or reference columns to trace a specific document. Because the view exposes funds availability alongside budget and encumbrance columns, it supports rapid variance analysis without joining multiple Funds Control tables.