Search Results igc_cc_mc_acct_lines




Overview
Explore in AI Chat

Overview

IGC_CC_MC_ACCT_LINES is a table owned by the IGC schema within the Oracle E-Business Suite Contract Commitment (IGC) module. Its documented purpose is to hold multiple reporting currency (MRC) representations of account line data. In Oracle EBS environments where more than one set of books or reporting currency is configured, transactional and accounting amounts must be restated for each additional reporting currency. This table serves that function for contract commitment account lines, storing the converted functional, encumbrance, and withheld amounts alongside the conversion parameters used to derive them.

Because the table stores the currency-restated detail keyed to a parent account line and a set of books, it behaves as a dependent attribute store rather than a standalone transactional entity. Under the heuristic Data Vault classification supplied in the metadata, the object is marked standalone. A reasonable modeling suggestion, given the composite primary key of CC_ACCT_LINE_ID plus SET_OF_BOOKS_ID and the absence of mined foreign keys, is to treat it as a satellite-like structure that captures the per-set-of-books attributes of an account line. It is not modeled as a hub or link in the documented schema.

Key Information Stored

The documented physical schema in ETRM 12.2.2 lists eight columns. The most significant are:

  • CC_ACCT_LINE_ID — Identifier of the parent contract commitment account line. This is the first component of the composite primary key.
  • SET_OF_BOOKS_ID — The set of books (reporting currency context) for which the converted amounts apply. This is the second component of the composite primary key.
  • CC_ACCT_FUNC_AMT — The account line amount expressed in the functional currency of the associated set of books.
  • CC_ACCT_ENCMBRNC_AMT — The encumbrance amount restated for the set of books.
  • CC_FUNC_WITHHELD_AMT — The withheld amount in functional currency.
  • CONVERSION_TYPE — The Oracle currency conversion rate type (for example, Corporate or Spot) used for restatement.
  • CONVERSION_DATE — The effective date used to select the conversion rate.
  • CONVERSION_RATE — The actual rate applied when converting amounts into the set of books currency.

The surrogate-style primary key is defined by the constraint IGC_CC_MC_ACCT_LINES_PK on the column pair (CC_ACCT_LINE_ID, SET_OF_BOOKS_ID). The unique index IGC_CC_MC_ACCT_LINES_U1 covers the same two columns and is the documented business-key candidate, enforcing that a given account line may have only one converted record per set of books.

Common Use Cases and Queries

Typical reporting scenarios involve comparing functional amounts across reporting currencies or auditing the conversion parameters applied to commitments. A common query pattern joins this table to its parent account line and filters by set of books:

  • Retrieve all reporting-currency rows for a specific account line: SELECT set_of_books_id, cc_acct_func_amt, cc_acct_encmbrnc_amt, conversion_type, conversion_rate FROM igc.igc_cc_mc_acct_lines WHERE cc_acct_line_id = :line_id;
  • Reconcile converted versus primary amounts for a set of books and conversion date range.
  • Audit conversion rates used over time by grouping on CONVERSION_TYPE and CONVERSION_DATE.
  • Identify lines converted with a non-standard conversion type for compliance review.

Because no foreign keys are mined, join predicates must be constructed from the documented key columns rather than relying on enforced referential constraints.

Related Objects

The metadata documents no mined foreign keys and classifies the object as standalone. Logical relationships, however, exist through the composite key columns:

  • Parent contract commitment account line table — joined on CC_ACCT_LINE_ID to obtain the base (non-MRC) account line detail.
  • IGC_CC_ACCT_LINES — the corresponding primary-currency account line store that this MRC table supplements.
  • GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID to resolve reporting currency and ledger attributes.
  • GL_DAILY_CONVERSION_TYPES — referenced via CONVERSION_TYPE to validate rate type codes.
  • GL_DAILY_RATES — the source of rates resolved through CONVERSION_TYPE and CONVERSION_DATE.

These relationships are implied by the documented columns; integrators should confirm enabled foreign keys in the target instance before assuming enforced constraints.