Search Results fa_ext_inv_retirements




Overview
Explore in AI Chat

Overview

The FA_EXT_INV_RETIREMENTS table is a component of the Oracle Assets (OFA) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the FA schema and is classified as a VALID table object. Its documented purpose is to record external invoice retirements, specifically identifying the source line or lines that are to be retired by a mass external retirement process. Within the broader asset lifecycle, this table functions as an intermediary staging and reference structure that links a mass external retirement header to the individual source transaction lines being retired.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone. This suggests that the table is not strongly integrated into an elaborate hub-and-link network based on the mined relationships alone; it references a single parent table and does not appear to be referenced by other tables within the documented relationship set. In practical terms, it behaves as a dependent detail table anchored to the mass external retirement entity.

Key Information Stored

The documented physical schema for 12.2.2 contains four columns. The most significant columns are as follows:

  • MASS_EXTERNAL_RETIRE_ID — The foreign key column referencing FA_MASS_EXT_RETIREMENTS. This identifies the parent mass external retirement record to which the source line belongs. It is the principal linkage that ties each detail row back to a retirement run.
  • SOURCE_LINE_ID — Identifies the source transaction line that is subject to retirement. This is a business-key candidate in the sense that it distinguishes individual lines within the retirement scope.
  • COST_RETIRED — Holds the cost amount being retired for the associated source line. This supports financial reporting and reconciliation of retirement amounts.
  • SOURCE_LINE_ID_RETIRED — Represents the source line identifier that has been retired. Its presence alongside SOURCE_LINE_ID suggests a mapping or confirmation of the retirement action against the original source line.

No surrogate primary key beyond the documented columns is explicitly enumerated in the provided metadata; the parent identifier MASS_EXTERNAL_RETIRE_ID combined with the source line identifiers forms the practical composite relationship. Unique index documentation is not provided, so business-key uniqueness should be verified against the actual database dictionary in a live environment.

Common Use Cases and Queries

Typical scenarios for this table involve auditing mass external retirements, reconciling retired costs to source invoice lines, and tracing which lines were included in a given retirement run. A representative query joining the detail table to its parent is:

  • SELECT r.MASS_EXTERNAL_RETIRE_ID, r.SOURCE_LINE_ID, r.COST_RETIRED, r.SOURCE_LINE_ID_RETIRED FROM FA.FA_EXT_INV_RETIREMENTS r WHERE r.MASS_EXTERNAL_RETIRE_ID = :mass_external_retire_id;
  • Reporting use cases include summarizing total cost retired per mass external retirement run, comparing expected versus retired source lines, and producing audit extracts for external invoice retirement activity.

Related Objects

The documented foreign key relationship establishes the primary dependency. The most significant related objects include:

  • FA_MASS_EXT_RETIREMENTS — The parent table referenced by FA_EXT_INV_RETIREMENTS.MASS_EXTERNAL_RETIRE_ID. It holds the mass external retirement header information.
  • Other Oracle Assets retirement and transaction tables, such as mass retirement and asset transaction interfaces, may be joined through the parent identifier to provide a complete retirement picture.
  • The Oracle Assets accounting and depreciation structures, referenced via the parent retirement records, provide the financial context for COST_RETIRED amounts.

Because the metadata classifies this object as standalone, dependent objects referencing it directly are not documented. Practitioners should confirm any additional joins through the parent mass external retirement entity.