Search Results fa_book_controls




Overview
Explore in AI Chat

Overview

The FA_BOOK_CONTROLS table is a core configuration table within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It stores the master control parameters and accounting rules that govern all assets assigned to a specific depreciation book. A depreciation book is a fundamental construct in Oracle Assets, representing a distinct set of accounting records for tracking asset cost and depreciation. This table acts as the central repository for the book-level settings that determine how depreciation is calculated, how journal entries are categorized, and how the book integrates with the General Ledger. Its configuration is critical for ensuring accurate and consistent asset accounting across the enterprise.

Key Information Stored

The table's primary key is the BOOK_TYPE_CODE, uniquely identifying each depreciation book. Key columns define the book's operational and financial characteristics. These include the SET_OF_BOOKS_ID, which links the asset book to a specific General Ledger, and the DEPRN_CALENDAR, which defines the fiscal calendar for depreciation calculations. A significant portion of the table's structure is dedicated to journal entry (JE) category mappings, such as JE_DEPRECIATION_CATEGORY, JE_ADDITION_CATEGORY, and JE_RETIREMENT_CATEGORY. These columns store references to GL_JE_CATEGORIES_TL, controlling how different asset transactions are categorized in subledger accounting and ultimately posted to the General Ledger. Other columns manage processes like mass transfers (MASS_COPY_SOURCE_BOOK, MASS_REQUEST_ID) and control various accounting and depreciation rules.

Common Use Cases and Queries

This table is primarily referenced for configuration validation, troubleshooting, and integrated reporting. A common query retrieves the complete setup for a specific book to verify journal posting rules. For instance, to audit the JE category mappings for the 'CORPORATE' book, one might use:

  • SELECT book_type_code, je_depreciation_category, je_addition_category, je_retirement_category FROM fa_book_controls WHERE book_type_code = 'CORPORATE';

Another frequent use case involves identifying all asset books linked to a particular General Ledger set of books for a period-end close reconciliation:

  • SELECT book_type_code FROM fa_book_controls WHERE set_of_books_id = &set_of_books_id;

Technical consultants also query this table to understand dependencies before modifying or retiring a depreciation book, as its configuration impacts all transactional asset tables.

Related Objects

FA_BOOK_CONTROLS has extensive relationships with other EBS objects, as indicated by its foreign keys. It is fundamentally linked to GL_SETS_OF_BOOKS (via SET_OF_BOOKS_ID) and FA_CALENDAR_TYPES (via DEPRN_CALENDAR). Its numerous foreign keys to GL_JE_CATEGORIES_TL underscore its role as the bridge between asset transactions and General Ledger accounting. The table is also referenced by the FA_BOOKS table, which holds asset-specific book information, and by key transactional tables like FA_DEPRN_DETAIL. Key APIs, such as the asset addition and depreciation programs, rely on the rules defined in FA_BOOK_CONTROLS to process transactions correctly. The self-referencing foreign key on MASS_COPY_SOURCE_BOOK indicates its role in book copy operations.