Search Results fa_books

Overview

The FA_BOOKS table is a core transactional entity within the Oracle E-Business Suite Fixed Assets (OFA) module for versions 12.1.1 and 12.2.2. It stores the definitive financial and accounting information for each asset, as recorded in a specific asset book. An asset book defines the depreciation and accounting rules for a set of assets, and a single physical asset can have multiple records in FA_BOOKS, each representing its financial history in a different book (e.g., Corporate, Tax). This table is the primary repository for an asset's cost, accumulated depreciation, current depreciation expense, and key depreciation rules such as method, life, and convention. It serves as the central point for calculating and reporting asset balances and depreciation.

Key Information Stored

The table's primary key is TRANSACTION_HEADER_ID_IN, linking it to the FA_TRANSACTION_HEADERS table to track the transaction that created the book record. Critical financial columns include COST, DEPRN_RESERVE, and DEPRN_AMOUNT. Depreciation rule columns such as DEPRN_METHOD_CODE, LIFE_IN_MONTHS, and PRORATE_CONVENTION_CODE are foreign keys to their respective reference tables. The table also tracks the asset's status and timeline within the book through columns like DATE_EFFECTIVE, DATE_INEFFECTIVE, PERIOD_COUNTER_FULLY_RESERVED, and PERIOD_COUNTER_CAPITALIZED. Other significant foreign key relationships include ASSET_ID (to FA_ADDITIONS_B), BOOK_TYPE_CODE (to FA_BOOK_CONTROLS), and RETIREMENT_ID (to FA_RETIREMENTS).

Common Use Cases and Queries

This table is essential for asset valuation reports, ledger reconciliation, and audit inquiries. A fundamental query retrieves the current net book value for assets in a specific book, joining to FA_ADDITIONS_B for descriptive information. Developers often query FA_BOOKS to determine the active depreciation rules for an asset or to trace its cost history. For period-end closing, processes reference PERIOD_COUNTER_* columns to identify assets that were fully reserved, retired, or capitalized in a given period. A typical reporting query pattern is:

• SELECT fb.asset_id, fa.asset_number, fb.cost, fb.deprn_reserve, fb.cost - fb.deprn_reserve net_book_value
• FROM fa_books fb, fa_additions_b fa
• WHERE fb.asset_id = fa.asset_id AND fb.book_type_code = 'CORPORATE' AND fb.date_ineffective IS NULL;

Related Objects

FA_BOOKS has extensive relationships within the Fixed Assets schema. It is a parent table to several key history and transaction tables, including FA_DEPRN_DETAIL, FA_DISTRIBUTION_HISTORY, and FA_TRANSFER_DETAILS. As indicated by the foreign keys, it references numerous control and reference tables: FA_BOOK_CONTROLS, FA_METHODS, FA_CONVENTION_TYPES, FA_DEPRN_PERIODS, and FA_TRANSACTION_HEADERS (for both the creating and retiring transactions). The FA_ADDITIONS_B table provides the master asset definition, while FA_RETIREMENTS and FA_CAPITAL_BUDGET link to specific transactional events. This network of relationships underscores FA_BOOKS' role as the central financial hub for asset accounting.