Results for “interface_header_id”

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

Overview

IGC_CC_ACCT_LINES_INTERFACE is the open interface (staging) table for IGC_CC_ACCT_LINES within the Oracle E-Business Suite IGC – Contract Commitment module. It serves as the inbound landing zone for accounting distribution lines associated with contract commitments before they are validated and transferred into the permanent IGC_CC_ACCT_LINES entity. In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the IGC schema and is classified as VALID. Because it acts as a temporary holding area populated by external feeds, batch programs, or integration APIs, records are inserted, processed, and typically purged after successful import. The documented physical schema in 12.2.2 shows 48 columns, with column-level DDL stored under the IGC.IGC_CC_ACCT_LINES_INTERFACE object entry.

From a data-modeling perspective, the metadata classifies this object as satellite-leaning based on its foreign-key structure. It behaves as a satellite (or staging mirror) of its permanent target rather than as an independent hub or a pure link, since its primary identity depends on the interface key and its descriptive attributes revolve around the accounting line transaction.

Key Information Stored

The surrogate primary key is INTERFACE_ACCT_LINE_ID, enforced by the ICALI_PK constraint and the unique index IGC_CC_ACCT_LINES_INTERFACE_U1. A second unique index, IGC_CC_ACCT_LINES_INTERFACE_U2, covers (INTERFACE_HEADER_ID, CC_ACCT_LINE_NUM) and represents the business-key candidate that ties a line to its header and line number.

• INTERFACE_HEADER_ID — foreign key to IGC_CC_HEADERS, grouping lines under the parent contract commitment header.
• INTERFACE_PARENT_HEADER_ID / INTERFACE_PARENT_ACCT_LINE_ID — self-referencing columns supporting hierarchical or parent-child line structures.
• CC_ACCT_LINE_NUM — the accounting line sequence within a header.
• CC_BUDGET_CODE_COMBINATION_ID / CC_CHARGE_CODE_COMBINATION_ID — foreign keys to GL_CODE_COMBINATIONS defining the budget and charge accounting flexfield combinations.
• CC_ACCT_ENTERED_AMT / CC_ACCT_FUNC_AMT — entered and functional currency amounts for the accounting line.
• CC_ACCT_BILLED_AMT / CC_ACCT_UNBILLED_AMT — billed vs. unbilled amount breakdown.
• CC_ACCT_ENCMBRNC_AMT, CC_ACCT_ENCMBRNC_DATE, CC_ACCT_ENCMBRNC_STATUS — encumbrance amount, date, and status.
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ORG_ID, EXPENDITURE_ITEM_DATE — project and expenditure attribution (foreign keys to PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES).
• TAX_ID and TAX_CLASSIF_CODE — tax code reference (AP_TAX_CODES_ALL) and classification.
• BATCH_ID and PROCESS_STATUS — control columns identifying the load batch and the import processing state.
• CC_FUNC_WITHHELD_AMT / CC_ENT_WITHHELD_AMT — withheld amounts in functional and entered currency.

The trailing ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT columns provide the standard Oracle descriptive flexfield extension area, while CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture audit trail data.

Common Use Cases and Queries

Typical usage centers on monitoring and troubleshooting the commitment accounting import. A common query retrieves all lines pending processing for a given batch:

• SELECT INTERFACE_ACCT_LINE_ID, INTERFACE_HEADER_ID, CC_ACCT_LINE_NUM, PROCESS_STATUS FROM IGC.IGC_CC_ACCT_LINES_INTERFACE WHERE BATCH_ID = :p_batch AND PROCESS_STATUS = 'NEW';
• Reconciliation of interface amounts to their accounting flexfields by joining CC_CHARGE_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS.
• Detecting orphaned lines where INTERFACE_HEADER_ID does not resolve to a valid IGC_CC_HEADERS row.
• Reporting on project-attributed commitments by joining PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE to the PA tables.
• Auditing encumbrance and withheld amounts prior to final posting, and diagnosing rows that fail validation so they can be corrected or purged.

Related Objects

The following objects are most significant to this interface table, based on documented foreign-key relationships:

• IGC_CC_ACCT_LINES — the permanent target table populated after successful import.
• IGC_CC_HEADERS — joined via INTERFACE_HEADER_ID, the parent commitment header.
• IGC_CC_ACCT_LINES_INTERFACE (self) — via INTERFACE_PARENT_ACCT_LINE_ID for hierarchical lines.
• PA_PROJECTS_ALL — via PROJECT_ID.
• PA_TASKS — via TASK_ID.
• PA_EXPENDITURE_TYPES — via EXPENDITURE_TYPE.
• GL_CODE_COMBINATIONS — via CC_BUDGET_CODE_COMBINATION_ID and CC_CHARGE_CODE_COMBINATION_ID.
• AP_TAX_CODES_ALL — via TAX_ID.
• PO_LINES_ALL and PO_LINE_LOCATIONS_ALL — referenced through INTERFACE_ACCT_LINE_ID for purchasing linkage.

Together these relationships confirm the table's role as a staging satellite fed by procurement, project, and tax data, ultimately converging into the IGC Contract Commitment accounting line model.