Search Results fa_ceilings




Overview
Explore in AI Chat

Overview

The FA_CEILINGS table is a core data repository within the Oracle E-Business Suite Fixed Assets (OFA) module. It stores the ceiling rules that govern the calculation of depreciation expense, investment tax credit (ITC) cost basis, and depreciation cost basis for assets. These ceilings are critical for ensuring compliance with statutory accounting and tax regulations, such as those mandated by the Internal Revenue Service (IRS) in the United States. The table contains both Oracle-seeded ceiling definitions, which provide standard regulatory calculations, and user-defined ceilings, which allow organizations to implement custom or jurisdiction-specific fiscal policies. Its primary role is to serve as the master source for ceiling data, which is referenced during depreciation processing to limit expense amounts or adjust cost bases according to predefined annual or life-to-date limits.

Key Information Stored

The table's structure is designed to define a ceiling's value for a specific period in an asset's life. The primary key consists of three columns: START_DATE, YEAR_OF_LIFE, and CEILING_NAME. The START_DATE and YEAR_OF_LIFE columns together identify the fiscal period for which the ceiling rule is applicable. The CEILING_NAME is a foreign key that classifies the type of ceiling, linking to the FA_CEILING_TYPES table. While the specific value column is not detailed in the provided metadata, based on its description, the table would typically contain at least one column (e.g., CEILING_AMOUNT or CEILING_RATE) that stores the numerical limit or percentage for the given ceiling name, start date, and year of life. This setup allows for defining multi-year ceiling schedules.

Common Use Cases and Queries

A primary use case is the execution of depreciation runs, where the system queries this table to retrieve the applicable ceiling limit for an asset based on its fiscal year and life year. Financial reporting and tax preparation also rely on this data to validate and explain calculated depreciation figures. Common queries involve joining to the FA_CEILING_TYPES table for descriptive information. For example, to list all seeded ceiling rules effective in a given fiscal year, a query might be: SELECT fc.ceiling_name, fc.year_of_life, fc.start_date, fct.description FROM fa_ceilings fc, fa_ceiling_types fct WHERE fc.ceiling_name = fct.ceiling_name AND fc.start_date = '01-JAN-2023' ORDER BY fc.ceiling_name, fc.year_of_life; Another typical query retrieves the specific ceiling amount for a named rule and life year for integration or audit purposes.

Related Objects

  • FA_CEILING_TYPES: This is the primary related table, as documented by the foreign key relationship. The FA_CEILINGS.CEILING_NAME column references FA_CEILING_TYPES. This table provides the master definition, description, and category (e.g., Expense Ceiling, ITC Basis Ceiling) for each ceiling rule stored in FA_CEILINGS.
  • FA_CEILINGS_PK: The primary key constraint on the table, enforcing uniqueness on the combination of START_DATE, YEAR_OF_LIFE, and CEILING_NAME.
  • Depreciation Engine (FA_DEPRN): While not a direct foreign key, the core depreciation processing logic within the Fixed Assets application will read from FA_CEILINGS to apply limits during expense calculation.