Search Results gl_mc_reporting_options_11i

Overview

GL.GL_MC_REPORTING_OPTIONS_11I is a General Ledger configuration table that stores multiple reporting currency conversion options, keyed by application, operating unit, and asset book. It defines how Oracle EBS converts balances from a primary set of books into one or more reporting sets of books, capturing the currency pairing, the daily conversion type, the rate date basis, and the effective date window during which the rule is active. The table is central to the Multiple Reporting Currencies (MRC) feature in releases 12.1.1 and 12.2.2, and it drives the automated remeasurement and translation of journal entries into reporting currencies.

Within a Data Vault modeling heuristic, the documented foreign-key profile classifies this table as satellite-leaning. It carries descriptive, versioned attributes (dates, flags, conversion parameters) that qualify parent business keys, rather than acting purely as a hub or link. This classification is a modeling suggestion and not an EBS-imposed constraint.

Key Information Stored

The table documents 42 columns. The most significant include:

REPORTING_OPTION_ID — surrogate primary key, enforced by GL_MC_REPORTING_OPTIONS_PK. A unique index GL_MC_REPORTING_OPTIONS_U1 on the same column is the documented business-key candidate.
PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID — the source and target sets of books, both referencing GL_SETS_OF_BOOKS_11I.
AP_SECONDARY_SET_OF_BOOKS_ID — links Payables to a secondary set of books.
PRIMARY_CURRENCY_CODE and REPORTING_CURRENCY_CODE — the currency pair, validated against FND_CURRENCIES.
CONVERSION_TYPE — the rate type referencing GL_DAILY_CONVERSION_TYPES; INHERIT_CONVERSION_TYPE determines inheritance behavior.
APPLICATION_ID, ORG_ID, and FA_BOOK_TYPE_CODE — scope the option to an application, operating unit, and Fixed Assets book.
DATE_BASIS — controls which date drives rate selection.
ENABLED_FLAG, START_DATE, and END_DATE — manage the active window for each option.
Standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus ATTRIBUTE1–10 and GLOBAL_ATTRIBUTE1–10 descriptors.

Common Use Cases and Queries

Typical uses include auditing MRC configuration, verifying that a set-of-books pair is properly mapped, and diagnosing conversion failures. For example, to list active options for a primary set of books:

SELECT reporting_option_id, primary_set_of_books_id, reporting_set_of_books_id, conversion_type, date_basis, enabled_flag FROM gl_mc_reporting_options_11i WHERE primary_set_of_books_id = :p_sob AND enabled_flag = 'Y';
Joining to GL_SETS_OF_BOOKS_11I resolves set-of-books names for both the primary and reporting sides.
Filtering on START_DATE / END_DATE validates whether an option was active when a conversion was processed.

Related Objects

GL_SETS_OF_BOOKS_11I — referenced by PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, and AP_SECONDARY_SET_OF_BOOKS_ID.
GL_DAILY_CONVERSION_TYPES — referenced by CONVERSION_TYPE.
FND_CURRENCIES — referenced by PRIMARY_CURRENCY_CODE and REPORTING_CURRENCY_CODE.
GL_MC_CONVERSION_RULES_11I — child table joined on REPORTING_OPTION_ID, holding the detailed conversion rules derived from each option.

Table: GL_MC_REPORTING_OPTIONS_11I 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_REPORTING_OPTIONS_11I, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID, product: GL - General Ledger , description: Multiple reporting currency conversion options by application/operating unit/asset book , implementation_dba_data: GL.GL_MC_REPORTING_OPTIONS_11I ,
Table: GL_MC_REPORTING_OPTIONS_11I 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_REPORTING_OPTIONS_11I, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID, product: GL - General Ledger , description: Multiple reporting currency conversion options by application/operating unit/asset book , implementation_dba_data: GL.GL_MC_REPORTING_OPTIONS_11I ,
SYNONYM: APPS.GL_MC_REPORTING_OPTIONS_11I 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID,
SYNONYM: APPS.GL_MC_REPORTING_OPTIONS_11I 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID,
VIEW: GL.GL_MC_REPORTING_OPTIONS_11I# 12.2.2
owner:GL, object_type:VIEW, object_name:GL_MC_REPORTING_OPTIONS_11I#, status:VALID,
VIEW: GL.GL_MC_REPORTING_OPTIONS_11I# 12.2.2
Table: GL_MC_CONVERSION_RULES_11I 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_CONVERSION_RULES_11I, object_name:GL_MC_CONVERSION_RULES_11I, status:VALID, product: GL - General Ledger , description: Multiple reporting currency conversion rules for Oracle General Ledger , implementation_dba_data: GL.GL_MC_CONVERSION_RULES_11I ,
Table: GL_MC_CONVERSION_RULES_11I 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_CONVERSION_RULES_11I, object_name:GL_MC_CONVERSION_RULES_11I, status:VALID, product: GL - General Ledger , description: Multiple reporting currency conversion rules for Oracle General Ledger , implementation_dba_data: GL.GL_MC_CONVERSION_RULES_11I ,
Table: GL_SETS_OF_BOOKS_11I 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SETS_OF_BOOKS_11I, object_name:GL_SETS_OF_BOOKS_11I, status:VALID, product: GL - General Ledger , description: Set of books definitions , implementation_dba_data: GL.GL_SETS_OF_BOOKS_11I ,
Table: GL_SETS_OF_BOOKS_11I 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SETS_OF_BOOKS_11I, object_name:GL_SETS_OF_BOOKS_11I, status:VALID, product: GL - General Ledger , description: Set of books definitions , implementation_dba_data: GL.GL_SETS_OF_BOOKS_11I ,
PACKAGE BODY: APPS.GL_AS_POST_UPG_CHK_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GL_AS_POST_UPG_CHK_PKG, status:VALID,
PACKAGE BODY: APPS.GL_AS_POST_UPG_CHK_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GL_AS_POST_UPG_CHK_PKG, status:VALID,
PACKAGE BODY: APPS.PA_XLA_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_XLA_UPGRADE, status:VALID,
PACKAGE BODY: APPS.PA_XLA_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_XLA_UPGRADE, status:VALID,
PACKAGE BODY: APPS.AR_UPGHARNESS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_UPGHARNESS_PKG, status:VALID,
PACKAGE BODY: APPS.AR_UPGHARNESS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_UPGHARNESS_PKG, status:VALID,
TABLE: GL.GL_MC_REPORTING_OPTIONS_11I 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_REPORTING_OPTIONS_11I, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID,
TABLE: GL.GL_MC_REPORTING_OPTIONS_11I 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_MC_REPORTING_OPTIONS_11I, object_name:GL_MC_REPORTING_OPTIONS_11I, status:VALID,
PACKAGE BODY: APPS.CST_SLA_UPDATE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CST_SLA_UPDATE_PKG, status:VALID,
PACKAGE BODY: APPS.CST_SLA_UPDATE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CST_SLA_UPDATE_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.GL_AS_POST_UPG_CHK_PKG SQL Statements 12.2.2
APPS.GL_AS_POST_UPG_CHK_PKG SQL Statements 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
Table: FND_CURRENCIES 12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_CURRENCIES, object_name:FND_CURRENCIES, status:VALID, product: FND - Application Object Library , description: Currencies enabled for use at your site , implementation_dba_data: APPLSYS.FND_CURRENCIES ,
Table: GL_DAILY_CONVERSION_TYPES 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_DAILY_CONVERSION_TYPES, object_name:GL_DAILY_CONVERSION_TYPES, status:VALID, product: GL - General Ledger , description: Foreign currency daily conversion rate types , implementation_dba_data: GL.GL_DAILY_CONVERSION_TYPES ,
12.1.1 DBA Data 12.1.1
Table: GL_DAILY_CONVERSION_TYPES 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_DAILY_CONVERSION_TYPES, object_name:GL_DAILY_CONVERSION_TYPES, status:VALID, product: GL - General Ledger , description: Foreign currency daily conversion rate types , implementation_dba_data: GL.GL_DAILY_CONVERSION_TYPES ,
Table: FND_CURRENCIES 12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_CURRENCIES, object_name:FND_CURRENCIES, status:VALID, product: FND - Application Object Library , description: Currencies enabled for use at your site , implementation_dba_data: APPLSYS.FND_CURRENCIES ,
12.2.2 DBA Data 12.2.2
APPS.AR_UPGHARNESS_PKG SQL Statements 12.1.1
APPS.AR_UPGHARNESS_PKG SQL Statements 12.2.2
APPS.PA_XLA_UPGRADE dependencies on GL_MC_REPORTING_OPTIONS_11I 12.1.1
APPS.CST_SLA_UPDATE_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.1.1
APPS.AR_UPGHARNESS_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.2.2
APPS.CST_SLA_UPDATE_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.2.2
APPS.GL_AS_POST_UPG_CHK_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.1.1
APPS.PA_XLA_UPGRADE dependencies on GL_MC_REPORTING_OPTIONS_11I 12.2.2
APPS.GL_AS_POST_UPG_CHK_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.2.2
APPS.AR_UPGHARNESS_PKG dependencies on GL_MC_REPORTING_OPTIONS_11I 12.1.1
APPS.PA_XLA_UPGRADE SQL Statements 12.2.2
APPS.PA_XLA_UPGRADE SQL Statements 12.1.1
PACKAGE BODY: APPS.PA_XLA_UPGRADE 12.1.1
PACKAGE BODY: APPS.PA_XLA_UPGRADE 12.2.2