Search Results igc_cc_mc_headers_u1

Overview

IGC.IGC_CC_MC_HEADERS is a transactional table in the Oracle EBS Contracts Core (IGC) schema that stores reporting currency information for contract commitments. In the context of Oracle EBS 12.1.1 and 12.2.2, this table exists to persist the currency conversion attributes required to express a contract commitment in one or more reporting sets of books, distinct from the operational ledger under which the contract was originally recorded. The table is registered under FND Design Data as IGC.IGC_CC_MC_HEADERS and is documented with a VALID status, confirming it is an active, supported object within the ETRM 12.2.2 physical schema.

Heuristically, the metadata classifies this object as a standalone entity from a Data Vault perspective. In practical modeling terms it behaves as a satellite-like descriptive table attached to the contract commitment hub, since it records context-dependent conversion attributes (rate, date, type) that vary by reporting set of books rather than by the contract itself. Analysts should treat it as an optional detail table keyed primarily by the contract commitment identifier.

Key Information Stored

The table stores five documented columns. The two principal defining columns form the composite primary key, IGC_CC_MC_HEADERS_PK, and also back the unique index IGC_CC_MC_HEADERS_U1.

• CC_HEADER_ID (NUMBER) — The contract commitment defining column. This is the foreign-key-style link back to the parent contract header and is the leading column in both the primary key and the unique index.
• SET_OF_BOOKS_ID (NUMBER, length 15) — The reporting set of books defining column. This is the second component of the composite key and the discriminator that allows multiple rows per contract, one per reporting set of books defined.
• CONVERSION_TYPE (VARCHAR2, length 30) — The currency conversion type applied when translating the commitment between currencies.
• CONVERSION_DATE (DATE) — The effective date on which the conversion rate is applied.
• CONVERSION_RATE (NUMBER) — The numeric rate used to convert between currencies for the associated reporting set of books.

The business-key candidate is the unique index IGC_CC_MC_HEADERS_U1 over (CC_HEADER_ID, SET_OF_BOOKS_ID), which is functionally equivalent to the declared primary key. This composite identifier guarantees that any given contract has at most one conversion record per reporting set of books.

Common Use Cases and Queries

The most common use case is retrieving the converted reporting-currency amounts for a contract commitment. Because the table may hold several rows per contract, queries typically filter on both CC_HEADER_ID and SET_OF_BOOKS_ID to isolate the relevant reporting set of books.

• Retrieve all reporting-currency records for a single contract:
  SELECT CC_HEADER_ID, SET_OF_BOOKS_ID, CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE FROM IGC.IGC_CC_MC_HEADERS WHERE CC_HEADER_ID = :cc_header_id;
• Retrieve the conversion record for a specific contract and reporting set of books:
  ... WHERE CC_HEADER_ID = :cc_header_id AND SET_OF_BOOKS_ID = :sob_id;
• Report rate usage across contracts by conversion type for a given date:
  SELECT CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE FROM IGC.IGC_CC_MC_HEADERS WHERE CONVERSION_DATE BETWEEN :from_date AND :to_date;

These patterns support reconciliation of reporting-currency balances, audit of conversion rates applied to commitments, and multi-set-of-books reporting extracts.

Related Objects

Relationship data identifies IGC_CC_MC_HEADERS as standalone, meaning it does not declare outgoing foreign keys and is not referenced by other database objects in the documented dependency set. The most significant related objects are therefore derived from its documented parent and its APPS synonym layer.

• IGC.IGC_CC_HEADERS — The contract commitment header table. The optional one-to-many relationship runs from IGC_CC_HEADERS to this table, joined on CC_HEADER_ID.
• APPS.IGC_CC_MC_HEADERS — The APPS synonym that exposes the table to the application layer and to reporting tools.
• FND Design Data IGC.IGC_CC_MC_HEADERS — The registered design data entry governing the object definition and its VALID status.
• FND_SETS_OF_BOOKS — The set-of-books definition source that corresponds to the SET_OF_BOOKS_ID values, one record per reporting set of books.
• GL_DAILY_CONVERSION_TYPES / GL_DAILY_RATES — The conversion type and rate reference sources underpinning CONVERSION_TYPE, CONVERSION_DATE, and CONVERSION_RATE.