Search Results detail_pf_date




Overview
Explore in AI Chat

Overview

IGCBV_CC_DETAIL_PAY_FORECASTS is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the IGC (Contract Commitment) product family within the ETRM (Enterprise Traffic and Revenue Management, also referenced as the Contracts/Commitment) module. The view presents detailed payment forecast line information associated with contract commitment account lines, exposing the dated, amount-bearing forecast records that drive encumbrance tracking and financial reporting.

The view is defined with a WITH READ ONLY clause, confirming that it serves purely as a reporting and integration surface. No DML is permissible against it. Its central role is to flatten the payment forecast detail table into a column-named, business-friendly projection that includes descriptive aliases (for example, DETAIL_PF_FUNCTIONAL_AMOUNT rather than the underlying CC_DET_PF_FUNC_AMT). This makes it suitable for use in Oracle Reports, BI Publisher data models, OBIEE/OAC repositories, custom concurrent programs, and third-party integration extracts.

Underlying Base Objects

The view is defined over a single documented base object: the synonym IGC_CC_DET_PF, which resolves in the APPS schema to the Contract Commitment detail payment forecast table. The defining query selects from IGC_CC_DET_PF CCDPF and applies a trivial WHERE 1=1 predicate before the WITH READ ONLY restriction. Because the view is a thin projection with no joins, no aggregation, and no filtering, row cardinality and primary key structure are inherited directly from the base table. Each row in the view corresponds one-to-one with a row in IGC_CC_DET_PF.

The view preserves the base table's identifier linkage through CC_ACCT_LINE_ID, which associates each payment forecast detail line with its parent contract commitment account line. This foreign-key relationship is the primary mechanism by which forecast detail data is joined to commitment headers, account distributions, and encumbrance records elsewhere in the IGC data model.

Key Columns

Common Use Cases and Queries

The view supports payment forecast reporting, encumbrance reconciliation, and commitment-to-invoice variance analysis. A typical query retrieves all forecast lines for a given account line:

  • SELECT detail_pf_line_number, detail_pf_date, detail_pf_functional_amount FROM igcbv_cc_detail_pay_forecasts WHERE account_line_id = :p_account_line_id ORDER BY detail_pf_date;
  • Period-based forecasting extracts, filtering by detail_pf_date between accounting period boundaries to populate cash-flow or commitment schedules.
  • Encumbrance analysis comparing DETAIL_PF_ENCUMBER_AMOUNT against DETAIL_PF_BILLED_AMOUNT and DETAIL_PF_UNBILLED_AMOUNT to identify unfunded or partially consumed commitments.
  • Integration extracts joining the view to commitment header tables via ACCOUNT_LINE_ID for downstream reporting repositories.

Because the view is read-only and projects the base table without transformation, it is a safe, stable interface for both ad hoc querying and production integration, insulating downstream consumers from underlying table column naming changes.