Search Results fa_adjustments_t_u1

Overview

FA.FA_ADJUSTMENTS_T is a transactional interface table within the Oracle E-Business Suite Fixed Assets (FA) module, owned by the FA schema and registered under FND Design Data as OFA.FA_ADJUSTMENTS_T. It serves as the staging and processing structure through which asset adjustment transactions are loaded, validated, and subsequently posted by the Fixed Assets adjustment concurrent programs. Rows represent individual asset-level adjustments—changes to depreciation attributes such as cost, method, life, salvage value, prorate convention, and ceiling—before those changes are committed to the permanent asset books.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone, meaning it does not behave as a classic hub, link, or satellite. This is consistent with its role as an operational staging table: it holds a transient, program-scoped set of records keyed by book, request, worker, and asset rather than a durable business entity. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, storing transactional data that is typically purged or superseded once the adjustment program completes.

Key Information Stored

The table contains 90 documented columns. The most operationally significant include:

• BOOK_TYPE_CODE — the depreciation book against which the adjustment applies.
• ASSET_NUMBER — the asset being adjusted.
• POSTING_STATUS — the lifecycle state of the staged row (for example, whether it has been processed or posted).
• REQUEST_ID and WORKER_ID — the concurrent request and worker assignment owning the batch of rows.
• BATCH_ID — groups related adjustment records.
• COST, ORIGINAL_COST, SALVAGE_VALUE, YTD_DEPRN, DEPRN_RESERVE — the core financial values being changed or carried forward.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, ADJUSTED_RATE, BASIC_RATE, PRORATE_CONVENTION_CODE — depreciation attribute adjustments.
• TRANSACTION_NAME — the adjustment type being applied.
• GROUP_ASSET_ID and ITC_AMOUNT_ID — foreign keys linking to grouped assets and investment tax credit rates.

The documented unique index FA_ADJUSTMENTS_T_U1 spans BOOK_TYPE_CODE, POSTING_STATUS, REQUEST_ID, WORKER_ID, ASSET_NUMBER, establishing the business-key candidate that prevents duplicate staging of the same asset within a given processing run. A non-unique index FA_ADJUSTMENTS_T_N1 on BATCH_ID supports batch-oriented access. The metadata does not document a separate single-column surrogate primary key; the unique index functions as the effective key.

Common Use Cases and Queries

Typical usage centers on monitoring and troubleshooting the adjustment posting process. A common query checks the status of a concurrent request:

• Select rows filtered by REQUEST_ID and POSTING_STATUS to identify assets that failed validation or remain unposted.
• Join to FA_ADDITIONS_B via ASSET_NUMBER and BOOK_TYPE_CODE to display asset descriptions alongside staged adjustments.
• Aggregate by BATCH_ID to review batch totals for COST, YTD_DEPRN, and DEPRN_RESERVE before and after adjustment.

Sample pattern:

SELECT a.asset_number, b.description, a.cost, a.ytd_deprn, a.posting_status
FROM   fa.fa_adjustments_t a, fa.fa_additions_b b
WHERE  a.asset_number = b.asset_number
AND    a.book_type_code = :book
AND    a.request_id = :req_id;

Reporting use cases include auditing depreciation method changes, verifying salvage value adjustments, and reconciling adjustments against FA_ADJUSTMENTS (the permanent table) to confirm successful posting.

Related Objects

• FA.FA_ITC_RATES — referenced via ITC_AMOUNT_ID, supplying investment tax credit rate definitions.
• FA.FA_GROUP_ASSETS — referenced via GROUP_ASSET_ID for grouped asset adjustments.
• FA.FA_ADDITIONS_B / FA_ADDITIONS_T — the primary asset master tables joined by ASSET_NUMBER and BOOK_TYPE_CODE.
• FA.FA_ADJUSTMENTS — the permanent adjustment history populated after staging is processed.
• FA.FA_BOOK_CONTROLS — defines the BOOK_TYPE_CODE and depreciation rules governing adjustments.
• FA.FA_DEPRN_SUMMARY — holds period depreciation balances affected once adjustments post.
• FA.FA_MASS_ADJUSTMENTS — related mass adjustment staging structure.