Search Results reporting_book_currency_code

Overview

The GL_MC_BOOK_ASSIGNMENTS_V view is a General Ledger (GL) dictionary object used in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It presents data from the Multiple Reporting Currencies (MRC) book assignment configuration, exposing the relationship between a primary set of books and one or more reporting sets of books, together with the conversion parameters and Enterprise Financial Center (EFC / Financial Consolidation Hub) processing flags associated with each assignment.

In MRC-enabled implementations, a single primary ledger (set of books) can be associated with multiple reporting ledgers so that subledger and GL transactions are automatically converted into reporting currencies. This view is therefore the reporting and integration entry point for identifying which reporting books belong to a given primary set of books, what conversion rate type and date drive the initial translation, and whether the reporting book has been enabled for EFC or consolidated processing. The user's search term, primary_set_of_books_id, maps directly to the column of the same name exposed by this view, which is the natural join key back to the primary ledger.

Underlying Base Objects

The view is defined over three object references:

• GL_MC_BOOK_ASSIGNMENTS (alias B) — the driving MRC assignment table holding one row per primary/reporting book pairing.
• GL_SETS_OF_BOOKS (alias SOB) — joined on SET_OF_BOOKS_ID = B.REPORTING_SET_OF_BOOKS_ID, supplying the reporting book name, short name, and currency.
• GL_DAILY_CONVERSION_TYPES (alias D) — an outer join (D.CONVERSION_TYPE (+) = B.INIT_CONVERSION_TYPE) that resolves the descriptive user conversion type for the initial translation.

The row identifier ROW_ID is derived from B.ROWID, so each row corresponds uniquely to a GL_MC_BOOK_ASSIGNMENTS record. Note that ETRM documentation lists no referenced base objects for the 12.2.2 release metadata, and the object is noted as "Not implemented in this database," indicating the view text above is the authoritative definition.

Key Columns

• PRIMARY_SET_OF_BOOKS_ID — identifier of the primary ledger to which the reporting book is assigned; the primary search/filter key.
• REPORTING_SET_OF_BOOKS_ID — identifier of the assigned reporting ledger.
• REPORTING_BOOK_NAME / REPORTING_BOOK_SHORT_NAME / REPORTING_BOOK_CURRENCY_CODE — descriptive attributes sourced from GL_SETS_OF_BOOKS.
• FIRST_MRC_DATE / FIRST_MRC_PERIOD — the date and period from which MRC conversion begins for the assignment.
• INIT_CONVERSION_TYPE / INIT_USER_CONVERSION_TYPE — the initial conversion rate type (code and user name), the latter resolved through GL_DAILY_CONVERSION_TYPES.
• INIT_CONVERSION_DATE and CONVERSION_OPTION_CODE — the date and option governing the initial translation.
• EFC_BOOK_FLAG, PRE_EFC_SELECTED_FLAG, EFC_SELECTED_FLAG, EFC_COMPLETED_FLAG, EFC_RUN_ID — lifecycle flags and run identifier for EFC / consolidation processing of the reporting book.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical scenarios include validating MRC configurations, reporting the reporting-book population for a primary ledger, and driving integration extracts that need currency and conversion context.

List all reporting books for a primary ledger:

SELECT REPORTING_BOOK_NAME,
       REPORTING_BOOK_CURRENCY_CODE,
       INIT_CONVERSION_TYPE,
       FIRST_MRC_PERIOD
FROM   GL_MC_BOOK_ASSIGNMENTS_V
WHERE  PRIMARY_SET_OF_BOOKS_ID = :primary_sob_id;

Identify reporting books not yet consolidated under EFC:

SELECT PRIMARY_SET_OF_BOOKS_ID,
       REPORTING_SET_OF_BOOKS_ID,
       EFC_BOOK_FLAG,
       EFC_COMPLETED_FLAG,
       EFC_RUN_ID
FROM   GL_MC_BOOK_ASSIGNMENTS_V
WHERE  NVL(EFC_COMPLETED_FLAG,'N') = 'N';

Join to GL_LEDGERS (12.2.x) or GL_SETS_OF_BOOKS (12.1.1) on PRIMARY_SET_OF_BOOKS_ID to label assignments with primary ledger names, or filter on REPORTING_BOOK_CURRENCY_CODE to isolate a specific reporting currency. Because the view is a thin projection over the assignment table with descriptive lookups, queries against it should be treated as read-only reference data.