Search Results gl_sets_of_books_11i




Overview
Explore in AI Chat

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.

  • Table: FA_MC_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOK_CONTROLS,  object_name:FA_MC_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a reporting depreciation book ,  implementation_dba_data: FA.FA_MC_BOOK_CONTROLS , 

  • Table: FA_MC_BOOK_CONTROLS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOK_CONTROLS,  object_name:FA_MC_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a reporting depreciation book ,  implementation_dba_data: FA.FA_MC_BOOK_CONTROLS , 

  • Table: FA_MC_BOOKS_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOKS_RATES,  object_name:FA_MC_BOOKS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information ,  implementation_dba_data: FA.FA_MC_BOOKS_RATES , 

  • Table: FA_MC_CONVERSION_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_HISTORY,  object_name:FA_MC_CONVERSION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Table to store the conversion history of primary to reporting books ,  implementation_dba_data: FA.FA_MC_CONVERSION_HISTORY , 

  • Table: FA_MC_CONVERSION_HISTORY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_HISTORY,  object_name:FA_MC_CONVERSION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Table to store the conversion history of primary to reporting books ,  implementation_dba_data: FA.FA_MC_CONVERSION_HISTORY , 

  • Table: FA_MC_CONVERSION_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_RATES,  object_name:FA_MC_CONVERSION_RATES,  status:VALID,  product: OFA - Assets ,  description: Table to store the exchange rate information to convert assets from primary to reporting book ,  implementation_dba_data: FA.FA_MC_CONVERSION_RATES , 

  • Table: FA_JOURNAL_ENTRIES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_JOURNAL_ENTRIES,  object_name:FA_JOURNAL_ENTRIES,  status:VALID,  product: OFA - Assets ,  description: Journal Entry Information ,  implementation_dba_data: FA.FA_JOURNAL_ENTRIES , 

  • Table: FA_MC_MASS_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_MASS_RATES,  object_name:FA_MC_MASS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information for mass additions process ,  implementation_dba_data: FA.FA_MC_MASS_RATES , 

  • Table: FA_JOURNAL_ENTRIES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_JOURNAL_ENTRIES,  object_name:FA_JOURNAL_ENTRIES,  status:VALID,  product: OFA - Assets ,  description: Journal Entry Information ,  implementation_dba_data: FA.FA_JOURNAL_ENTRIES , 

  • Table: FA_MC_CONVERSION_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_RATES,  object_name:FA_MC_CONVERSION_RATES,  status:VALID,  product: OFA - Assets ,  description: Table to store the exchange rate information to convert assets from primary to reporting book ,  implementation_dba_data: FA.FA_MC_CONVERSION_RATES , 

  • Table: FA_MC_MASS_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_MASS_RATES,  object_name:FA_MC_MASS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information for mass additions process ,  implementation_dba_data: FA.FA_MC_MASS_RATES , 

  • Table: FA_MC_BOOKS_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOKS_RATES,  object_name:FA_MC_BOOKS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information ,  implementation_dba_data: FA.FA_MC_BOOKS_RATES , 

  • Table: FA_MC_RETIREMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_RETIREMENTS,  object_name:FA_MC_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Currency and financial information about retirements in each reporting book ,  implementation_dba_data: FA.FA_MC_RETIREMENTS , 

  • Table: FA_MC_RETIREMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_RETIREMENTS,  object_name:FA_MC_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Currency and financial information about retirements in each reporting book ,  implementation_dba_data: FA.FA_MC_RETIREMENTS , 

  • Table: FA_BOOK_CONTROLS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • Table: FA_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS ,