Results for “igc_cc_det_pf_interface”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGC_CC_DET_PF_INTERFACE table is an open interface (staging) table within the Oracle E-Business Suite IGC - Contract Commitment product module. It serves as the inbound landing area for detailed commitment and performance-funding records before they are validated and transformed into their final transactional destination within the Contract Commitment schema. The table is owned by the IGC schema and is documented as VALID in both EBS 12.1.1 and 12.2.2.

The interface follows a parent-child hierarchy within itself: detailed performance-funding (det_pf) lines carry a self-referencing pointer to a parent det_pf line, allowing multi-level commitment structures to be staged. Records also carry a foreign reference to account lines and a reference aligned to purchasing distribution lines, indicating the interface is designed to absorb commitment activity derived from purchasing distributions.

Based on the foreign key structure and the presence of a defined primary key with several descriptive and amount-bearing attributes, a Data Vault modeling heuristic suggests this table behaves as a satellite-leaning structure. Conceptually, it holds descriptive and numeric context (amounts, dates, statuses) around key entities (account line, distribution line, parent det_pf line), rather than serving purely as a hub or a link.

Key Information Stored

The table contains 36 documented columns. The most significant are:

• INTERFACE_DET_PF_LINE_ID — the surrogate primary key (constraint ICDPI_PK) and also the sole column of unique index U1, making it the primary reference handle for each staged detail line.
• INTERFACE_ACCT_LINE_ID — foreign key to the account lines; together with CC_DET_PF_LINE_NUM it forms unique index U2, a business-key candidate that identifies a detail line within an account line.
• CC_DET_PF_LINE_NUM — the line number sequencing a detail performance-funding line within its account line.
• INTERFACE_PAR_DET_PF_LINE_ID — self-referencing foreign key to the parent detail line, defining the hierarchical relationship.
• INTERFACE_PARENT_ACCT_LINE_ID — parent account line reference.
• CC_DET_PF_ENTERED_AMT and CC_DET_PF_FUNC_AMT — entered and functional currency amounts for the commitment detail.
• CC_DET_PF_BILLED_AMT and CC_DET_PF_UNBILLED_AMT — billed and unbilled splits of the commitment value.
• CC_DET_PF_ENCMBRNC_AMT, CC_DET_PF_ENCMBRNC_DATE, CC_DET_PF_ENCMBRNC_STATUS — encumbrance amount, date, and status flags.
• CC_DET_PF_DATE — the effective date of the performance-funding detail.
• PROCESS_STATUS and BATCH_ID — the interface processing state and the batch grouping identifier used by the import program.
• ATTRIBUTE1–15 and CONTEXT — the standard EBS DFF-flexfield columns for extensible descriptive data.

The surrogate key INTERFACE_DET_PF_LINE_ID is distinct from the business-key candidate formed by INTERFACE_ACCT_LINE_ID and CC_DET_PF_LINE_NUM (unique index U2); the two must not be conflated in lookups.

Common Use Cases and Queries

Typical uses of this table include monitoring unprocessed staged lines before the import/conversion program runs, diagnosing validation failures via PROCESS_STATUS, and reconciling staged commitment amounts against purchasing distributions.

A representative check on pending work is to group by batch and process status:

• SELECT BATCH_ID, PROCESS_STATUS, COUNT(*) FROM IGC.IGC_CC_DET_PF_INTERFACE GROUP BY BATCH_ID, PROCESS_STATUS;

To enumerate a batch of detail lines with their parent link and account reference:

• SELECT INTERFACE_DET_PF_LINE_ID, INTERFACE_ACCT_LINE_ID, CC_DET_PF_LINE_NUM, INTERFACE_PAR_DET_PF_LINE_ID, CC_DET_PF_ENTERED_AMT, CC_DET_PF_FUNC_AMT, PROCESS_STATUS FROM IGC.IGC_CC_DET_PF_INTERFACE WHERE BATCH_ID = :batch;

To reconcile the interface against purchasing distribution lines on the shared line identifier:

• SELECT i.INTERFACE_DET_PF_LINE_ID, p.PO_DISTRIBUTION_ID FROM IGC.IGC_CC_DET_PF_INTERFACE i, PO.PO_DISTRIBUTIONS_ALL p WHERE i.INTERFACE_DET_PF_LINE_ID = p.DISTRIBUTION_ID;

Hierarchical reporting can use a self-join on the parent pointer to reconstruct the staged commitment tree, and amount columns support DFF-driven variance reporting for billed versus unbilled exposure.

Related Objects

The most significant related objects, based on the documented foreign key and reference structure, are:

• IGC_CC_ACCT_LINES — referenced by IGC_CC_DET_PF_INTERFACE.INTERFACE_ACCT_LINE_ID; the immediate account-line context for each detail.
• PO_DISTRIBUTIONS_ALL (PO schema) — referenced by IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID; supplies the purchasing distribution linkage.
• IGC_CC_DET_PF_INTERFACE (self) — referenced by IGC_CC_DET_PF_INTERFACE.INTERFACE_PAR_DET_PF_LINE_ID; provides the parent/child detail hierarchy.
• Custom/standard import and conversion programs — the Contract Commitment processes that consume rows through PROCESS_STATUS and BATCH_ID and post validated records into the base commitment tables.
• IGC_CC_DET_PF and associated commitment base tables — the downstream destinations populated after successful interface processing.

Because the table is a staging object, no downstream tables reference it through the documented keys; it is a feeder within the Contract Commitment conversion architecture.