Results for “igc_cc_acct_lines”

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

Overview

IGC_CC_ACCT_LINES is a transactional table in the Oracle EBS Contract Commitment (IGC) module, owned by the IGC schema. It stores the account-level distribution lines that belong to contract commitment headers. Where the parent contract commitment header defines the commercial agreement, each row in IGC_CC_ACCT_LINES represents an individual accounting or budgetary line against that agreement, carrying charge accounts, budget accounts, project and task references, tax treatment, encumbrance amounts, and withheld amounts. In Oracle EBS 12.1.1 and 12.2.2, this object is part of the IGC schema set that supports contract commitment creation, modification, and downstream commitment accounting.

From a Data Vault modeling perspective, the FK density heuristics classify this table as satellite-leaning. It behaves primarily as a descriptive satellite attached to a contract commitment header hub (via CC_HEADER_ID), with recursive self-referencing structure through PARENT_ACCT_LINE_ID. This classification should be treated as a modeling suggestion rather than a documented EBS construct.

Key Information Stored

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

• CC_ACCT_LINE_ID — the surrogate primary key (constraint IGCCAL_PK, unique index IGC_CC_ACCT_LINES_U1). This is the sole documented business-key candidate and is the primary join column to PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and IGC_CC_DET_PF_INTERFACE.
• CC_HEADER_ID — foreign key linking the line to its contract commitment header.
• PARENT_ACCT_LINE_ID and PARENT_HEADER_ID — recursive self-reference to establish line hierarchies and multi-tier agreements.
• CC_ACCT_LINE_NUM — the display line number.
• CC_CHARGE_CODE_COMBINATION_ID and CC_BUDGET_CODE_COMBINATION_ID — both FK to GL_CODE_COMBINATIONS, defining the charge account and budget account respectively.
• CC_ACCT_ENTERED_AMT and CC_ACCT_FUNC_AMT — the entered and functional currency amounts.
• CC_ACCT_BILLED_AMT and CC_ACCT_UNBILLED_AMT — billed vs. unbilled split.
• CC_ACCT_TAXABLE_FLAG and TAX_ID (FK to AP_TAX_CODES_ALL) — tax treatment.
• CC_ACCT_ENCMBRNC_AMT, CC_ACCT_ENCMBRNC_DATE, CC_ACCT_ENCMBRNC_STATUS — encumbrance tracking.
• PROJECT_ID (PA_PROJECTS_ALL), TASK_ID (PA_TASKS), EXPENDITURE_TYPE (PA_EXPENDITURE_TYPES), EXPENDITURE_ORG_ID, EXPENDITURE_ITEM_DATE — project accounting references.
• CC_FUNC_WITHHELD_AMT and CC_ENT_WITHHELD_AMT — functional and entered withholding amounts.

Standard EBS auditing columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and CONTEXT/ATTRIBUTE1–15 descriptive flexfields are also present.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all account lines for a contract commitment header, reconciling encumbered versus billed amounts by project, and auditing tax applicability.

Lines for a header:

• SELECT cal.cc_acct_line_id, cal.cc_acct_line_num, cal.cc_acct_func_amt, cal.cc_acct_en cmbrnc_status FROM igc.igc_cc_acct_lines cal WHERE cal.cc_header_id = :p_header_id ORDER BY cal.cc_acct_line_num;

Join to GL accounts for account description reporting:

• SELECT cal.cc_acct_line_id, gcc.concatenated_segments, cal.cc_acct_func_amt FROM igc.igc_cc_acct_lines cal JOIN gl_code_combinations_kfv gcc ON gcc.code_combination_id = cal.cc_charge_code_combination_id;

Project and task analysis uses PROJECT_ID and TASK_ID joined to PA_PROJECTS_ALL and PA_TASKS. Encumbrance reconciliation queries filter on CC_ACCT_ENCMBRNC_STATUS and compare CC_ACCT_ENCMBRNC_AMT against billed and unbilled amounts to identify unencumbered commitments.

Related Objects

• GL_CODE_COMBINATIONS — joined via CC_CHARGE_CODE_COMBINATION_ID and CC_BUDGET_CODE_COMBINATION_ID.
• AP_TAX_CODES_ALL — joined via TAX_ID for tax code detail.
• PA_PROJECTS_ALL (PROJECT_ID), PA_TASKS (TASK_ID), PA_EXPENDITURE_TYPES (EXPENDITURE_TYPE) — project accounting integration.
• PO_LINES_ALL and PO_LINE_LOCATIONS_ALL — linkage through CC_ACCT_LINE_ID, tying lines to purchasing documents.
• IGC_CC_DET_PF_INTERFACE — inbound interface referencing this table via INTERFACE_ACCT_LINE_ID.
• IGC_CC_ACCT_LINES (self) — recursive hierarchy through PARENT_ACCT_LINE_ID.

These relationships confirm the table's role as the central accounting detail store for Contract Commitment processing, connecting IGC to General Ledger, Payables, Projects, and Purchasing.