Search Results rel_summary_pf_entered_amount




Overview
Explore in AI Chat

Overview

APPS.IGCFV_CC_REL_SUM_PAY_FORECASTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, with FND Design Data registration under the IGC product (Oracle Contracts Commitment / Procurement Contracts). The view presents a summarized breakout of the contract commitment account line into the amounts expected to be paid out, expressed at the release summary level. In effect, it consolidates payment forecast data associated with a release (a downstream contract document tied to a parent commitment) into a period-based summary, providing the functional, entered, billed, unbilled, and encumbered amounts that drive commitment and payment forecasting in the Contracts Commitment module.

The object is documented as VALID in both ETRM 12.1.1 and 12.2.2 metadata. Because it is a view rather than a table, it carries no independent storage; it is a read-only projection intended for reporting and integration rather than transactional DML. The naming convention (IGCFV) indicates an IGC-formatted view, typical of Oracle's seeded reporting views that expose denormalized, user-friendly column names over normalized base tables.

Underlying Base Objects

The view is defined over the following documented base objects (all referenced as synonyms from APPS):

  • IGC_CC_ACCT_LINES — contract commitment account line records, providing the account line identifiers and amounts.
  • IGC_CC_DET_PF — detail payment forecast rows, the source of the per-period forecast amounts.
  • IGC_CC_HEADERS_ALL — contract commitment headers, supplying the contract numbers mapped to parent and release contracts.
  • IGC_CC_PERIODS_ALL — commitment period definitions used to align forecast amounts to accounting periods.
  • GL_PERIODS — General Ledger period calendar, providing the period year and period context.
  • HR_ALL_ORGANIZATION_UNITS — organization units, supplying organization name and organization identifier for operational reporting.

The ETRM documentation confirms that APPS.IGCFV_CC_REL_SUM_PAY_FORECASTS is not referenced by any database object, confirming its role as a terminal reporting view rather than a dependency in a larger object chain.

Key Columns

The view exposes sixteen columns. Notable among them for the search term rel_sum_pf_functional_amount is REL_SUM_PF_FUNCTIONAL_AMOUNT, a NUMBER column representing the release summary payment forecast amount expressed in the functional currency (the ledger currency of the operating unit). It is the functional-currency counterpart to REL_SUMMARY_PF_ENTERED_AMOUNT, which holds the amount in the entered (transaction) currency.

Common Use Cases and Queries

Typical usage involves reconciliation of payment forecasts to commitment liabilities, functional-currency reporting for procurement contracts, and period-by-period cash flow forecasting. A representative query isolating the functional amount by period and organization is:

SELECT period_year,
       organization_name,
       parent_contract_number,
       release_contract_number,
       rel_sum_pf_functional_amount,
       rel_summary_pf_billed_amount,
       rel_summary_pf_unbilled_amount
FROM   apps.igcfv_cc_rel_sum_pay_forecasts
WHERE  rel_sum_pf_functional_amount IS NOT NULL
ORDER  BY period_year, organization_name;

Because the view is a read-only projection, reports and interfaces should query it directly rather than attempting DML. Its functional-currency columns make it well suited for multi-currency commitment environments where entered-currency values require translation into ledger currency for financial reporting.