Results for “fa_books”

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

Overview

FA_BOOKS is the core financial satellite table in the Oracle E-Business Suite (EBS) Assets module (product OFA). It stores the depreciation and financial attributes of every asset for each of the depreciation books in which that asset is defined. Because an asset can belong to multiple books (for example, a corporate book and a tax book), FA_BOOKS carries one row per asset-book combination, making it the definitive source for book-specific accounting treatment such as cost, method, life, and convention.

In Data Vault modeling terms, the relationship metadata classifies FA_BOOKS as satellite-leaning. This is a heuristic suggestion: the table behaves primarily as a satellite describing descriptive financial state attached to asset and book business keys, but it also contains hub-like key columns (ASSET_ID, BOOK_TYPE_CODE) and link-like transactional references (TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT), so a formal model would likely split these roles across hub, link, and satellite constructs.

Key Information Stored

The documented physical schema contains 132 columns. The most operationally significant are:

• BOOK_TYPE_CODE — identifies the depreciation book; joins to FA_BOOK_CONTROLS and FA_DEPRN_PERIODS.
• ASSET_ID — foreign key to FA_ADDITIONS_B; identifies the asset.
• TRANSACTION_HEADER_ID_IN / _OUT — surrogate links to FA_TRANSACTION_HEADERS. The unique index FA_BOOKS_U1 on TRANSACTION_HEADER_ID_IN is the documented business-key candidate; the primary key is FA_BOOKS_PK.
• COST, ORIGINAL_COST, ADJUSTED_COST — acquisition and adjusted capitalized cost.
• SALVAGE_VALUE, PERCENT_SALVAGE_VALUE — residual value parameters.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, BASIC_RATE, ADJUSTED_RATE — depreciation method and life.
• PRORATE_CONVENTION_CODE, PRORATE_DATE — convention rules for prorating depreciation.
• DATE_PLACED_IN_SERVICE, DEPRN_START_DATE — service and depreciation start dates.
• CAPITALIZE_FLAG, DEPRECIATE_FLAG, RETIREMENT_PENDING_FLAG — lifecycle status flags.
• PERIOD_COUNTER_CAPITALIZED, _FULLY_RESERVED, _FULLY_RETIRED, _LIFE_COMPLETE — period counters joining to FA_DEPRN_PERIODS.

Common Use Cases and Queries

Typical reporting joins FA_BOOKS to FA_ADDITIONS_B for asset description, FA_BOOK_CONTROLS for book currency and calendar, and FA_DEPRN_PERIODS for period mapping. A representative query:

• SELECT fb.asset_id, fb.book_type_code, fb.cost, fb.adjusted_cost, fb.deprn_method_code, fb.life_in_months FROM fa_books fb WHERE fb.book_type_code = :book AND fb.capitalize_flag = 'YES'
• Depreciation schedules join FA_BOOKS to FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL on ASSET_ID and BOOK_TYPE_CODE.
• Cost reconciliation reports compare COST and ADJUSTED_COST against ORIGINAL_COST to detect adjustments.
• Retirement and transfer processing uses RETIREMENT_ID, TRANSACTION_HEADER_ID_IN/_OUT, and group tracking via GROUP_ASSET_ID and SUPER_GROUP_ID.

Related Objects

The most significant related tables, based on documented foreign key relationships, are:

• FA_ADDITIONS_B (FA_BOOKS.ASSET_ID) — asset master.
• FA_BOOK_CONTROLS and FA_DEPRN_PERIODS (BOOK_TYPE_CODE) — book controls and period mapping.
• FA_TRANSACTION_HEADERS (TRANSACTION_HEADER_ID_IN/_OUT) — transaction linkage.
• FA_METHODS (DEPRN_METHOD_CODE, LIFE_IN_MONTHS) and FA_CONVENTION_TYPES (PRORATE_CONVENTION_CODE).
• FA_RETIREMENTS (RETIREMENT_ID) and FA_CEILING_TYPES (CEILING_NAME).
• FA_CAPITAL_BUDGET, FA_DISTRIBUTION_HISTORY, and FA_TRANSFER_DETAILS reference FA_BOOKS, reinforcing its central role.