Search Results icdpi_pk

Overview

The IGC_CC_DET_PF_INTERFACE table is a core open interface table within the Oracle E-Business Suite Contract Commitment (IGC) module for versions 12.1.1 and 12.2.2. Its primary function is to serve as a staging area for the import of detailed performance obligation data from external systems or legacy applications. This table facilitates the integration of complex contract and commitment accounting data, specifically for performance obligations, into the Oracle EBS financial ecosystem. Data loaded into this interface table is subsequently processed by concurrent programs or application logic to populate the corresponding base transaction tables, ensuring data integrity and enabling proper accounting treatment for contractual commitments.

Key Information Stored

The table stores transactional line-level data for performance obligations pending import. Based on the provided metadata, the most critical column is INTERFACE_DET_PF_LINE_ID, which serves as the primary key (ICDPI_PK) to uniquely identify each interface record. Other significant foreign key columns define the record's relationships within the system. The INTERFACE_ACCT_LINE_ID links the performance line to its parent accounting line in the IGC_CC_ACCT_LINES table. The INTERFACE_DET_PF_LINE_ID also acts as a foreign key to PO_DISTRIBUTIONS_ALL, connecting the commitment data to its source procurement distribution. Furthermore, the INTERFACE_PAR_DET_PF_LINE_ID enables hierarchical relationships within the interface table itself, allowing for parent-child linkages between performance lines.

Common Use Cases and Queries

The primary use case is the batch loading of performance obligation data via custom scripts or data conversion programs. Administrators commonly query this table to monitor the status of interface data, identify records with errors, and troubleshoot failed import processes. A typical diagnostic query would join to related base tables to find unmatched records. For example, to find interface records not yet processed into the base tables, one might use a pattern such as:

• SELECT * FROM igc_cc_det_pf_interface intf WHERE NOT EXISTS (SELECT 1 FROM igc_cc_acct_lines al WHERE al.acct_line_id = intf.interface_acct_line_id);

Reporting often focuses on summarizing the volume and source of pending interface records, which is crucial for monitoring the health of the integration flow.

Related Objects

The table maintains defined foreign key relationships with several key transactional tables, as documented in the ETRM metadata:

• IGC_CC_ACCT_LINES: Joined via IGC_CC_DET_PF_INTERFACE.INTERFACE_ACCT_LINE_ID. This is the primary relationship linking the performance interface line to its parent accounting commitment line.
• PO_DISTRIBUTIONS_ALL: Joined via IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID. This connects the interface record to its originating procurement distribution, a common source for commitment data.
• Self-Referential Relationship: The table references itself via IGC_CC_DET_PF_INTERFACE.INTERFACE_PAR_DET_PF_LINE_ID. This allows for the representation of hierarchical or summarized performance obligation lines within the interface staging area.