Results for “ceiling_name”

50+ results




Overview
Explore in AI Chat

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

Overview

FA_CEILINGS is a seeded and user-defined configuration table in the Oracle Assets (OFA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the ceiling limits applied to depreciation expense, investment tax credit (ITC) cost basis, and depreciation cost basis for assets subject to statutory or regulatory caps. These ceilings are referenced during depreciation and tax credit processing to prevent computed amounts from exceeding jurisdictional maximums.

The table resides in the FA schema and is classified as VALID in the ETRM repository. Its primary key is FA_CEILINGS_PK, defined on START_DATE, YEAR_OF_LIFE, and CEILING_NAME. A unique business-key index, FA_CEILINGS_U1, is maintained on CEILING_NAME, YEAR_OF_LIFE, and START_DATE. Under a heuristic Data Vault classification derived from the foreign-key structure, FA_CEILINGS is satellite-leaning: it holds descriptive, time-versioned attributes (limit values, effective dates) that qualify a parent reference dimension, FA_CEILING_TYPES, rather than acting as an independent hub or associative link.

Key Information Stored

The physical schema documents 26 columns. The most significant are:

  • CEILING_NAME — Identifier of the ceiling definition; participates in both the primary key and the foreign key to FA_CEILING_TYPES.
  • START_DATE — Effective start date of the ceiling row; part of the composite primary key and unique business key.
  • END_DATE — Expiration date marking when the ceiling no longer applies.
  • YEAR_OF_LIFE — The asset life year to which the ceiling applies; part of the primary key and unique business key.
  • LIMIT — The numeric ceiling amount applied against depreciation expense, ITC cost basis, or depreciation cost basis.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording row creation and modification lineage.
  • ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle flexfield (descriptive flexfield) columns, available for client-specific extension without schema modification.

The surrogate primary key is FA_CEILINGS_PK on (START_DATE, YEAR_OF_LIFE, CEILING_NAME); the unique index FA_CEILINGS_U1 on (CEILING_NAME, YEAR_OF_LIFE, START_DATE) enforces the same business combination in a different column order, confirming that a ceiling type may carry at most one limit per life year per effective start date.

Common Use Cases and Queries

Implementers query FA_CEILINGS to audit statutory ceilings before running depreciation, to reconcile tax-book cost basis limits for ITC, and to validate date ranges that overlap or leave gaps. Because rows are date-versioned, queries typically filter on START_DATE and END_DATE to select the ceiling in force for a given period.

A representative pattern resolves the active ceiling for a ceiling type and life year:

  • SELECT ceiling_name, year_of_life, start_date, end_date, limit FROM fa_ceilings WHERE ceiling_name = :name AND year_of_life = :yr AND TRUNC(SYSDATE) BETWEEN start_date ON AND NVL(end_date, TRUNC(SYSDATE)+1);

Reporting use cases include listing all ceilings joined to FA_CEILING_TYPES for a setup review, comparing consecutive LIMIT values across START_DATE versions to detect unfavorable changes, and identifying rows whose END_DATE precedes START_DATE as data-quality exceptions. For tax and regulatory audits, the ATTRIBUTE columns are often repurposed to carry jurisdiction codes or documentation references.

Related Objects

  • FA_CEILING_TYPES — Parent reference table; FA_CEILINGS.CEILING_NAME joins to FA_CEILING_TYPES to resolve the ceiling category and descriptive attributes.
  • FA_BOOK_CONTROLS and FA_BOOKS — Corporate and tax books whose depreciation rules invoke ceiling logic during the depreciation run.
  • FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL — Depreciation output tables indirectly governed by ceiling limits applied at calculation time.
  • FA_ADJUSTMENTS — Adjustments referencing ceiling-driven cost basis or expense corrections.
  • FA_ASSET_HISTORY — Historical transactions affected by ceiling-constrained depreciation amounts.
  • FA_SETUP_APIS / FA_DEPRN_API — Public APIs through which ceiling configurations and depreciation calculations are validated and posted.

Together these objects position FA_CEILINGS as the configuration anchor for regulatory depreciation limits in Oracle Assets.