Search Results igc_cbc_je_lines




Overview
Explore in AI Chat

Overview

The IGC_CBC_JE_LINES table is a core transactional data store within the Oracle E-Business Suite (EBS) Contract Commitment (IGC) module. It functions as the detailed line-level repository for journal entries generated by the Commitment Budgetary Control (CBC) process. This table is critical for tracking the financial impact of contract commitments, obligations, and expenditures against defined budgets. Each record represents a single accounting line that, when aggregated with others in a batch, forms a complete budgetary journal entry. These entries are essential for enforcing budgetary compliance, managing funds, and maintaining accurate encumbrance accounting for contracts within the Oracle General Ledger.

Key Information Stored

The table's structure captures the full accounting context for each commitment journal line. Its primary key is a composite of CBC_JE_BATCH_ID and CBC_JE_LINE_NUM, linking the line to its parent batch header. Key transactional data includes the accounting code combination (CODE_COMBINATION_ID), the entered and accounted monetary amounts, and the period (PERIOD_SET_NAME, PERIOD_NAME). Critical control attributes identify the budget version (BUDGET_VERSION_ID) and encumbrance type (ENCUMBRANCE_TYPE_ID) against which the transaction is recorded. The table also stores the set of books (SET_OF_BOOKS_ID) and currency (CURRENCY_CODE) to define the ledger context. Additional columns typically track status, creation details, and descriptive information for the journal line.

Common Use Cases and Queries

Primary use cases involve auditing, reconciliation, and troubleshooting the budgetary accounting flow for contracts. Financial analysts may query this table to investigate budget variances or trace the detailed accounting behind summarized ledger balances. Common SQL patterns include joining to related General Ledger tables to retrieve descriptive information. For example, to review commitment journal lines for a specific budget:

  • SELECT jel.*, gcc.segment1, gbv.budget_name FROM igc_cbc_je_lines jel JOIN gl_code_combinations gcc ON jel.code_combination_id = gcc.code_combination_id JOIN gl_budget_versions gbv ON jel.budget_version_id = gbv.budget_version_id WHERE jel.budget_version_id = 1001;

Another critical query reconciles lines to their parent batch by joining with IGC_CBC_JE_BATCHES. Reporting use cases often aggregate amounts by account segment, period, or encumbrance type to analyze commitment trends and budget utilization.

Related Objects

IGC_CBC_JE_LINES maintains integral relationships with several key EBS objects, as defined by its foreign key constraints. The primary parent table is IGC_CBC_JE_BATCHES, which stores the batch-level header information. For descriptive flexfield and accounting context, it references core GL tables: GL_CODE_COMBINATIONS, GL_BUDGET_VERSIONS, GL_ENCUMBRANCE_TYPES, GL_SETS_OF_BOOKS, and GL_PERIODS. The currency is validated against FND_CURRENCIES. A significant child relationship exists with IGC_CBC_MC_JE_LINES, which stores the multiple currency representations of these journal lines, indicating the table's role in a multi-currency accounting environment.