Search Results efc_completed_flag

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_MC_BOOK_ASSIGNMENTS_11I is a General Ledger (GL) schema table in Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. Its stated purpose is to record the assignments of reporting sets of books to primary sets of books. This table is the backbone of the Multiple Reporting Currencies (MRC) feature, which allows an organization to maintain one or more reporting sets of books that mirror a designated primary set of books. Each row establishes that a specific reporting book is subordinate to a specific primary book, and it also carries the configuration that governs how that reporting book is initially populated and maintained.

From a Data Vault modeling perspective, the metadata's heuristic classification is a link. The table's identity is defined not by a surrogate sequence but by the pairing of two business entities — the primary set of books and the reporting set of books — with the remaining columns acting as descriptive attributes of that relationship. In practice, this makes it the central association table that other MRC and multi-book reporting logic resolves against.

Key Information Stored

The table contains 17 documented columns. The most operationally significant are:

• PRIMARY_SET_OF_BOOKS_ID — identifies the source (primary) set of books. Part of the composite primary key and a foreign key to GL_SETS_OF_BOOKS_11I.
• REPORTING_SET_OF_BOOKS_ID — identifies the reporting set of books assigned to that primary book. Also part of the composite primary key and a foreign key to GL_SETS_OF_BOOKS_11I.
• FIRST_MRC_DATE and FIRST_MRC_PERIOD — define the effective start of MRC processing, establishing when the reporting book begins tracking translated activity.
• CONVERSION_OPTION_CODE — indicates the conversion policy applied when translating balances and transactions.
• INIT_CONVERSION_TYPE — specifies the daily conversion rate type used for the initial translation; foreign key to GL_DAILY_CONVERSION_TYPES.
• INIT_CONVERSION_DATE — the date on which the initial conversion is performed.
• EFC_BOOK_FLAG, PRE_EFC_SELECTED_FLAG, EFC_SELECTED_FLAG, EFC_COMPLETED_FLAG — flags tracking eligibility and progress of the Enterprise Financial Consolidation / migration lifecycle for the book pairing.
• EFC_RUN_ID — the identifier of the consolidation or conversion run associated with the assignment.
• Standard audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN record who created and last modified the assignment.

Two constraints are documented. The surrogate primary key is GL_MC_BOOK_ASSIGNMENTS_PK1, defined over (PRIMARY_SET_OF_BOOKS_ID, REPORTING_SET_OF_BOOKS_ID). A separate unique index, GL_MC_BOOK_ASSIGNMENTS_U1, is defined over the same two columns, confirming the business key: a given primary book can be paired with a given reporting book only once.

Common Use Cases and Queries

The most frequent use is determining which reporting books are attached to a given primary set of books, typically as a prerequisite to MRC balance reporting or initialization checks.

• List reporting books for a primary book: SELECT reporting_set_of_books_id FROM gl_mc_book_assignments_11i WHERE primary_set_of_books_id = :primary_id;
• Resolve both book names via a join to GL_SETS_OF_BOOKS_11I on PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID.
• Report first MRC period and conversion setup for auditing translation configuration, selecting FIRST_MRC_PERIOD, FIRST_MRC_DATE, and INIT_CONVERSION_TYPE.
• Track consolidation migration status by filtering on EFC_COMPLETED_FLAG, EFC_SELECTED_FLAG, or EFC_RUN_ID.
• Validate the conversion rate type by joining INIT_CONVERSION_TYPE to GL_DAILY_CONVERSION_TYPES.

Related Objects

• GL_SETS_OF_BOOKS_11I — referenced twice, through PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID; the primary source of book names and attributes.
• GL_DAILY_CONVERSION_TYPES — referenced via INIT_CONVERSION_TYPE for initial translation rates.
• MRC balance and reporting objects in the GL schema typically resolve their book context through this assignment table.
• MRC concurrent processes and the standard General Ledger multi-book reporting inquiries depend on these assignments to determine translation scope between a primary and reporting book.