Search Results gl_mc_conversion_rules




Overview
Explore in AI Chat

Overview

GL_MC_CONVERSION_RULES is an Oracle General Ledger configuration table that defines multiple reporting currency conversion rules. In Oracle E-Business Suite 12.1.1 and 12.2.2, it supports the Multiple Reporting Currencies (MRC) feature, allowing a single primary ledger to be reported in one or more additional reporting currencies. Each row establishes the parameters that determine how journal entries originating in a primary set of books are converted and propagated into a reporting set of books.

The table is not implemented as a standalone object in every database; its presence depends on whether MRC is configured. Where implemented, its heuristic Data Vault classification is a link, mined from the foreign key structure. The table sits between reporting option definitions, primary and reporting ledgers, and conversion types, making it a natural junction (link) entity rather than a hub or satellite.

Key Information Stored

The table stores the association between a reporting option, source and target ledgers, and the conversion attributes that govern propagation. The documented primary key is GL_MC_CONVERSION_RULES_PK, a composite key composed of the following business-key columns:

Additional documented columns include CONVERSION_TYPE, a foreign key to GL_DAILY_CONVERSION_TYPES specifying the rate type (for example, Spot or Corporate) used to translate amounts. Because the primary key is composed entirely of business attributes, no separate surrogate primary key column is documented; the composite key itself is the candidate unique identifier. Together, these columns let administrators scope conversion behavior precisely by source and category rather than applying a single rule globally.

Common Use Cases and Queries

Typical uses include auditing which conversion type applies to a given journal source and category, verifying that every reporting ledger has coverage for all categories, and troubleshooting MRC conversion errors where entries fail to propagate. A representative query joins the rule to the conversion type and both ledgers:

  • SELECT r.REPORTING_OPTION_ID, r.JE_SOURCE_NAME, r.JE_CATEGORY_NAME, r.CONVERSION_TYPE FROM GL_MC_CONVERSION_RULES r WHERE r.PRIMARY_SET_OF_BOOKS_ID = :ledger_id;
  • Join to GL_SETS_OF_BOOKS (via PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID) to display ledger names.
  • Join to GL_DAILY_CONVERSION_TYPES on CONVERSION_TYPE to report the rate type description.
  • Join to GL_MC_REPORTING_OPTIONS on REPORTING_OPTION_ID to filter by enabled reporting options.

Related Objects

The most significant objects related to this table, based on documented foreign keys, are:

  • GL_MC_REPORTING_OPTIONS — joined on REPORTING_OPTION_ID; parent of the reporting option configuration.
  • GL_SETS_OF_BOOKS — referenced twice, once through PRIMARY_SET_OF_BOOKS_ID and once through REPORTING_SET_OF_BOOKS_ID, providing ledger definitions.
  • GL_DAILY_CONVERSION_TYPES — joined on CONVERSION_TYPE; supplies the currency rate type used for conversion.
  • GL_JE_SOURCES and GL_JE_CATEGORIES — reference the JE_SOURCE_NAME and JE_CATEGORY_NAME business keys, useful for validation reporting.

Because the table is a link entity, it is primarily consumed indirectly through MRC configuration forms and conversion programs rather than modified directly.