Search Results igc_cc_det_pf_n1

Overview

IGC.IGC_CC_DET_PF is a transaction-level table in the Oracle E-Business Suite IGC (Contracts) schema that stores the current detail payment forecast for each account line of a contract commitment. It functions as a satellite structure in Oracle EBS 12.1.1 and 12.2.2, capturing the current state of individual payment forecast lines rather than the broad contract or account attributes held in its parent tables. Each account line defined in IGC_CC_ACCT_LINE may have one or more corresponding payment forecast lines, giving the table a one-to-many relationship to its account-line parent.

The table supports two important business functions: standard budgetary control (encumbrance) and the parent/child relationship between a parent contract commitment and its release contract commitments. When budgetary control is enabled on a parent contract, the payment forecast amount in functional currency is encumbered against the standard budget; CC_DET_PF_ENCMBRNC_AMT holds the total encumbered to date for the line. Where the forecast line relates to a release commitment, PARENT_ACCT_LINE_ID and PARENT_DET_PF_LINE_ID establish the link to the parent contract's forecast line, forming a self-referencing hierarchy. The table is physically stored in the APPS_TS_TX_DATA tablespace with PCT FREE 10, and its unique and non-unique indexes reside in APPS_TS_TX_IDX.

Key Information Stored

The primary surrogate key is CC_DET_PF_LINE_ID, documented as the detail payment forecast line defining column and enforced through primary key CCDPF_PK as well as the unique index IGC_CC_DET_PF_U1 (the documented business-key candidate). Surrounding the key are the most operationally significant columns:

• CC_DET_PF_LINE_NUM — the payment forecast line number within the account line.
• CC_ACCT_LINE_ID — the account line to which this forecast line belongs; the principal join column to IGC_CC_ACCT_LINE and the second-level defining column for the row.
• PARENT_ACCT_LINE_ID / PARENT_DET_PF_LINE_ID — the account line and detail payment forecast line of the parent contract commitment, used when the row represents a release contract commitment.
• CC_DET_PF_ENTERED_AMT / CC_DET_PF_FUNC_AMT — the entered-currency and functional-currency amounts of the forecast line.
• CC_DET_PF_BILLED_AMT / CC_DET_PF_UNBILLED_AMT — the billed and unbilled portions of the forecast line.
• CC_DET_PF_ENCMBRNC_AMT, CC_DET_PF_ENCMBRNC_DATE, CC_DET_PF_ENCMBRNC_STATUS — the encumbered amount, encumbrance date, and encumbrance status for the line under standard budgetary control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard EBS who-columns used by concurrent programs and audit reporting.

The remaining documented columns include CC_DET_PF_DATE and fifteen descriptive ATTRIBUTE columns plus CONTEXT, which follow standard EBS DFF conventions.

Common Use Cases and Queries

Typical reporting on this table includes payment forecast summaries by contract, encumbrance exposure analysis, and reconciliation of billed versus unbilled forecasts. A standard pattern joins the detail forecast to its account line and header:

• Forecast lines for an account line: SELECT * FROM igc.igc_cc_det_pf WHERE cc_acct_line_id = :acct_line_id ORDER BY cc_det_pf_line_num;
• Encumbered forecast totals: SELECT cc_acct_line_id, SUM(cc_det_pf_enCmbrnc_amt) FROM igc.igc_cc_det_pf GROUP BY cc_acct_line_id;
• Release-to-parent reconciliation: joining a release row back to its parent via d.parent_det_pf_line_id = p.cc_det_pf_line_id.

Budgetary control integrations use the index IGC_CC_DET_PF_N1 (CC_ACCT_LINE_ID) for line-level access and IGC_CC_DET_PF_N2 (PARENT_DET_PF_LINE_ID) for hierarchy traversal.

Related Objects

• IGC_CC_ACCT_LINE — parent table; join on IGC_CC_DET_PF.CC_ACCT_LINE_ID = IGC_CC_ACCT_LINE.CC_ACCT_LINE_ID.
• IGC_CC_DET_PF — self-referencing parent for release commitments; join on PARENT_DET_PF_LINE_ID = CC_DET_PF_LINE_ID.
• PO_DISTRIBUTIONS_ALL — referenced by the CC_DET_PF_LINE_ID relationship, tying forecast lines to purchasing distributions.
• IGC_CC_HEADERS / IGC_CC_COMMITMENTS — contract header and commitment context reached through the account line.
• IGC_CC_PAYMENT_FORECAST — the summarized (header-level) payment forecast counterpart to this detail table.