Search Results fa_deprn_override




Overview
Explore in AI Chat

Overview

FA_DEPRN_OVERRIDE is a transactional table in the Oracle E-Business Suite Fixed Assets (OFA) module, owned by the FA schema. It implements the Depreciation Override feature, which allows users to manually specify a depreciation amount for a given asset in a given period instead of relying on the standard depreciation program calculation. This capability is typically used to correct or adjust calculated depreciation without altering the underlying asset cost, method, or life.

The table is classified as VALID in the ETRM 12.2.2 documentation and contains 20 documented columns. Based on the foreign key structure—references to FA_BOOK_CONTROLS via BOOK_TYPE_CODE and FA_ADDITIONS_B via ASSET_ID—the heuristic Data Vault classification is link. This suggests modeling FA_DEPRN_OVERRIDE as an associative entity between the depreciation book and the asset, carrying descriptive measures such as the override depreciation amount.

Key Information Stored

The primary key is DEPRN_OVERRIDE_ID, a surrogate identifier enforced by the FA_DEPRN_OVERRIDE_PK constraint and reinforced by the unique index FA_DEPRN_OVERRIDE_U1. The primary business identifiers are BOOK_TYPE_CODE, which ties the override to a depreciation book, and ASSET_ID, which ties it to a specific asset in FA_ADDITIONS_B.

Common Use Cases and Queries

Administrators and reporting developers query FA_DEPRN_OVERRIDE to reconcile manual overrides against calculated depreciation, audit who entered overrides, and verify which overrides were applied during a depreciation run.

  • Listing active overrides for a book and period: 
    SELECT deprn_override_id, asset_id, period_name, deprn_amount
FROM   fa.fa_deprn_override
WHERE  book_type_code = :book
AND    period_name    = :period
AND    status = 'ACTIVE';
  • Joining to FA_ADDITIONS_B to display asset numbers: 
    SELECT a.asset_number, o.period_name, o.deprn_amount
FROM   fa.fa_deprn_override o
JOIN   fa.fa_additions_b a ON a.asset_id = o.asset_id
WHERE  o.book_type_code = :book;
  • Auditing overrides created by a concurrent request using REQUEST_ID or TRANSACTION_HEADER_ID to trace back to the source process.
  • Filtering on USED_BY to confirm whether the depreciation program has consumed each override.

Related Objects

  • FA_BOOK_CONTROLS – Joined on BOOK_TYPE_CODE; defines the depreciation book governing the override.
  • FA_ADDITIONS_B – Joined on ASSET_ID; supplies the asset definition being overridden.
  • FA_DEPRN_SUMMARY – Stores calculated depreciation results against which overrides are compared.
  • FA_DEPRN_DETAIL – Period-level depreciation detail frequently reconciled with override amounts.
  • FA_TRANSACTION_HEADERS – Related via TRANSACTION_HEADER_ID when overrides are transaction-driven.
  • FND_CONCURRENT_REQUESTS – Related via REQUEST_ID to identify the originating concurrent process.