Search Results ccdpf_pk

Overview

IGC_CC_DET_PF is a table in the IGC (Contract Commitment) product of Oracle E-Business Suite, documented as VALID within the IGC schema. It stores detail payment forecast lines for contracts, functioning as the granular transactional layer beneath the contract commitment accounting model. Because contract commitments generate financial forecasts distributed across accounting periods, this table captures each individual forecast line — its amount, date, billed and unbilled splits, and encumbrance state — linked back to a parent contract accounting line. In ETRM 12.1.1 and 12.2.2, the physically documented schema defines 34 columns owned by IGC.

From a modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It is not a pure hub, since it carries descriptive and measurable attributes (amounts, dates, statuses) rather than acting solely as a key container. The self-referencing parent column and the reference to PO distributions reinforce its role as a dependent, attribute-rich entity attached to the contract accounting line.

Key Information Stored

The surrogate primary key is CCDPF_PK, enforced on the column CC_DET_PF_LINE_ID, which also appears as the unique business-key candidate via index IGC_CC_DET_PF_U1. Notable columns include:

• CC_DET_PF_LINE_ID — surrogate/primary key identifier for each forecast line.
• CC_DET_PF_LINE_NUM — the business line number ordering forecast detail entries.
• CC_ACCT_LINE_ID — foreign key linking the forecast line to its contract accounting line.
• PARENT_DET_PF_LINE_ID — self-referencing parent forecast line, supporting hierarchical line structures.
• PARENT_ACCT_LINE_ID — reference to the parent accounting line context.
• CC_DET_PF_ENTERED_AMT — the forecast amount as entered, in transaction currency.
• CC_DET_PF_FUNC_AMT — the forecast amount converted to functional (ledger) currency.
• CC_DET_PF_DATE — the forecast/payment date driving period distribution.
• CC_DET_PF_BILLED_AMT and CC_DET_PF_UNBILLED_AMT — split of the forecast amount into billed and unbilled portions.
• CC_DET_PF_ENCMBRNC_AMT, CC_DET_PF_ENCMBRNC_DATE, CC_DET_PF_ENCMBRNC_STATUS — encumbrance amount, date, and processing status.
• LAST_UPDATE_DATE, CREATED_BY, and the CONTEXT/ATTRIBUTE1–15 set — standard audit columns and DFF extensions.

Common Use Cases and Queries

Typical reporting includes payment forecast schedules by contract, billed-versus-unbilled analysis, and encumbrance tracking across periods. Analysts commonly aggregate functional amounts by forecast date and join upward to the accounting line for contract context.

• Forecast line detail by accounting line: SELECT cc_det_pf_line_id, cc_det_pf_date, cc_det_pf_func_amt FROM igc.igc_cc_det_pf WHERE cc_acct_line_id = :p_acct_line;
• Billed versus unbilled summary: SELECT SUM(cc_det_pf_billed_amt), SUM(cc_det_pf_unbilled_amt) FROM igc.igc_cc_det_pf;
• Outstanding encumbrances: filter on CC_DET_PF_ENCMBRNC_STATUS and CC_DET_PF_ENCMBRNC_AMT for open items.
• Hierarchy traversal using PARENT_DET_PF_LINE_ID to reconstruct nested forecast structures.

Related Objects

The metadata documents several principal relationships anchored on this table's keys:

• IGC_CC_DET_PF (self-reference) — PARENT_DET_PF_LINE_ID points back to CC_DET_PF_LINE_ID, enabling parent/child forecast hierarchies.
• CC_ACCT_LINE_ID — links each detail forecast line to its contract accounting line (mined reference to the IGC accounting line structure).
• PO_DISTRIBUTIONS_ALL — relationship involving CC_DET_PF_LINE_ID, tying forecast lines to purchasing distributions for commitment reconciliation.

Together these relationships position IGC_CC_DET_PF as the detail-level forecast repository supporting contract commitment accounting, reporting, and period distribution within the IGC module.