Search Results start_year

Overview

The FA_BONUS_RATES table is a core data repository within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It stores the specific bonus depreciation rates that are applied to qualifying assets during the depreciation calculation process. Its primary role is to provide the Depreciation program with the necessary rate data to compute bonus depreciation amounts, a key tax and accounting function for accelerated asset cost recovery. The table operates as a child entity, holding the detailed rate schedules that are defined by broader bonus rule configurations in the system.

Key Information Stored

The table's structure is designed to map bonus rates to specific time periods under a given rule. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its essential components. The primary key is a composite of BONUS_RULE and START_YEAR, indicating that rates are uniquely defined by the rule name and the fiscal year in which they take effect. The BONUS_RULE column is a foreign key linking to the FA_BONUS_RULES table, establishing the rule context. The START_YEAR column defines the fiscal year for which the associated rate is valid. Additional columns, typical for such a structure, would include the RATE (the percentage applied) and potentially an END_YEAR or similar column to define the rate's period of applicability.

Common Use Cases and Queries

This table is central to configuring and reporting on bonus depreciation. A common administrative use case is setting up or reviewing rate schedules for different bonus rules, such as those for specific tax jurisdictions or asset classes. For reporting and audit purposes, queries often join this table to the master rule definition. A typical SQL pattern retrieves all rates for a specific bonus rule to understand its historical application:

• SELECT bonus_rule, start_year, rate FROM fa_bonus_rates WHERE bonus_rule = '&RULE_NAME' ORDER BY start_year;

Furthermore, the depreciation engine internally queries this table during the depreciation run for assets assigned a bonus rule, using the asset's placed-in-service date to determine the correct bonus rate from this schedule for calculation.

Related Objects

The FA_BONUS_RATES table has a direct, documented foreign key relationship with the FA_BONUS_RULES table, which serves as the parent or header table for bonus depreciation definitions. The relationship is established on the BONUS_RULE column (FA_BONUS_RATES.BONUS_RULE references FA_BONUS_RULES). This means every entry in FA_BONUS_RATES must correspond to a valid, pre-existing rule in FA_BONUS_RULES. In application logic, these tables are frequently joined to present a complete view of a bonus rule, including its name, description, and detailed rate timeline. The table is also referenced by the core depreciation calculation engine and potentially by key asset transaction tables that store the applied bonus rule for an asset.