Search Results fa_hr_retirement_details




Overview
Explore in AI Chat

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

Overview

The FA_HR_RETIREMENT_DETAILS table is a standard Oracle E-Business Suite Assets (OFA) object that resides in the FA schema. Its documented purpose is to record the individual asset retirements that result from a mass retirement executed against an asset hierarchy. In other words, when a user performs a hierarchy-level mass retirement, Oracle Assets decomposes that single business action into discrete, per-asset retirement records, and this table persists the detail of each resulting item. It is therefore a transactional detail table that sits beneath the higher-level mass retirement process, and it is not a setup or reference table.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is assessed as standalone. This is a modeling suggestion rather than a strict rule: the table carries its own unique business key and does not participate as a hub, link, or satellite in a heavily normalized relationship graph. Its only documented foreign key points back to FA_RETIREMENTS, indicating a parent-child dependency rather than a broad network of associations.

Key Information Stored

The table contains 21 documented columns. The most operationally significant are listed below.

No separate surrogate primary key column beyond the composite business key is documented; the unique index serves as the business-key candidate.

Common Use Cases and Queries

Typical uses center on auditing and reconciling mass retirements. A common pattern is to retrieve all detail rows produced by a given batch or concurrent request:

  • Reconcile a mass retirement by listing each asset retired under a batch: SELECT asset_id, cost_retired, units_retired, status_code FROM fa.fa_hr_retirement_details WHERE batch_id = :batch_id AND book_type_code = :book ORDER BY asset_id;
  • Trace rejected retirements and their causes: filter on status_code and read rejection_reason.
  • Report total proceeds and cost of removal per batch for financial disclosure.
  • Link detail rows back to the parent via retirement_id to join with FA_RETIREMENTS.

Related Objects

  • FA_RETIREMENTS — Parent retirement record; joined on RETIREMENT_ID.
  • FA_ADDITIONS — Asset master data, joined on ASSET_ID.
  • FA_BOOK_CONTROLS — Asset books, joined on BOOK_TYPE_CODE.
  • FA_DEPRN_DETAIL — Depreciation detail for the retired asset.
  • FA_MASS_RETIREMENTS (or the mass retirement batch structures) — Source of the BATCH_ID grouping.