Search Results fa_adjustments_t




Overview
Explore in AI Chat

Overview

FA_ADJUSTMENTS_T is a temporary (staging) table in the Oracle Assets (OFA) schema, FA, used during the processing of impairment transactions and Extended Depreciation. Unlike the permanent transaction tables FA_ADJUSTMENTS and FA_TRANSACTION_HEADERS, this object serves as a transient workspace where the Impairment and Extended Depreciation programs accumulate candidate rows before final validation and posting. It is populated and consumed within a single concurrent program run, keyed to a REQUEST_ID and a WORKER_ID, and is not intended as a durable system of record.

Under a heuristic Data Vault classification mined from its foreign-key structure, the table is assessed as standalone. Where a warehouse-style model is desired, it is best treated as a transient staging satellite over the asset/book business key, since its rows carry descriptive depreciation attributes and are batch-scoped rather than accumulated history.

Key Information Stored

The table carries 90 documented columns, of which the most significant include:

The unique index FA_ADJUSTMENTS_T_U1 covers BOOK_TYPE_CODE, POSTING_STATUS, REQUEST_ID, WORKER_ID, ASSET_NUMBER, making this composite the business-key candidate for row identity. No surrogate single-column primary key is documented; the table is batch-scoped and identified operationally by REQUEST_ID and WORKER_ID. Foreign keys are defined to FA_ITC_RATES (via ITC_AMOUNT_ID) and FA_GROUP_ASSETS (via GROUP_ASSET_ID).

Common Use Cases and Queries

Primary use cases include investigating why an impairment or Extended Depreciation run produced, changed, or excluded specific assets, and reconciling the staged amounts against the final posted transaction.

  • Review staged rows for a specific concurrent request: 
    SELECT asset_number, book_type_code, cost, deprn_reserve,
       impairment_reserve, extended_deprn_flag, posting_status
FROM   fa.fa_adjustments_t
WHERE  request_id = :p_request_id
AND    book_type_code = :p_book
ORDER  BY asset_number;
  • Identify rows that failed posting validation: 
    SELECT asset_number, posting_status, transaction_name
FROM   fa.fa_adjustments_t
WHERE  request_id = :p_request_id
AND    posting_status <> 'POSTED';
  • Reconcile Extended Depreciation limits: 
    SELECT asset_number, extended_depreciation_period,
       extended_deprn_limit, allowed_deprn_limit_amount
FROM   fa.fa_adjustments_t
WHERE  extended_deprn_flag = 'Y'
AND    request_id = :p_request_id;

Because rows are transient, reporting should join to FA_ADDITIONS_B and FA_BOOKS for durable values, and filter aggressively on REQUEST_ID to avoid full scans.

Related Objects

  • FA_ITC_RATES — referenced through FA_ADJUSTMENTS_T.ITC_AMOUNT_ID.
  • FA_GROUP_ASSETS — referenced through FA_ADJUSTMENTS_T.GROUP_ASSET_ID.
  • FA_ADJUSTMENTS — the permanent adjustment/transaction table to which staged rows are ultimately posted or from which they are derived.
  • FA_TRANSACTION_HEADERS — groups transactions by TRANSACTION_HEADER_ID and book; useful for tracing batch context.
  • FA_ADDITIONS_B / FA_ADDITIONS_TL — the asset master, joined on ASSET_NUMBER or ASSET_ID.
  • FA_BOOKS — current depreciation balances per asset and BOOK_TYPE_CODE, used to validate staged amounts.
  • FA_DEPRN_SUMMARY — depreciation history used in Extended Depreciation reconciliation.
  • Impairment and Extended Depreciation concurrent programs and the FA_ADJUSTMENT API, which read and write this staging table during execution.