Search Results igc_cbc_mc_je_lines




Overview
Explore in AI Chat

Overview

The IGC_CBC_MC_JE_LINES table is a core data object within the Oracle E-Business Suite (EBS) module IGC (Contract Commitment). Its primary role is to store commitment budgetary control journal entry line information in multiple reporting currencies. This table is essential for organizations operating in a multi-currency environment, as it enables the tracking and reporting of budgetary commitments and expenditures across different sets of books or reporting currencies beyond the primary ledger's functional currency. It acts as a child table, holding the currency-converted amounts that correspond to the base commitment journal entries, thereby supporting comprehensive financial reporting and compliance requirements.

Key Information Stored

The table's structure is designed to link converted journal line amounts to specific reporting ledgers. Its primary key is a composite of three columns, ensuring uniqueness for each reporting currency line: CBC_JE_BATCH_ID and CBC_JE_LINE_NUM, which together identify the source journal entry line from the base commitment table, and REPORTING_SET_OF_BOOKS_ID, which identifies the specific reporting ledger for which the amount is converted. While the provided metadata does not list all columns, typical data stored would include the converted accounted amounts (e.g., accounted debit and credit) in the reporting currency, conversion rate details, and the reporting currency code, all tied to the specific reporting set of books.

Common Use Cases and Queries

The primary use case is generating financial reports for commitments and obligations in various reporting currencies for statutory, management, or consolidation purposes. Auditors or financial analysts may query this table to reconcile commitment balances across ledgers. A common SQL pattern involves joining this table to its parent to retrieve both the functional and reporting currency amounts for analysis.

  • Sample Query: Retrieving commitment journal lines with their converted reporting currency amounts for a specific reporting ledger. 
    SELECT base.CBC_JE_BATCH_ID,
       base.CBC_JE_LINE_NUM,
       base.accounted_dr,
       base.accounted_cr,
       mc.reporting_set_of_books_id,
       mc.accounted_dr AS reported_accounted_dr,
       mc.accounted_cr AS reported_accounted_cr
FROM   igc_cbc_je_lines base,
       igc_cbc_mc_je_lines mc
WHERE  mc.cbc_je_batch_id = base.cbc_je_batch_id
AND    mc.cbc_je_line_num = base.cbc_je_line_num
AND    mc.reporting_set_of_books_id = 1001;

Related Objects

The table maintains defined foreign key relationships with two critical EBS objects, as documented in the metadata.

  • IGC_CBC_JE_LINES: This is the primary parent table for base commitment budgetary control journal entry lines. The relationship is established via the columns CBC_JE_BATCH_ID and CBC_JE_LINE_NUM. Every record in IGC_CBC_MC_JE_LINES must correspond to a record in this table.
  • GL_SETS_OF_BOOKS: This General Ledger table defines the reporting ledger context. The relationship is via the REPORTING_SET_OF_BOOKS_ID column, which references GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID, ensuring that the converted amounts are associated with a valid and configured set of books.