Search Results gl_mc_conversion_rules_u1

Overview

GL.GL_MC_CONVERSION_RULES_11I is a Multi-Currency (MC) setup table in the Oracle General Ledger schema. It defines the rules that govern how journal entries originating in a primary set of books are converted when they are replicated or aggregated into a reporting set of books. Each row associates a Reporting Option, a primary accounting book, a reporting accounting book, and a journal source/category combination with a specific conversion behaviour — most notably whether a transaction is converted or passed through unchanged, and the date basis and currency conversion type applied.

The table is a runtime setup and control object rather than a transactional ledger table. It is evaluated by the General Ledger Multi-Currency accounting programs whenever primary-book balances must be represented in a reporting currency, making it essential for multi-national consolidations, secondary ledgers, and statutory reporting in 12.1.1 and 12.2.2.

In Data Vault terms, the FK topology suggests this object behaves as a link: it resolves associations between independent hubs (Reporting Option, Primary Set of Books, Reporting Set of Books, Conversion Type) together with descriptive attributes (CONVERSION_RULE, DATE_BASIS, INHERIT_CONVERSION_TYPE) that describe the relationship itself. This is a heuristic modeling suggestion, not a declared Data Vault implementation.

Key Information Stored

The documented primary key is GL_MC_CONVERSION_RULES_PK, composed of REPORTING_OPTION_ID, PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, JE_SOURCE_NAME, and JE_CATEGORY_NAME. A separate unique index, GL_MC_CONVERSION_RULES_U1, provides an alternate business-key candidate on REPORTING_OPTION_ID, JE_SOURCE_NAME, and JE_CATEGORY_NAME. The most operationally significant columns are:

• REPORTING_OPTION_ID — the reporting option that owns the rule set; the primary foreign key into GL_MC_REPORTING_OPTIONS_11I.
• PRIMARY_SET_OF_BOOKS_ID — the source accounting book whose transactions are converted.
• REPORTING_SET_OF_BOOKS_ID — the target book that receives the converted entries.
• JE_SOURCE_NAME and JE_CATEGORY_NAME — the journal entry source and category to which the rule applies, allowing different treatment per transaction class.
• CONVERSION_RULE — the core decision value, indicating CONVERT or NOT CONVERT.
• DATE_BASIS — the date rule used to determine the rate date for the conversion.
• CONVERSION_TYPE — the currency conversion type (linked to GL_DAILY_CONVERSION_TYPES) used between currencies.
• INHERIT_CONVERSION_TYPE — a flag indicating whether the conversion type should be inherited from the original transaction rather than from this setup row.
• Standard Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) — audit tracking required by EBS.
• ATTRIBUTE_CATEGORY / ATTRIBUTE1–10 and GLOBAL_ATTRIBUTE_CATEGORY / GLOBAL_ATTRIBUTE1–10 — descriptive flexfield segments for customer-defined extensions.

Common Use Cases and Queries

Typical usage includes diagnosing why a primary-book journal was or was not converted into a reporting book, auditing conversion-rule coverage before running Multi-Currency processes, and validating statutory reporting configurations. A representative query joins the rules to the reporting options and books:

• SELECT r.REPORTING_OPTION_ID, r.JE_SOURCE_NAME, r.JE_CATEGORY_NAME, r.CONVERSION_RULE, r.DATE_BASIS, r.CONVERSION_TYPE FROM GL_MC_CONVERSION_RULES_11I r WHERE r.REPORTING_OPTION_ID = :p_option_id;
• Finding uncovered sources: ... WHERE r.CONVERSION_RULE = 'CONVERT' AND NOT EXISTS (SELECT 1 FROM GL_MC_CONVERSION_RULES_11I x WHERE x.REPORTING_OPTION_ID = r.REPORTING_OPTION_ID AND x.JE_SOURCE_NAME = r.JE_SOURCE_NAME);
• Reporting configured conversion types: ... WHERE r.INHERIT_CONVERSION_TYPE = 'N' AND r.CONVERSION_TYPE IS NOT NULL;
• Validating the unique business key against the primary key to confirm no duplicate source/category rules exist per reporting option.

Because the object carries an internal-use warning, direct DML should be avoided; queries are appropriate for investigation and reconciliation only.

Related Objects

The FK metadata identifies the following principal relationships, each joined on the named columns:

• GL.GL_MC_REPORTING_OPTIONS_11I via REPORTING_OPTION_ID — the parent reporting option definition.
• GL.GL_SETS_OF_BOOKS_11I via PRIMARY_SET_OF_BOOKS_ID — the source accounting book.
• GL.GL_SETS_OF_BOOKS_11I via REPORTING_SET_OF_BOOKS_ID — the target accounting book.
• GL.GL_DAILY_CONVERSION_TYPES via CONVERSION_TYPE — the currency rate type used for conversion.
• GL.GL_JE_SOURCES (by JE_SOURCE_NAME) and GL.GL_JE_CATEGORIES (by JE_CATEGORY_NAME) — the journal source and category reference data.
• GL_DAILY_CONVERSION_RATES — referenced indirectly through the resolved conversion type when conversion amounts are calculated.

These relationships establish GL_MC_CONVERSION_RULES_11I as the configuration bridge connecting reporting options, accounting books, and currency conversion types within the EBS multi-currency architecture.