Results for “fa_mass_ext_ret_excepts”

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

Overview

The FA_MASS_EXT_RET_EXCEPTS table is a standalone exception-staging object within the Oracle E-Business Suite (EBS) Assets module (OFA). It is owned by the FA schema and is documented as valid in both Oracle EBS 12.1.1 and 12.2.2. The table supports the Mass External Retirements interface, a programmatic facility that allows you to retire large volumes of assets in a single batch by loading externally prepared data rather than performing individual, online retirements.

When a batch of external retirement records is uploaded through the interface, Oracle Assets validates each row against business rules — such as a valid asset number, a valid book, a permissible retirement reason, and the absence of conflicting transactions. Rows that fail validation are not processed and are instead written to FA_MASS_EXT_RET_EXCEPTS, where they remain for review and correction. In effect, the table is an error queue, isolating rejected records so that valid rows may proceed without blocking the entire batch.

From a dimensional-modelling perspective, the ETRM heuristic Data Vault classification for this object is standalone. This suggests the table is best treated as an independent satellite (or exception-log entity) rather than a hub or link, because it does not act as a central business key repository. Its single documented foreign key points outward to the parent retirement batch, meaning it is a dependent child record rather than a shared integration point.

Key Information Stored

The table carries ten documented columns that together identify the failed attempt, its parent batch, and the reason for rejection.

• CONC_REQ_ID — the concurrent request identifier of the Mass External Retirements run that generated the exception. This ties each rejected row back to a specific execution of the interface program.
• BATCH_NAME — the user-defined or program-assigned name of the retirement batch being loaded.
• MASS_EXTERNAL_RETIRE_ID — the identifier of the parent retirement record; this is the documented foreign key to FA_MASS_EXT_RETIREMENTS.
• ASSET_ID — the surrogate key of the asset that could not be retired; joins to FA_ADDITIONS / FA_ASSET_HISTORY for asset detail.
• BOOK_TYPE_CODE — the depreciation book in which the retirement was attempted.
• REASON — the explanation code or text describing why the row was rejected.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_DATE — standard EBS WHO columns capturing insert and change history.

The documented structure does not expose a single-column surrogate primary key or a named unique index; in practice the row is identified by the composite of CONC_REQ_ID, BATCH_NAME, and MASS_EXTERNAL_RETIRE_ID. Business-key candidates for correction include ASSET_ID combined with BOOK_TYPE_CODE.

Common Use Cases and Queries

Typical usage centres on error triage after a mass retirement load.

• Post-run exception report — retrieve all failures for a given concurrent request:

SELECT BATCH_NAME, ASSET_ID, BOOK_TYPE_CODE, REASON
FROM   FA_MASS_EXT_RET_EXCEPTS
WHERE  CONC_REQ_ID = :request_id
ORDER  BY BATCH_NAME, ASSET_ID;

• Batch-level failure count — summarise exceptions by batch to gauge load quality.
• Asset drill-down — join to FA_ADDITIONS on ASSET_ID to display the asset number and description alongside the rejection reason.
• Reconciliation — after corrections are re-uploaded, query exceptions again to confirm they have cleared.

Related Objects

• FA_MASS_EXT_RETIREMENTS — parent table; the documented FK MASS_EXTERNAL_RETIRE_ID → FA_MASS_EXT_RETIREMENTS links each exception to its originating retirement record.
• FA_ADDITIONS — asset master; join on ASSET_ID.
• FA_BOOK_CONTROLS — depreciation books; join on BOOK_TYPE_CODE.
• FND_CONCURRENT_REQUESTS / FND_CONC_REQ_OUTPUTS — join on CONC_REQ_ID to identify the program run and its log.
• The concurrent program Mass External Retirements, which populates this table during validation.