Search Results detail_pf_functional_amount




Overview
Explore in AI Chat

Overview

IGCFV_CC_DETAIL_PAY_FORECASTS is an APPS-owned, read-only database view that exposes detailed payment forecast lines for Contract Commitment records within the Oracle E-Business Suite IGC (Contract Commitment) module. The view is documented as VALID in both EBS 12.1.1 and 12.2.2. It is a reporting and integration layer rather than a transactional table; its WITH READ ONLY clause confirms that consumers cannot issue DML against it. The object appears in the ETRM dictionary under the IGC - Contract Commitment product, and its purpose is to present the fine-grained forecast amounts (entered, functional, billed, unbilled, and encumbered) associated with each contract commitment accounting line, together with the metadata needed by Oracle Forms and Oracle Business Intelligence (OBIEE/BI Publisher) reporting. The column sought by the user, DETAIL_PF_FUNCTIONAL_AMOUNT, is a direct alias of CC_DET_PF_FUNC_AMT and represents the functional currency amount of each payment forecast line — the primary figure used for financial reporting and reconciliation when an organization transacts in more than one currency.

Underlying Base Objects

The view is defined over two base objects, both exposed to the APPS schema as synonyms:

  • IGC_CC_DET_PF (aliased CCDPF) — the Contract Commitment detail payment forecast table, which stores the actual forecast lines, amounts, encumbrance references, and audit columns.
  • IGC_CC_ACCT_LINES (aliased IGCCAL) — the Contract Commitment account line table, joined on CC_ACCT_LINE_ID to provide the account line number and to anchor each forecast line to its commitment accounting line.

The join condition is CCDPF.CC_ACCT_LINE_ID = IGCCAL.CC_ACCT_LINE_ID, an inner join establishing the one-to-many relationship between a commitment account line and its detail payment forecast lines. The view also carries Forms-style descriptor columns: _DF maps to the IGC_CC_DET_PFS block/field definition, and _LA:DETAIL_PF_ENCUMBR_STATUS resolves the encumbrance status through the FND_LOOKUPS lookup type IGC_CC_ENCUMBRANCE_STATUS.

Key Columns

Common Use Cases and Queries

Typical uses include payment forecast reporting, cash-flow analysis, and reconciliation of functional versus entered amounts. A standard query retrieving functional amounts per account line is:

SELECT v.ACCOUNT_LINE_NUMBER,
       v.DETAIL_PF_LINE_NUMBER,
       v.DETAIL_PF_DATE,
       v.DETAIL_PF_ENTERED_AMOUNT,
       v.DETAIL_PF_FUNCTIONAL_AMOUNT,
       v.DETAIL_PF_ENCUMBER_AMOUNT,
       v."_LA:DETAIL_PF_ENCUMBR_STATUS"
FROM   APPS.IGCFV_CC_DETAIL_PAY_FORECASTS v
WHERE  v.ACCOUNT_LINE_NUMBER = :account_line_number
ORDER  BY v.DETAIL_PF_LINE_NUMBER;

Aggregated cash-flow reporting by forecast date uses SUM over DETAIL_PF_FUNCTIONAL_AMOUNT grouped by DETAIL_PF_DATE. Because the view is read-only, all maintenance must occur through the IGC Contract Commitment Forms or public APIs against the base tables. Users should confirm the active operating unit and ledger context before interpreting functional amounts, since conversion depends on the ledger's functional currency.