Search Results igcbv_cbc_mc_journal_lines




Overview
Explore in AI Chat

Overview

The IGCBV_CBC_MC_JOURNAL_LINES view is a reporting and integration object in the Oracle E-Business Suite (EBS) IGC – Contract Commitment module, owned by the APPS schema. It presents a denormalized, read-only projection of multi-currency contract commitment journal entry lines. The view joins journal line data to its associated batch and ledger definitions, exposing both transactional amounts and the ledger context required for financial reconciliation and reporting.

Because the view is defined WITH READ ONLY, it is intended strictly for query access and cannot be used for DML. It consolidates journal line detail with descriptive attributes from the underlying batch and the General Ledger set of books, enabling consumers to report on contract commitment journal activity without manually joining the base tables. This view is typically consumed by reports, concurrent programs, or downstream integrations needing commitment journal line detail in a single, stable interface.

Its role is important because contract commitment journal entries are recorded at the line level, while descriptive context — ledger name, batch name, and reporting currency — resides in separate parent entities. The view bridges this gap, making it a convenient single source for financial reporting and audit-style extracts.

Underlying Base Objects

The view is defined over four documented objects:

  • IGC_CBC_MC_JE_LINES (SYNONYM) — aliased as IGCMJL. The principal source of journal line amounts, currency conversion attributes, ledger identifiers, and references to the parent line and batch. The MC in the name denotes multi-currency handling.
  • IGC_CBC_JE_BATCHES (SYNONYM) — aliased as IGC_CBCJEB. Provides the batch name and the batch identifier that groups individual journal lines.
  • IGC_CBC_JE_LINES (SYNONYM) — aliased as IGC_CBCJEL. Joined by line number to establish the parent line relationship.
  • GL_SETS_OF_BOOKS (VIEW) — the General Ledger set of books definition, supplying the ledger name and short name.

The joins relate IGCMJL.CBC_JE_LINE_NUM to IGC_CBCJEL.CBC_JE_LINE_NUM, IGCMJL.CBC_JE_BATCH_ID to IGC_CBCJEB.CBC_JE_BATCH_ID, and IGCMJL.REPORTING_SET_OF_BOOKS_ID to GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID. This yields one row per multi-currency journal line, enriched with its parent line, batch, and ledger attributes.

Key Columns

Common Use Cases and Queries

Typical uses include commitment journal reconciliation, currency conversion auditing, and batch-level reporting. The following query extracts journal lines for a specific ledger and batch:

SELECT BATCH_NAME,
       JOURNAL_LINE_NUMBER,
       ENTERED_DR,
       ENTERED_CR,
       CURRENCY_CODE,
       CURRENCY_CONVERSION_RATE
FROM   APPS.IGCBV_CBC_MC_JOURNAL_LINES
WHERE  SET_OF_BOOKS_ID = :p_set_of_books_id
AND    BATCH_ID = :p_batch_id
ORDER BY JOURNAL_LINE_NUMBER;

To summarize entered amounts by ledger and currency for audit purposes:

SELECT SETS_OF_BOOKS_NAME,
       CURRENCY_CODE,
       SUM(ENTERED_DR) TOTAL_DR,
       SUM(ENTERED_CR) TOTAL_CR
FROM   APPS.IGCBV_CBC_MC_JOURNAL_LINES
GROUP BY SETS_OF_BOOKS_NAME, CURRENCY_CODE;

Because the view is read-only and pre-joined, it is well suited for ad-hoc reporting and downstream extracts without reconstructing the underlying multi-table relationships.