Search Results parent_contract_number




Overview
Explore in AI Chat

Overview

IGCFV_MC_REL_SUM_PAY_FORECASTS is an APPS-owned database view within the Oracle E-Business Suite IGC – Contract Commitment module. It presents summarized pay forecast amounts for release (child) contract commitments, rolled up against their parent contract commitments and expressed per accounting period and set of books. The view is a reporting and integration artifact, designed to answer the question of how much has been forecast or encumbered on a release contract line during a given GL period, while simultaneously exposing the identity of the parent contract and parent account line to which that release rolls up. The "MC" prefix and the join through IGC_CC_MC_DET_PF indicate a multi-currency detail pay forecast source, with amounts aggregated separately for functional currency and encumbrance. Because the view resolves parent identifiers directly, it is commonly targeted by users searching for parent_contract_number, the column that exposes IGC_CC_HEADERS.CC_NUM of the parent commitment. The view is VALID and documented in ETRM for both 12.1.1 and 12.2.2, where its underlying objects are referenced through synonyms resolving to the ALL-suffixed base tables.

Underlying Base Objects

The view is defined over eight documented base objects, each accessed through a synonym in the APPS schema:

  • IGC_CC_MC_DET_PF — the multi-currency detail pay forecast table, supplying the functional and encumbrance amounts, conversion attributes, and set of books identifier.
  • IGC_CC_DET_PF — the detail pay forecast table, joined on CC_DET_PF_LINE_ID and supplying the forecast date used for period matching.
  • IGC_CC_ACCT_LINES — joined twice, once as the release account line (IGCCAL) and once as the parent account line (IGCCALP), providing the release and parent account line numbers and the header/line foreign keys that link child to parent.
  • IGC_CC_HEADERS_ALL — joined twice (IGC_CCH for the release, IGC_CCHP for the parent), supplying the release and parent contract numbers.
  • IGC_CC_PERIODS_ALL — supplies the organization and period name driving the organization and period-set joins.
  • GL_PERIODS — provides PERIOD_YEAR and the start/end dates against which the pay forecast date is bounded.
  • GL_SETS_OF_BOOKS_11I — supplies the set of books name and short name.
  • HR_ALL_ORGANIZATION_UNITS — supplies the organization name.

The parent-to-release relationship is established through IGCCAL.PARENT_ACCT_LINE_ID = IGCCALP.CC_ACCT_LINE_ID and IGCCAL.PARENT_HEADER_ID = IGC_CCHP.CC_HEADER_ID, which is precisely why parent_contract_number is available on every row.

Key Columns

Common Use Cases and Queries

Typical scenarios include parent-level rollup reporting of release pay forecasts, reconciliation of encumbrance against functional amounts, and integration extracts keyed by parent contract. A representative query filtering by the searched column is:

SELECT parent_contract_number, release_contract_number, release_account_line_number, period_year, rel_sum_pf_functional_amount, rel_summary_pf_encumber_amount FROM igcfv_mc_rel_sum_pay_forecasts WHERE parent_contract_number = :p_contract AND set_of_books_id = :p_sob;

Aggregation at the parent level follows the same pattern, grouping by parent_contract_number and period_year while summing the two amount columns. Because the view already performs the grouping internally over its join set, consumers should apply their own GROUP BY only when consolidating across release lines or organizations.