Results for “inherit_conversion_type”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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 indexGL_MC_REPORTING_OPTIONS_U1on 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_11Iresolves set-of-books names for both the primary and reporting sides. - Filtering on
START_DATE/END_DATEvalidates 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.
-
Multiple reporting currency conversion options by application/operating unit/asset book
-
Multiple reporting currency conversion rules for Oracle General Ledger
-
Multiple reporting currency conversion rules for Oracle General Ledger
-
Multiple reporting currency conversion options by application/operating unit/asset book
-
This table contains the tracking information that Golden Gate will use to launch Journal Import.
-
USSGL transaction codes