Results for “igc_cbc_mc_je_lines”

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

Overview

The IGC_CBC_MC_JE_LINES table resides in the IGC schema and belongs to the Contract Commitment (IGC) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It is the multiple reporting currency extension of the commitment budgetary control journal entry lines infrastructure, storing a converted representation of each commitment journal line for every secondary reporting set of books defined in the ledger configuration. When a commitment journal entry is created, the primary amounts are recorded in the functional currency of the transaction's set of books; IGC_CBC_MC_JE_LINES captures the same line in each additional reporting currency, together with the rate, conversion type, and date used to derive those amounts.

The table is physically owned by IGC and is documented as VALID in the ETRM repository with eleven columns. Its primary key, IGC_CBC_MC_JE_LINES_PK, is composed of CBC_JE_BATCH_ID, CBC_JE_LINE_NUM, and REPORTING_SET_OF_BOOKS_ID. From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is a link: the table sits between the base journal line entity and the ledger dimension, resolving the many-to-many association between a commitment journal line and the reporting books in which it is reported.

Key Information Stored

The most significant columns fall into three groups — identity, currency conversion, and audit:

• CBC_JE_BATCH_ID — identifies the commitment budgetary control journal entry batch to which the line belongs.
• CBC_JE_LINE_NUM — the line number within that batch; together with CBC_JE_BATCH_ID it forms the composite foreign key to IGC_CBC_JE_LINES.
• REPORTING_SET_OF_BOOKS_ID — identifies the reporting ledger (set of books) for which this converted row is stored; foreign key to GL_SETS_OF_BOOKS.
• REPORTING_CURRENCY_CODE — the currency of the reporting ledger, used to express the converted debit and credit amounts.
• ENTERED_DR and ENTERED_CR — the debit and credit amounts converted into the reporting currency.
• CONVERSION_TYPE — the Oracle General Ledger conversion type (for example, Spot, Corporate, or User-defined) applied during conversion.
• CONVERSION_DATE — the date whose exchange rate was used for the conversion.
• CONVERSION_RATE — the actual rate applied to translate entered amounts into the reporting currency.
• CREATION_DATE and CREATED_BY — standard Oracle audit columns recording when and by which user the reporting-currency row was created.

The surrogate primary key IGC_CBC_MC_JE_LINES_PK is defined over CBC_JE_BATCH_ID, CBC_JE_LINE_NUM, and REPORTING_SET_OF_BOOKS_ID, making the combination of the base journal line and the reporting books the effective business key for uniqueness. No separate unique index is documented beyond this constraint.

Common Use Cases and Queries

Typical use cases include reporting commitment balances in secondary ledgers, reconciling converted amounts against General Ledger currency rates, and auditing the conversion methodology applied to a given batch. A representative query joining the multiple-currency lines to their base lines and to the ledger dimension is:

• SELECT m.CBC_JE_BATCH_ID, m.CBC_JE_LINE_NUM, m.REPORTING_SET_OF_BOOKS_ID, m.REPORTING_CURRENCY_CODE, m.ENTERED_DR, m.ENTERED_CR, m.CONVERSION_TYPE, m.CONVERSION_RATE FROM IGC.IGC_CBC_MC_JE_LINES m WHERE m.CBC_JE_BATCH_ID = :batch_id;
• Join to GL_SETS_OF_BOOKS on REPORTING_SET_OF_BOOKS_ID to obtain ledger name, chart of accounts, and currency for cross-ledger reporting.
• Join back to IGC_CBC_JE_LINES on CBC_JE_BATCH_ID and CBC_JE_LINE_NUM to compare entered versus converted amounts.
• Aggregate by REPORTING_CURRENCY_CODE and CONVERSION_DATE to produce commitment exposure summaries for reporting ledgers.

Related Objects

The following objects are most significant relative to IGC_CBC_MC_JE_LINES:

• IGC_CBC_JE_LINES — the parent commitment budgetary control journal entry lines table; referenced via CBC_JE_BATCH_ID and CBC_JE_LINE_NUM.
• GL_SETS_OF_BOOKS — the ledger definition table; referenced via REPORTING_SET_OF_BOOKS_ID.
• IGC_CBC_JE_BATCHES — the batch header controlling the journal entry batches to which these lines belong.
• GL_DAILY_CONVERSION_TYPES — supplies the valid conversion type values stored in CONVERSION_TYPE.
• GL_DAILY_RATES — the source of the rates recorded in CONVERSION_RATE and CONVERSION_DATE.
• IGC_CBC_MC_JE_BATCHES — the multiple-currency batch companion that aggregates these lines at header level.

Together these relationships confirm the table's role as the reporting-currency link between commitment journal lines and the ledger dimension, and provide the join path required for any multi-ledger commitment reporting solution in Oracle EBS 12.1.1 or 12.2.2.