Search Results fa_ceiling_types




Overview
Explore in AI Chat

Overview

The FA_CEILING_TYPES table is a foundational reference table within the Oracle E-Business Suite Fixed Assets (OFA) module. It stores the master definition for depreciation ceilings, a critical feature for controlling asset depreciation expense. A ceiling type establishes a maximum allowable depreciation amount, either as a fixed monetary limit or as a percentage of the asset's cost, for a specific asset book and period. This functionality is essential for compliance with various tax and statutory accounting regulations that cap annual depreciation deductions. The table acts as a parent entity, with its primary key referenced by numerous transactional and setup tables across the Assets module.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the structure and relationships indicate the table's core attributes. The primary key, CEILING_NAME, uniquely identifies each ceiling rule. A critical column is CURRENCY_CODE, which is a foreign key to FND_CURRENCIES, defining the currency in which a monetary ceiling limit is applied. Other columns likely include descriptive fields, the ceiling method (e.g., fixed amount or percentage), the effective start and end dates for the rule, and the specific ceiling limit value or percentage rate. This setup allows for the creation of multiple, currency-specific ceiling rules that can be applied to asset books.

Common Use Cases and Queries

The primary use case is configuring and reporting on depreciation limits for tax or statutory books. Administrators define ceiling types via the application interface, which populates this table. Common queries involve listing all active ceilings or identifying which asset books use a specific ceiling rule. For example, a report to audit ceiling assignments might use a query joining FA_CEILING_TYPES to FA_BOOKS. When troubleshooting depreciation runs, support personnel may query this table to verify the ceiling limit applied to an asset, often joining through FA_CEILINGS, which holds the period-by-period ceiling amounts. A basic validation SQL pattern is: SELECT ceiling_name, currency_code FROM fa_ceiling_types WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);.

Related Objects

FA_CEILING_TYPES has extensive relationships, as documented by its foreign keys. It is a central reference for setup and transactional data:

  • FA_BOOKS & FA_MC_BOOKS: The CEILING_NAME column in these tables assigns a ceiling rule to a corporate or reporting currency asset book.
  • FA_BOOKS_SUMMARY: References the ceiling for summary-level asset information.
  • FA_CATEGORY_BOOK_DEFAULTS: Allows a ceiling to be set as a default for asset categories within a book.
  • FA_CEILINGS: The key transactional child table; stores the calculated ceiling amount for each asset and period.
  • FA_MASS_RECLASS_ITF & FA_TAX_INTERFACE: Referenced during mass reclassification and tax reporting processes.
  • FND_CURRENCIES: Validates the CURRENCY_CODE for the ceiling rule.