Results for “igc_cbc_je_lines”

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

Overview

IGC_CBC_JE_LINES is a table in the IGC (Contract Commitment) product family of Oracle E-Business Suite, holding the individual journal entry lines that support commitment budgetary control processing. Within the broader commitments and budgetary control architecture, this table captures the accounting-level detail of each commitment journal entry, storing the amounts, account assignments, period information, and status required for funds checking and downstream General Ledger integration. It is owned by the IGC schema and is present in both 12.1.1 and 12.2.2 environments, where it carries 63 documented columns.

From a modeling perspective, the mined foreign key structure suggests a satellite-leaning Data Vault classification. Because the table carries descriptive and transactional attributes linked to a composite parent key (the journal entry batch and line), it behaves less like an independent hub and more like a dependent detail structure. This classification is offered as a heuristic based on the FK topology, not an authoritative Oracle designation, but it is useful for teams building analytical or integration models around commitment control data.

Key Information Stored

The primary key is defined by the index IGC_CBCJEL_PK, whose composite business-key candidate columns are CBC_JE_BATCH_ID and CBC_JE_LINE_NUM. These are also enforced by the unique index IGC_CBC_JE_LINES_U1, making them the true business-key candidates; the batch identifier ties each line to its parent batch header, and the line number sequences lines within that batch.

The most significant columns include:

• CBC_JE_BATCH_ID / CBC_JE_LINE_NUM — composite business-key candidate linking each line to its parent batch.
• JE_SOURCE / JE_CATEGORY / ACTUAL_FLAG — journal source, category, and the actual/encumbrance indicator controlling how the entry is treated.
• CURRENCY_CODE — currency of the entered amounts, referencing FND_CURRENCIES.
• SET_OF_BOOKS_ID — the ledger (set of books) context, referencing GL_SETS_OF_BOOKS.
• CODE_COMBINATION_ID — the accounting flexfield account assignment, referencing GL_CODE_COMBINATIONS.
• ENCUMBRANCE_TYPE_ID / BUDGET_VERSION_ID — encumbrance classification and budgetary version references.
• PERIOD_SET_NAME / PERIOD_NAME / PERIOD_YEAR / PERIOD_NUM / QUARTER_NUM — accounting period positioning, referencing GL_PERIODS.
• ENTERED_DR / ENTERED_CR / DR_CR_CODE — debit and credit amounts and the balance direction.
• STATUS / EFFECTIVE_DATE / POSTED_DATE — lifecycle state and dates for processing and posting.
• DESCRIPTION / REFERENCE_1 through REFERENCE_10 — narrative and flexible reference attributes.

Common Use Cases and Queries

Typical usage centers on confirming that commitment journal lines were generated correctly, reconciling encumbrance balances, and diagnosing funds-check failures. A common pattern joins lines to their batch header:

• SELECT l.cbc_je_batch_id, l.cbc_je_line_num, l.entered_dr, l.entered_cr, l.status FROM igc_cbc_je_lines l WHERE l.cbc_je_batch_id = :batch_id ORDER BY l.cbc_je_line_num;
• Joining to GL_CODE_COMBINATIONS to resolve the account, and to GL_PERIODS to confirm posting period.
• Aggregating entered amounts by encumbrance type and budget version for budget-versus-commitment reporting.
• Filtering on STATUS and POSTED_DATE to identify unposted or incomplete commitment entries.

Related Objects

The table participates in a dense foreign-key network. The most significant related objects are:

• IGC_CBC_JE_BATCHES — parent batch header, joined on CBC_JE_BATCH_ID.
• GL_CODE_COMBINATIONS — account resolution via CODE_COMBINATION_ID.
• GL_SETS_OF_BOOKS — ledger context via SET_OF_BOOKS_ID.
• GL_PERIODS — period validation via PERIOD_SET_NAME and PERIOD_NAME.
• FND_CURRENCIES — currency reference via CURRENCY_CODE.
• GL_BUDGET_VERSIONS — budget version via BUDGET_VERSION_ID.
• GL_ENCUMBRANCE_TYPES — encumbrance classification via ENCUMBRANCE_TYPE_ID.
• IGC_CBC_MC_JE_LINES — child detail lines referencing this table on CBC_JE_BATCH_ID and CBC_JE_LINE_NUM.