Search Results gl_mc_reporting_options_n2

Overview

GL.GL_MC_REPORTING_OPTIONS_11I is a General Ledger table in the Oracle E-Business Suite that defines the configuration of Multiple Reporting Currencies (MRC). Each row establishes a reporting relationship between a primary accounting set of books and one or more reporting sets of books, specifying the currencies, conversion conventions, and date rules used when a transaction or journal is replicated from the primary book into a reporting book. Within the MRC architecture, this table acts as the controlling setup record: downstream conversion logic reads it to determine whether a reporting book is active, which currency pair applies, and how translation dates and rates should be derived.

The object is owned by the GL schema and is flagged VALID in the ETRM repository, with a design-data reference of SQLGL.GL_MC_REPORTING_OPTIONS_11I. Oracle classifies the table as internal-use, meaning it should be accessed through standard Oracle Applications programs rather than directly in custom code, although read access for reporting and diagnostics is common in practice.

From a modeling perspective, the table leans toward a satellite classification. Its primary key, REPORTING_OPTION_ID, identifies an individual configuration record rather than a reusable business entity, while the surrounding columns (books, currencies, flags, and dates) represent descriptive and state attributes that change over time. The book references function as foreign-key edges to the GL_SETS_OF_BOOKS_11I hub, reinforcing the satellite interpretation.

Key Information Stored

The most significant columns fall into four groups:

• Identity: REPORTING_OPTION_ID is the surrogate primary key and the column behind the unique index GL_MC_REPORTING_OPTIONS_U1. It is the single business-key candidate documented for this table.
• Book relationships: PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, and AP_SECONDARY_SET_OF_BOOKS_ID each reference GL_SETS_OF_BOOKS_11I. They define the source book, the target reporting book, and an optional secondary Payables book.
• Currency and conversion: PRIMARY_CURRENCY_CODE and REPORTING_CURRENCY_CODE reference FND_CURRENCIES, while DATE_BASIS, CONVERSION_TYPE, and INHERIT_CONVERSION_TYPE govern how translation dates and daily rates are determined. CONVERSION_TYPE points to GL_DAILY_CONVERSION_TYPES.
• Scope and state: APPLICATION_ID, ORG_ID, FA_BOOK_TYPE_CODE, ENABLED_FLAG, START_DATE, and END_DATE control which application, operating unit, asset book, and effective window the option applies to.
• Audit columns: Standard Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) plus the ATTRIBUTE and GLOBAL_ATTRIBUTE descriptive flexfield segments complete the 42 documented columns.

Common Use Cases and Queries

Typical uses include confirming which reporting books are active for a given primary book, validating currency pairings before MRC migration, and producing setup reports for audit or upgrade assessments.

• List active reporting options for a primary book:

  SELECT reporting_option_id, reporting_set_of_books_id,
         primary_currency_code, reporting_currency_code,
         conversion_type, enabled_flag
  FROM   gl_mc_reporting_options_11i
  WHERE  primary_set_of_books_id = :p_sob_id
  AND    enabled_flag = 'Y';

• Join to book names to present a readable MRC matrix, using GL_SETS_OF_BOOKS_11I on both PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID.
• Check operating-unit scope by filtering on ORG_ID and APPLICATION_ID when reviewing multi-org setups.
• Detect Payables-specific secondary books by querying rows where AP_SECONDARY_SET_OF_BOOKS_ID is not null.
• Review effective dating with START_DATE and END_DATE to identify expired configurations before a period close.

The nonunique indexes GL_MC_REPORTING_OPTIONS_N1 and GL_MC_REPORTING_OPTIONS_N2 support these lookups by leading on PRIMARY_SET_OF_BOOKS_ID combined with reporting book, application, org, asset book type, and enabled flag. Queries that constrain on primary book and enabled flag therefore benefit from existing index coverage.

Related Objects

The following objects are the most significant dependencies in the documented relationship model:

• GL_MC_CONVERSION_RULES_11I — references this table through REPORTING_OPTION_ID; holds the rate and date conversion rules that apply to each reporting option.
• GL_SETS_OF_BOOKS_11I — the target of the three foreign keys from 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, providing the rate type used during translation.
• FND_CURRENCIES — referenced by PRIMARY_CURRENCY_CODE and REPORTING_CURRENCY_CODE.

These relationships make GL_MC_REPORTING_OPTIONS_11I the central setup point joining MRC conversion rules to the ledger and currency foundation tables. Any query that resolves a reporting option to its books, currencies, and rules should traverse these joins rather than relying on denormalized copies.