Search Results rel_summary_pf_encumber_amount




Overview
Explore in AI Chat

Overview

The view APPS.IGCFV_MC_REL_SUM_PAY_FORECASTS is a Business Intelligence System (BIS) view owned by the APPS schema within Oracle E-Business Suite. It is a component of the Oracle Contracts (IGC) module, specifically serving the Multiple Reporting Currencies (MRC) functionality for contract commitment release summary payment forecasts. In Oracle EBS 12.1.1 and 12.2.2, this view presents an alternative-currency representation of release-level summary payment forecast data, allowing the same underlying transactional facts to be reported in a currency other than the functional currency of the associated set of books.

The view is registered in FND Design Data as IGC.IGCFV_MC_REL_SUM_PAY_FORECASTS and carries a VALID status. Its role is primarily reporting and integration: downstream reports, conversions, and analytical queries can consume the MRC-adjusted release summary payment forecast rows without directly joining the base MRC and non-MRC tables. The "FV" naming convention signals a flex- and MRC-aware view, while "MC" denotes the multiple-currency context.

Underlying Base Objects

The view is defined over a set of synonyms that resolve to base tables and other views in the APPS schema. The documented dependencies are:

  • IGC_CC_DET_PF — detailed payment forecast data; the primary transactional source of forecast amounts.
  • IGC_CC_MC_DET_PF — the multiple-currency counterpart of the detailed payment forecast, supplying converted amounts and conversion attributes.
  • IGC_CC_ACCT_LINES — contract commitment account lines providing release and parent account line identifiers.
  • IGC_CC_HEADERS_ALL — contract commitment headers supplying contract numbers and identifiers.
  • IGC_CC_PERIODS_ALL — period definitions used to associate forecasts with accounting periods.
  • GL_SETS_OF_BOOKS_11I — set of books definition, supplying the functional currency and book identifiers.
  • GL_PERIODS — general ledger period calendar, supporting period year and date resolution.
  • HR_ALL_ORGANIZATION_UNITS — organization units supplying the organization name and identifier.

The relationships follow the standard contracts commitment model: releases are linked to parent contracts through account line and commitment identifiers, and the MRC view joins each functional-currency forecast to its reporting-currency equivalent.

Key Columns

The view exposes amount, conversion, period, contract, and organization attributes. Notable columns include:

Common Use Cases and Queries

Typical use cases include MRC reconciliation of encumbered forecast amounts, reporting on release-level payment forecasts in a reporting currency, and auditing conversion rates applied to contract commitments. The following query retrieves key amounts and conversion details for a given set of books:

  • SELECT release_contract_number, release_account_line_number, rel_summary_pf_encumber_amount, rel_sum_pf_functional_amount, currency_conversion_type, currency_conversion_rate, sets_of_books_name FROM apps.igcfv_mc_rel_sum_pay_forecasts WHERE set_of_books_id = :p_sob_id;
  • To reconcile functional versus reporting encumbrance: SELECT release_contract_commitment_id, rel_sum_pf_functional_amount, rel_summary_pf_encumber_amount, (rel_summary_pf_encumber_amount - rel_sum_pf_functional_amount) variance FROM apps.igcfv_mc_rel_sum_pay_forecasts;
  • To group encumbered forecast amounts by period and organization: SELECT period_year, organization_name, SUM(rel_summary_pf_encumber_amount) total_encumbered FROM apps.igcfv_mc_rel_sum_pay_forecasts GROUP BY period_year, organization_name;

Because the view already encapsulates the MRC join and conversion attributes, it is the preferred access point for reporting-currency contract commitment forecast analysis in both 12.1.1 and 12.2.2.