Search Results fa_category_books

Overview

The FA_CATEGORY_BOOKS table is a core configuration table within the Oracle E-Business Suite Fixed Assets module (OFA). It stores the default financial information, primarily natural account assignments, that link an asset category to a specific depreciation book. This table acts as a critical bridge, ensuring that when an asset is assigned to a category and a book, the system has predefined, consistent accounting rules for posting transactions. Its role is fundamental to the automated generation of accurate accounting entries for asset additions, depreciation, revaluations, retirements, and transfers. The configuration held in this table is established during the setup of asset categories and books and is a prerequisite for asset capitalization.

Key Information Stored

The table's structure is defined by a composite primary key on CATEGORY_ID and BOOK_TYPE_CODE, enforcing a unique financial setup per category-book combination. The most significant data it holds are the Code Combination IDs (CCIDs) that point to specific General Ledger accounts. Key columns include ASSET_COST_ACCOUNT_CCID, DEPRN_EXPENSE_ACCOUNT_CCID, and RESERVE_ACCOUNT_CCID, which define the core accounts for asset cost, depreciation expense, and accumulated depreciation, respectively. Other critical CCID columns govern accounting for bonus depreciation (BONUS_EXPENSE_ACCOUNT_CCID), revaluations (REVAL_RESERVE_ACCOUNT_CCID), retirements (ASSET_CLEARING_ACCOUNT_CCID), and Work in Process (WIP_COST_ACCOUNT_CCID). This centralized storage of default accounts ensures accounting integrity and simplifies mass maintenance.

Common Use Cases and Queries

A primary use case is validating or reporting on the accounting setup for asset categories. Implementation consultants and functional analysts frequently query this table to audit account mappings. A common SQL pattern retrieves the complete account setup for a specific category and book, often joining to FA_CATEGORIES_B and FA_BOOK_CONTROLS for descriptive names. Another critical use is during asset addition processes, where the system references FA_CATEGORY_BOOKS to default the accounts onto the FA_BOOKS_OF_ASSETS record. Troubleshooting accounting errors often involves verifying that the CCIDs in this table correspond to valid, active GL_CODE_COMBINATIONS.

• Sample Query: SELECT fcb.*, fc.segment1, fc.description FROM fa_category_books fcb, fa_categories_b fc WHERE fcb.category_id = fc.category_id AND fcb.book_type_code = 'CORPORATE';
• Reporting Use Case: Generating a cross-reference report of all depreciation expense accounts by asset category for a given ledger (book).

Related Objects

FA_CATEGORY_BOOKS has extensive dependencies, as shown in the provided metadata. It is a child table to FA_CATEGORIES_B via CATEGORY_ID and to FA_BOOK_CONTROLS via BOOK_TYPE_CODE. Crucially, it references GL_CODE_COMBINATIONS through over a dozen foreign key relationships for its various account CCID columns. This table is directly referenced by the transaction engine when creating asset records; the FA_ADDITIONS_B and FA_BOOKS_OF_ASSETS tables inherit their default account values from it. Key APIs, such as the asset addition and mass addition programs, rely on the data in this table to populate asset financial information correctly. It is also central to the setup forms in the Fixed Assets application interface.