Search Results igc_cc_smry_pf_version_v




Overview
Explore in AI Chat

Overview

IGC_CC_SMRY_PF_VERSION_V is a summary view in the Oracle E-Business Suite Applications (APPS) schema, owned by the Contract Commitment module within the IGC (Government Contract Accounting) product family. Its status is VALID, and it is available in both Oracle EBS 12.1.1 and 12.2.2 environments where the IGC/Contract Commitment functionality is licensed and installed.

The view presents aggregated commitment detail amounts stored at the "PF" (performance/commitment detail) level, summarized by accounting line, fiscal period year, and operating unit. Rather than exposing individual commitment transactions, it rolls up entered, functional, and encumbrance amounts so that reporting layers, concurrent programs, and downstream integrations can retrieve period-level totals efficiently. This makes it a reporting and consumption layer rather than a transaction-entry object; it is not designed for direct data manipulation.

Underlying Base Objects

The view is defined over two principal sources. The first is IGC_CC_DET_PF_VERSION_V, itself a view that supplies the underlying commitment detail rows at the PF level. The second is IGC_CC_PERIODS_V, a view of accounting periods that provides the period boundaries used to map each detail transaction date to a fiscal period.

The join condition links CCDPF.CC_DET_PF_DATE to the range defined by CP.START_DATE and CP.END_DATE, ensuring each detail amount is attributed to exactly one period. Additional documented base objects include the FND_GLOBAL package, which supplies session context such as the current operating unit (ORG_ID), and IGC_CC_VERSION_VIEW_PKG, the IGC package that governs the version-aware view logic. The view text groups results by CCDPF.CC_ACCT_LINE_ID, CP.PERIOD_YEAR, and CP.ORG_ID, producing one summarized row per accounting line per period year per operating unit.

Key Columns

  • CC_ACCT_LINE_ID – Identifier of the commitment accounting line; the primary grouping key connecting summarized totals back to a specific commitment line.
  • CC_FISCAL_YEAR – The fiscal year derived from CP.PERIOD_YEAR, used for period-based and year-based reporting.
  • ORG_ID – The operating unit identifier, sourced from the period record and session context, enabling multi-organization reporting and security filtering.
  • CC_SMRY_PF_ENT_AMT – Sum of entered commitment detail amounts (SUM of CC_DET_PF_ENTERED_AMT).
  • CC_SMRY_PF_FUNC_AMT – Sum of functional (ledger) currency commitment detail amounts (SUM of CC_DET_PF_FUNC_AMT).
  • CC_SMRY_PF_ENCMBRNC_AMT – Sum of encumbrance amounts associated with the commitment detail (SUM of CC_DET_PF_ENCMBRNC_AMT).

Common Use Cases and Queries

Typical scenarios include period-end commitment reporting, encumbrance roll-up analysis, reconciliation between entered and functional currency balances, and feeding downstream budget or funds-check reporting. A basic query retrieving all summarized commitment amounts for an operating unit and fiscal year follows.

SELECT cc_acct_line_id, cc_fiscal_year, org_id, cc_smry_pf_ent_amt, cc_smry_pf_func_amt, cc_smry_pf_encmbrnc_amt FROM apps.igc_cc_smry_pf_version_v WHERE org_id = :p_org_id AND cc_fiscal_year = :p_year ORDER BY cc_acct_line_id;

A comparison of entered versus functional amounts, useful for currency reconciliation, can be constructed as:

SELECT cc_acct_line_id, cc_fiscal_year, cc_smry_pf_ent_amt, cc_smry_pf_func_amt, cc_smry_pf_func_amt - cc_smry_pf_ent_amt AS variance FROM apps.igc_cc_smry_pf_version_v WHERE org_id = :p_org_id;

A period-level encumbrance summary by accounting line is obtained with:

SELECT cc_acct_line_id, cc_fiscal_year, SUM(cc_smry_pf_encmbrnc_amt) FROM apps.igc_cc_smry_pf_version_v WHERE org_id = :p_org_id GROUP BY cc_acct_line_id, cc_fiscal_year;

Because the view assembles data through IGC version-aware views and FND_GLOBAL session context, queries should always filter by ORG_ID and fiscal year to align results with the caller's operating unit responsibilities. This preserves the multi-organization security model and ensures summarized totals reconcile with the underlying commitment detail records.