Results for “fa_category_book_defaults”

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

Overview

FA_CATEGORY_BOOK_DEFAULTS is an Oracle E-Business Suite Fixed Assets (OFA) reference table that stores the default depreciation rules assigned to a specific combination of asset category and depreciation book, valid for a defined range of dates placed in service (DPIS). It functions as the rules engine behind asset category setup, supplying depreciation method, life, prorate convention, ceiling, bonus, and salvage attributes that Oracle Assets applies when a new asset is added or when depreciation is calculated.

The relationship metadata classifies this object heuristically as a link in Data Vault terms. This is a reasonable modeling suggestion: the table sits at the intersection of asset categories, books, and date-placed-in-service ranges, resolving many-to-many style relationships between category, book, and time. It is not a pure hub or satellite, since its business identity is composite and it carries descriptive attributes alongside those references.

Key Information Stored

The table comprises 64 documented columns. The most significant include the following:

• CATEGORY_ID, BOOK_TYPE_CODE, and START_DPIS — the composite unique key (index FA_CATEGORY_BOOK_DEFAULTS_U1 and the primary key FA_CATEGORY_BOOK_DEFAULTS_PK), defining which category/book combination each row governs and the date placed in service from which the defaults apply.
• END_DPIS — the closing boundary of the date placed in service range, giving each default set a validity window.
• DEPRN_METHOD and LIFE_IN_MONTHS — the depreciation method and useful life applied by default.
• PRORATE_CONVENTION_CODE and RETIREMENT_PRORATE_CONVENTION — prorate conventions for acquisition and retirement.
• CEILING_NAME plus ITC_ELIGIBLE_FLAG, USE_ITC_CEILINGS_FLAG, BASIC_RATE, and ADJUSTED_RATE — investment tax credit and depreciation ceiling controls.
• BONUS_RULE and DEPRECIATE_FLAG — bonus depreciation treatment and whether the category is depreciated in the book.
• PRICE_INDEX_NAME, USE_STL_RETIREMENTS_FLAG, STL_METHOD_CODE, and STL_LIFE_IN_MONTHS — revaluation price index and short (STL) retirement rules.
• PERCENT_SALVAGE_VALUE and SUBCOMPONENT_LIFE_RULE / MINIMUM_LIFE_IN_MONTHS — salvage and subcomponent life defaults.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and 15 flexfield ATTRIBUTE columns.

Common Use Cases and Queries

Typical uses include validating depreciation setups during implementation, troubleshooting why an asset received an unexpected method or life, and reporting on category/book rule differences across a multi-book ledger.

A resolution query returning the governing default for a given asset's DPIS:

SELECT cbd.deprn_method, cbd.life_in_months,
       cbd.prorate_convention_code, cbd.ceiling_name
FROM   fa_category_book_defaults cbd
WHERE  cbd.category_id    = :category_id
AND    cbd.book_type_code = :book_type_code
AND    :dpis BETWEEN cbd.start_dpis
                 AND NVL(cbd.end_dpis, TO_DATE('4712-12-31','YYYY-MM-DD'));

A reporting scenario lists all default sets for a book, joined to category names, to audit changes to depreciation policy over time. Because this table governs defaults at asset addition, it is also frequently queried by support teams reconciling an asset's recorded method and life against its category definition.

Related Objects

The foreign keys documented for this table establish the primary relationships to reference and transaction objects:

• FA_CATEGORIES_B — joined on CATEGORY_ID, providing the asset category definition.
• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE, the depreciation book definition.
• FA_METHODS — referenced twice, via DEPRN_METHOD and STL_METHOD_CODE, supplying depreciation method details.
• FA_CONVENTION_TYPES — referenced via PRORATE_CONVENTION_CODE and RETIREMENT_PRORATE_CONVENTION.
• FA_CEILING_TYPES — joined on CEILING_NAME for depreciation ceilings.
• FA_PRICE_INDEXES — joined on PRICE_INDEX_NAME for revaluation.
• FA_ADDITIONS_B — joined on GROUP_ASSET_ID, linking category defaults to grouped/mass property assets.

These relationships confirm the table's central role in the Fixed Assets setup model, bridging categories, books, and asset-level depreciation policy.