Search Results igc_cbc_mc_je_batches




Overview
Explore in AI Chat

Overview

The table IGC_CBC_MC_JE_BATCHES is a core transactional table within the Oracle E-Business Suite (EBS) module IGC (Contract Commitment). It is specifically designed to support the Multiple Reporting Currency (MRC) functionality for commitment budgetary control journal entry batches. In the context of EBS 12.1.1 and 12.2.2, this table enables organizations to maintain and report budgetary control transactions in multiple reporting ledgers, which are defined by different sets of books (SOBs) with potentially different currencies and accounting calendars. Its primary role is to store the relationship between a primary budgetary control batch and its corresponding representation in one or more reporting ledgers, ensuring that commitment and budgetary control data is accurately reflected across all required reporting currencies for compliance and management reporting.

Key Information Stored

The table's structure centers on linking a primary batch to a specific reporting ledger. The two most critical columns form its composite primary key. The CBC_JE_BATCH_ID column stores the unique identifier for the original commitment budgetary control journal entry batch from the primary set of books. The REPORTING_SET_OF_BOOKS_ID column holds the identifier for the reporting ledger (set of books) into which the batch amounts are translated. This column is a direct foreign key to the GL_SETS_OF_BOOKS table. Together, these columns ensure a one-to-many relationship where a single primary batch can have multiple records in this table, one for each reporting set of books in which it is represented.

Common Use Cases and Queries

The primary use case for this table is in reporting and reconciliation processes for commitment transactions across multiple ledgers. Financial analysts and accountants query this table to verify that all budgetary control batches have been successfully propagated to their designated reporting currencies. A common query pattern involves joining to the primary batch table (IGC_CBC_JE_BATCHES) and the sets of books table (GL_SETS_OF_BOOKS) to retrieve batch details alongside reporting ledger information. For example, to list all reporting ledgers for a specific batch, one might use: SELECT mc.reporting_set_of_books_id, sob.name FROM igc_cbc_mc_je_batches mc JOIN gl_sets_of_books sob ON mc.reporting_set_of_books_id = sob.set_of_books_id WHERE mc.cbc_je_batch_id = :batch_id;. This is essential for audit trails and ensuring data integrity in multi-currency and multi-ledger environments.

Related Objects

The table maintains documented foreign key relationships with two critical EBS tables, as per the provided metadata:

  • GL_SETS_OF_BOOKS: Joined via the column IGC_CBC_MC_JE_BATCHES.REPORTING_SET_OF_BOOKS_ID. This relationship provides the definition and configuration details of the reporting ledger.
  • IGC_CBC_JE_BATCHES: Joined via the column IGC_CBC_MC_JE_BATCHES.CBC_JE_BATCH_ID. This is the parent table containing the original commitment budgetary control batch data in the primary ledger.
These relationships are fundamental, as the IGC_CBC_MC_JE_BATCHES table acts as a junction table that links a primary transactional entity (a batch) to its reporting currency contexts.