Search Results gl_mc_reporting_options




Overview
Explore in AI Chat

Overview

GL_MC_REPORTING_OPTIONS is a General Ledger configuration table in Oracle E-Business Suite (Release 12.1.1 and 12.2.2) that stores multiple reporting currency conversion options by application. It defines how a primary ledger (set of books) translates or converts balances into one or more reporting currencies, capturing the source and target ledger, the applicable conversion rate type, currency pairing, and the rule set used to produce reporting-currency balances. In effect it functions as the master setup registry for multiple reporting currency (MRC) processing, giving the GL engine the parameters it needs to derive reporting balances without duplicating the underlying transactions.

Under a Data Vault modeling heuristic, the table's classification is satellite-leaning. It holds descriptive, context-bearing attributes (conversion type, currencies, associated ledger identifiers) attached to ledger and currency business keys rather than serving as a pure hub or a pure associative link. The primary key is the surrogate REPORTING_OPTION_ID defined by GL_MC_REPORTING_OPTIONS_PK. Practically, the table behaves as a configuration parent: child conversion rules (GL_MC_CONVERSION_RULES) hang off each reporting option through REPORTING_OPTION_ID.

Key Information Stored

The table's principal columns include the following:

  • REPORTING_OPTION_ID — Surrogate primary key (GL_MC_REPORTING_OPTIONS_PK) uniquely identifying each reporting-currency option row.
  • PRIMARY_SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS identifying the source (primary) ledger whose balances are converted.
  • REPORTING_SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS identifying the target reporting ledger that receives the converted balances.
  • AP_SECONDARY_SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS for the associated Payables secondary ledger, used when the reporting currency is maintained through AP secondary ledger processing.
  • CONVERSION_TYPE — Foreign key to GL_DAILY_CONVERSION_TYPES specifying the daily rate type (for example Spot, Corporate, User) applied during conversion.
  • PRIMARY_CURRENCY_CODE — Foreign key to FND_CURRENCIES identifying the functional currency of the source ledger.
  • REPORTING_CURRENCY_CODE — Foreign key to FND_CURRENCIES identifying the currency into which balances are converted.

The surrogate key REPORTING_OPTION_ID is system-generated and carries no business meaning. Business-key candidates are the composite of PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, and REPORTING_CURRENCY_CODE, since a given primary ledger typically maps to a distinct reporting ledger/currency pairing. Note that the ETRM metadata records this table as "Not implemented in this database," indicating it may be present but unpopulated in a given instance, or relevant only where MRC is configured.

Common Use Cases and Queries

The table is queried during MRC setup, diagnostics, and reporting-balance reconciliation. Typical scenarios include verifying which reporting ledgers are driven from a given primary ledger, auditing the conversion rate type applied, and troubleshooting missing reporting-currency balances.

A representative query lists the reporting options for a primary ledger and joins to the ledger and currency lookups:

  • SELECT o.reporting_option_id, o.primary_set_of_books_id, o.reporting_set_of_books_id, o.conversion_type, o.primary_currency_code, o.reporting_currency_code FROM gl_mc_reporting_options o WHERE o.primary_set_of_books_id = :p_sob_id;
  • Joining to GL_SETS_OF_BOOKS to resolve ledger names: FROM gl_mc_reporting_options o, gl_sets_of_books b WHERE o.reporting_set_of_books_id = b.set_of_books_id;
  • Joining to GL_MC_CONVERSION_RULES to retrieve the ordered rule sequence for a reporting option: WHERE r.reporting_option_id = o.reporting_option_id ORDER BY rule position.

Reporting use cases include building a matrix of primary-to-reporting currency mappings, validating that every active reporting ledger has a defined conversion path, and feeding custom MRC reconciliation extracts.

Related Objects

The most significant related objects are:

  • GL_MC_CONVERSION_RULES — Child table referencing this table via REPORTING_OPTION_ID; defines the individual currency conversion rules that comprise each reporting option.
  • GL_SETS_OF_BOOKS — Referenced three times through PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID, and AP_SECONDARY_SET_OF_BOOKS_ID; supplies ledger definitions.
  • GL_DAILY_CONVERSION_TYPES — Referenced via CONVERSION_TYPE; supplies daily rate type definitions.
  • FND_CURRENCIES — Referenced via PRIMARY_CURRENCY_CODE and REPORTING_CURRENCY_CODE; supplies currency validation and precision.
  • GL_DAILY_RATES — Not directly referenced but consumed at conversion time based on the CONVERSION_TYPE and currency pairing defined here.

Together these objects form the multiple reporting currency configuration chain: ledger definitions, currency and rate-type metadata, and conversion rules, all anchored by GL_MC_REPORTING_OPTIONS_PK.