Search Results fa_mc_book_controls

Overview

The FA_MC_BOOK_CONTROLS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for control information that governs all assets within a reporting depreciation book. This table is fundamental to the Multi-Currency (MC) accounting functionality, enabling asset tracking and depreciation calculations in a secondary or reporting currency that differs from the primary ledger's currency. Its existence is critical for organizations operating in multiple countries or requiring financial reporting in various currencies, as it maintains the linkage between an asset book and its corresponding reporting set of books.

Key Information Stored

The table's primary key is a composite of BOOK_TYPE_CODE and SET_OF_BOOKS_ID, uniquely identifying the control settings for a specific reporting book. Key columns include BOOK_TYPE_CODE, which identifies the asset depreciation book (e.g., CORPORATE, TAX), and SET_OF_BOOKS_ID, which references the GL_SETS_OF_BOOKS_11I table to identify the specific reporting ledger. The PRIMARY_SET_OF_BOOKS_ID links back to the primary ledger from which transactions are sourced. Currency management is handled through CURRENCY_CODE (the reporting currency for this book) and PRIMARY_CURRENCY_CODE (the currency of the primary ledger). Other control columns typically manage depreciation rules, fiscal year settings, and accounting conventions specific to the reporting book's requirements.

Common Use Cases and Queries

This table is primarily accessed for configuration validation, multi-currency reporting, and data integrity checks. A common use case is verifying the setup of all reporting books for a primary ledger. A typical query would join to GL_SETS_OF_BOOKS for descriptive information:

• SELECT fmbc.book_type_code, gsob.name reporting_sob_name, fmbc.currency_code FROM fa_mc_book_controls fmbc, gl_sets_of_books_11i gsob WHERE fmbc.set_of_books_id = gsob.set_of_books_id AND fmbc.primary_set_of_books_id = :p_primary_sob_id;

Another critical use case is supporting the generation of asset reports and depreciation journals in the reporting currency. Data from this table ensures that currency conversion and accounting rules are correctly applied when asset transactions from the primary book are propagated to the reporting book.

Related Objects

FA_MC_BOOK_CONTROLS sits at the center of a key relationship hierarchy within the Fixed Assets schema, as documented by its foreign keys. It is a child of FA_BOOK_CONTROLS (via BOOK_TYPE_CODE) and GL_SETS_OF_BOOKS_11I (via SET_OF_BOOKS_ID and PRIMARY_SET_OF_BOOKS_ID), and a parent to transactional tables. The documented relationships are:

• Parent Tables: FA_BOOK_CONTROLS (BOOK_TYPE_CODE), GL_SETS_OF_BOOKS_11I (SET_OF_BOOKS_ID, PRIMARY_SET_OF_BOOKS_ID), FND_CURRENCIES (CURRENCY_CODE, PRIMARY_CURRENCY_CODE).
• Child Tables: FA_MC_BOOKS (BOOK_TYPE_CODE, SET_OF_BOOKS_ID) and FA_MC_RETIREMENTS (BOOK_TYPE_CODE, SET_OF_BOOKS_ID). These child tables store the asset-level and retirement transaction details, respectively, for the reporting book.

This structure ensures that all multi-currency asset transactions inherit the correct book-level controls defined in this table.