Results for “fa_ceiling_types”

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

Overview

FA_CEILING_TYPES is a reference and setup table in the Oracle E-Business Suite (EBS) Assets module (product code OFA), owned by the FA schema. It stores the general ceiling information used to define depreciation cost ceilings and investment tax credit (ITC) ceilings for asset books. In Oracle Assets, a ceiling imposes a maximum recoverable cost limit on an asset, after which depreciation or amortization stops for the affected book. This table serves as the master definition of ceiling types, holding the ceiling name, the associated ceiling type, an optional currency, and a description. It is a configuration-level object populated during implementation rather than a transactional table.

From a Data Vault modeling perspective, the extracted foreign key structure suggests this object is hub-leaning. It carries a single business key, CEILING_NAME, which is referenced by multiple downstream tables, making it a natural candidate for a hub entity. In a conventional relational interpretation, FA_CEILING_TYPES functions as a parent lookup table for the many book and category default records that depend on ceiling definitions.

Key Information Stored

The documented physical schema in ETRM 12.2.2 shows 25 columns in the FA schema. The most significant include:

• CEILING_NAME — the business key and primary key column. A unique index, FA_CEILING_TYPES_U1, enforces uniqueness on CEILING_NAME, and the primary key constraint FA_CEILING_TYPES_PK is defined on this column.
• CEILING_TYPE — identifies the category of ceiling treatment applied (for example, cost ceiling or ITC ceiling behavior).
• CURRENCY_CODE — the functional or ceiling currency, validated against FND_CURRENCIES. This defines the currency in which ceiling amounts are expressed.
• DESCRIPTION — a free-text explanation of the ceiling type used by administrators for identification and reporting.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle Flexfield descriptive columns, available for implementation-specific extension without schema modification.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO columns capturing audit and row-level change history.

Because CEILING_NAME is both the primary key and the unique business key, there is no separate surrogate key column; the natural key serves directly as the table's identifier.

Common Use Cases and Queries

Typical use cases involve validating and reporting on book-level ceiling configuration. A common pattern joins FA_CEILING_TYPES to FA_BOOKS to list the ceiling assigned to each depreciation book:

• Reporting: SELECT b.book_type_code, c.ceiling_name, c.ceiling_type, c.currency_code FROM fa_books b, fa_ceiling_types c WHERE b.ceiling_name = c.ceiling_name;
• Currency validation: joining to FND_CURRENCIES on CURRENCY_CODE to confirm the ceiling's currency is enabled.
• Impact analysis before disabling or renaming a ceiling type, checking references in FA_BOOKS, FA_BOOKS_SUMMARY, FA_CATEGORY_BOOK_DEFAULTS, FA_CEILINGS, and FA_MC_BOOKS.
• Category default auditing using FA_CATEGORY_BOOK_DEFAULTS.CEILING_NAME to determine which ceiling applies by asset category and book.
• Mass reclassification and tax interface work, where FA_MASS_RECLASS_ITF and FA_TAX_INTERFACE carry ceiling references during processing.

Ceiling setup and maintenance is generally performed through the Oracle Assets setup windows rather than by direct SQL, since referential integrity and flexfield validation must be preserved.

Related Objects

FA_CEILING_TYPES is referenced by several FA tables through the CEILING_NAME column, and it references one parent table:

• FND_CURRENCIES — parent of CURRENCY_CODE.
• FA_BOOKS — references FA_CEILING_TYPES via CEILING_NAME; the primary consumer of ceiling definitions.
• FA_BOOKS_SUMMARY — references via CEILING_NAME.
• FA_CATEGORY_BOOK_DEFAULTS — references via CEILING_NAME for category-level defaults.
• FA_CEILINGS — references via CEILING_NAME.
• FA_MC_BOOKS — references via CEILING_NAME for multiple reporting books.
• FA_MASS_RECLASS_ITF — references via the CEILING column in the interface table.
• FA_TAX_INTERFACE — references via CEILING_NAME.

In total, seven child tables depend on this hub object, reflecting its role as a central reference point for ceiling configuration across the Oracle Assets schema.