Search Results gl_mc_reporting_options_pk

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 12.2.2
product: GL - General Ledger , description: Multiple reporting currency conversion options by application , implementation_dba_data: Not implemented in this database ,
Table: GL_MC_REPORTING_OPTIONS 12.1.1
product: GL - General Ledger , description: Multiple reporting currency conversion options by application , implementation_dba_data: Not implemented in this database ,
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 ,
eTRM - SQLGL Tables and Views 12.2.2
description: This table contains the tracking information that Golden Gate will use to launch Journal Import. ,
eTRM - SQLGL Tables and Views 12.1.1
description: USSGL transaction codes ,
eTRM - SQLGL Tables and Views 12.2.2
description: This table contains the tracking information that Golden Gate will use to launch Journal Import. ,
eTRM - SQLGL Tables and Views 12.1.1
description: USSGL transaction codes ,