Search Results gl_mc_conversion_rules_11i




Overview
Explore in AI Chat

Overview

GL_MC_CONVERSION_RULES_11I is a General Ledger (GL) table in the Oracle E-Business Suite schema that stores multiple reporting currency conversion rules used by the Multiple Reporting Currencies (MRC) feature. In an MRC-enabled environment, a primary set of books maintains the transactional records, while one or more reporting sets of books maintain translated copies of those transactions in alternate reporting currencies. This table defines, at the granularity of journal source and journal category, how each reporting set of books derives its converted amounts from the corresponding primary set of books entries.

The object is part of the GL product family and is exposed in both Oracle EBS 12.1.1 and 12.2.2, with the documented physical schema containing 36 columns. Because of its composite structure, GL_MC_CONVERSION_RULES_11I primarily associates two sets of books and a reporting option, and it therefore maps most naturally to a link table in a heuristic Data Vault classification, resolving many-to-many relationships between reporting options, primary and reporting sets of books, and daily conversion types.

Key Information Stored

The table is keyed by the composite primary key GL_MC_CONVERSION_RULES_PK, comprising REPORTING_OPTION_ID, PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, JE_SOURCE_NAME, and JE_CATEGORY_NAME. A second unique index, GL_MC_CONVERSION_RULES_U1, covers REPORTING_OPTION_ID, JE_SOURCE_NAME, and JE_CATEGORY_NAME, which acts as a business-key candidate enforcing that only one conversion rule exists per reporting option per journal source and category.

  • REPORTING_OPTION_ID — identifies the MRC reporting option that owns the rule.
  • PRIMARY_SET_OF_BOOKS_ID — the source set of books supplying the original journal entries.
  • REPORTING_SET_OF_BOOKS_ID — the target set of books receiving the converted entries.
  • JE_SOURCE_NAME — the journal source (for example, Payables) to which the rule applies.
  • JE_CATEGORY_NAME — the journal category (for example, Invoice) to which the rule applies.
  • CONVERSION_RULE — defines whether conversion uses a specific rate type or inherits one.
  • CONVERSION_TYPE — the daily conversion type/rate type applied when a fixed rate is required; references GL_DAILY_CONVERSION_TYPES.
  • INHERIT_CONVERSION_TYPE — flag indicating whether the rate type is inherited from the source journal.
  • DATE_BASIS — determines whether conversion uses the journal date or the system date as the rate date.
  • Attribute columns (ATTRIBUTE1–10, GLOBAL_ATTRIBUTE1–10) — descriptive flexfield and global descriptive flexfield storage.
  • Audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) — standard EBS who-columns.

Common Use Cases and Queries

Administrators and developers query this table to audit the conversion configuration across MRC sets of books, to troubleshoot entries that fail to convert, and to migrate rule definitions between environments. A typical query joins the sets of books and conversion type tables to present a readable view of each rule:

  • List all rules for a reporting set of books: filter by REPORTING_SET_OF_BOOKS_ID and join GL_SETS_OF_BOOKS_11I twice (on PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID) to resolve set of books names.
  • Locate rate-type assignments: join CONVERSION_TYPE to GL_DAILY_CONVERSION_TYPES to confirm the rate type used for a given JE_SOURCE_NAME and JE_CATEGORY_NAME.
  • Reconcile reporting options: join REPORTING_OPTION_ID to GL_MC_REPORTING_OPTIONS_11I to verify which option a rule belongs to.
  • Detect missing or duplicate rules: use GL_MC_CONVERSION_RULES_U1 as the business key to identify gaps in source/category coverage that would default conversion behavior.

Sample pattern: SELECT r.JE_SOURCE_NAME, r.JE_CATEGORY_NAME, r.CONVERSION_RULE, r.CONVERSION_TYPE, r.DATE_BASIS FROM gl_mc_conversion_rules_11i r WHERE r.REPORTING_SET_OF_BOOKS_ID = :sob_id AND r.REPORTING_OPTION_ID = :option_id;

Related Objects

  • GL_MC_REPORTING_OPTIONS_11I — parent of the rule via GL_MC_CONVERSION_RULES_11I.REPORTING_OPTION_ID.
  • GL_SETS_OF_BOOKS_11I — referenced twice, through PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID.
  • GL_DAILY_CONVERSION_TYPES — supplies the rate type referenced by CONVERSION_TYPE.
  • GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES — the journal entities whose conversion into reporting sets of books these rules govern.
  • GL_MC_REPORTING_OPTIONS / MRC concurrent programs — the processing components that consume these rules during reporting currency translation.