Search Results igc_cc_acct_lines

Overview

The IGC_CC_ACCT_LINES table is a core transactional data store within the Oracle E-Business Suite (EBS) Contract Commitment (IGC) module. It functions as the detailed accounting ledger for contracts, capturing the financial distribution of contract line amounts across various accounting dimensions. In the context of EBS 12.1.1 and 12.2.2, this table is essential for tracking how contract values are allocated to specific General Ledger (GL) accounts, projects, tasks, and tax codes. It serves as the critical link between the commercial contract terms defined in the system and the financial accounting and project costing subsystems, ensuring that commitments are properly recorded against budgets and expenditure categories.

Key Information Stored

The table's primary key is the CC_ACCT_LINE_ID, a unique identifier for each accounting distribution line. Its structure reveals the breadth of financial integration. Key columns include CC_CHARGE_CODE_COMBINATION_ID and CC_BUDGET_CODE_COMBINATION_ID, which store foreign keys to GL_CODE_COMBINATIONS, defining the charge and budget accounts respectively. For project-related contracts, it holds PROJECT_ID and TASK_ID linking to PA_PROJECTS_ALL and PA_TASKS. The TAX_ID column links to AP_TAX_CODES_ALL for tax calculations. The PARENT_ACCT_LINE_ID enables hierarchical distributions, allowing a parent line to be broken down into further detail. The table also references the contract header via CC_HEADER_ID and includes an EXPENDITURE_TYPE linked to PA_EXPENDITURE_TYPES for project costing granularity.

Common Use Cases and Queries

This table is central to financial reporting and audit trails for contracts. A common use case is generating a detailed account distribution report for a specific contract or a range of contracts, showing the GL account, project, and amount breakdown. Another critical scenario is tracing the accounting impact of contract modifications. Sample queries often join this table to GL_CODE_COMBINATIONS, PA_PROJECTS_ALL, and the main contract headers table (IGC_CC_HEADERS). For instance, to analyze budget consumption by project, one would aggregate amounts from IGC_CC_ACCT_LINES grouped by PROJECT_ID and the associated budget code combination. Troubleshooting integration issues with Purchasing (PO_LINES_ALL, PO_LINE_LOCATIONS_ALL) or the Project Funding interface (IGC_CC_DET_PF_INTERFACE) also requires querying this table to validate that accounting lines are correctly propagated to downstream systems.

Related Objects

As indicated by its foreign keys, IGC_CC_ACCT_LINES has extensive dependencies. It is a child table to the contract header, likely IGC_CC_HEADERS. Its primary integrations are with General Ledger (GL_CODE_COMBINATIONS), Projects (PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES), and Payables tax (AP_TAX_CODES_ALL). It provides source data for the Project Funding interface via IGC_CC_DET_PF_INTERFACE.INTERFACE_ACCT_LINE_ID. Furthermore, it is referenced by key Purchasing tables (PO_LINES_ALL, PO_LINE_LOCATIONS_ALL) on the CC_ACCT_LINE_ID column, highlighting its role in linking contract commitments to procurement actions. The self-referencing foreign key on PARENT_ACCT_LINE_ID indicates support for multi-level account line hierarchies within the table itself.