Search Results gl_mc_book_assignments

Overview

GL_MC_BOOK_ASSIGNMENTS is a General Ledger (GL) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the assignment relationships between reporting sets of books and primary sets of books. Its documented description is "Assignments of reporting sets of books to primary sets of books." This table supports the Multiple Reporting Currencies (MRC) feature, through which a single transaction entered in a primary set of books can be automatically converted and replicated into one or more reporting sets of books using a defined currency and conversion method. In this sense, the table defines the mapping that drives the propagation of accounting data from the primary ledger of record to its reporting counterparts.

From a heuristic Data Vault modeling perspective (mined from the foreign key structure), GL_MC_BOOK_ASSIGNMENTS is best classified as a link table. It represents a many-to-many association between sets of books, resolving the relationship between a primary set of books and a reporting set of books. It carries only the keys of the related entities plus a small set of descriptive attributes, which is characteristic of a link structure rather than a hub or satellite.

Key Information Stored

The table's stored data is organized around its composite primary key and two foreign-key relationships to GL_SETS_OF_BOOKS. The most significant columns are:

• PRIMARY_SET_OF_BOOKS_ID — Identifies the primary set of books from which data is propagated. This is part of the composite primary key and a foreign key to GL_SETS_OF_BOOKS.
• REPORTING_SET_OF_BOOKS_ID — Identifies the reporting set of books that receives the converted data. This is also part of the composite primary key and a foreign key to GL_SETS_OF_BOOKS.
• INIT_CONVERSION_TYPE — Specifies the initial conversion type associated with the assignment. This column is a foreign key to GL_DAILY_CONVERSION_TYPES, which defines the currency conversion rate type (for example, a spot or corporate rate) used when amounts are translated into the reporting set of books.

The surrogate primary key is defined by the constraint GL_MC_BOOK_ASSIGNMENTS_PK1, which is composed of the two columns PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID together. There is no separate single-column surrogate key; the two set-of-books identifiers jointly function as the unique business identifier for each assignment. Consequently, the primary key itself is the business-key candidate: each combination of a primary and a reporting set of books may appear only once, which enforces the rule that a given primary book can be mapped to a given reporting book exactly once.

Common Use Cases and Queries

Typical uses of this table include reviewing the MRC configuration for a ledger, determining which reporting books depend on a given primary book, and reporting on currency conversion settings per reporting assignment. A representative query joining the assignment to its referenced books and conversion type is:

• List all reporting books for each primary book:

  SELECT psob.name primary_book, rsob.name reporting_book, gdct.conversion_type
  FROM gl_mc_book_assignments a
  JOIN gl_sets_of_books psob ON a.primary_set_of_books_id = psob.set_of_books_id
  JOIN gl_sets_of_books rsob ON a.reporting_set_of_books_id = rsob.set_of_books_id
  JOIN gl_daily_conversion_types gdct ON a.init_conversion_type = gdct.conversion_type;

• Identify where a specific set of books acts as a reporting book:

  SELECT primary_set_of_books_id FROM gl_mc_book_assignments WHERE reporting_set_of_books_id = :reporting_book_id;

• Report conversion-type usage across the MRC configuration to standardize rate settings.

These patterns are commonly used during implementation validation, upgrades, and audits of multi-currency ledger setups. Because MRC is a legacy feature, in 12.2.2 the related functionality is largely superseded by secondary ledgers, but the assignments may still exist in upgraded environments.

Related Objects

The most significant objects related to this table, per the documented foreign keys, are:

• GL_SETS_OF_BOOKS — Referenced twice: via PRIMARY_SET_OF_BOOKS_ID and via REPORTING_SET_OF_BOOKS_ID.
• GL_DAILY_CONVERSION_TYPES — Referenced via INIT_CONVERSION_TYPE, defining the conversion rate type used.
• GL_MC_BOOK_ASSIGNMENTS_PK1 — The primary key constraint on PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID.

Note that this object is documented as not implemented in the referenced database instance, so it may be absent or empty in environments that do not use MRC.