Search Results fa_inventory




Overview
Explore in AI Chat

Overview

FA_INVENTORY is a table in the FA (Assets) schema of Oracle E-Business Suite, belonging to the OFA - Assets product. It stores the definition and control records for physical inventory of assets — that is, the named inventory "runs" or "batches" used to reconcile the fixed asset register against assets physically observed at a location. Each row represents a discrete physical inventory entry identified by a unique inventory name, together with the date range over which the inventory is active and a purge indicator controlling downstream cleanup of related data.

In Data Vault modeling terms, the metadata classifies FA_INVENTORY as hub-leaning. This heuristic reflects the fact that the table is referenced by a foreign key from FA_INV_INTERFACE and that its durable business identity (INVENTORY_NAME) is stable while descriptive and control attributes (dates, purge flag, audit columns) behave like satellite attributes. A Data Vault implementation would therefore typically model INVENTORY_NAME as a hub key, with START_DATE, END_DATE, and RUN_PURGE_FLAG carried in an associated satellite, and a link to the interface records that reference the inventory.

Key Information Stored

The documented physical schema for 12.2.2 lists nine columns. The most significant are:

  • INVENTORY_NAME — The business identifier of the physical inventory entry. It is both the primary key (via FA_INVENTORY_PK) and the unique business key (via the unique index FA_INVENTORY_U1). Because the primary key is the business key rather than a generated surrogate, INVENTORY_NAME is the column used in all joins.
  • START_DATE — The date on which the physical inventory becomes effective.
  • END_DATE — The date on which the physical inventory is no longer active.
  • RUN_PURGE_FLAG — A control flag indicating whether purge processing should be run for this inventory, governing removal of associated interface or inventory detail rows.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing when and by whom the row was last modified.
  • CREATED_BY, CREATION_DATE — Standard audit columns recording row creation.

No surrogate sequence-generated identifier is documented; the audit columns follow the conventional WHO column pattern used throughout the EBS schema.

Common Use Cases and Queries

Typical reporting and integration scenarios include: (1) enumerating active physical inventories within a period; (2) resolving the inventory definition for rows staged in the interface table; and (3) confirming whether purge has been configured for a completed inventory.

A representative query listing open inventories:

  • SELECT inventory_name, start_date, end_date, run_purge_flag FROM fa.fa_inventory WHERE start_date >= :p_from_date AND end_date <= :p_to_date ORDER BY start_date;

Joining to the interface table to attribute staged physical inventory lines back to their parent inventory:

  • SELECT i.inventory_name, i.start_date, i.end_date, x.* FROM fa.fa_inventory i, fa.fa_inv_interface x WHERE i.inventory_name = x.inventory_name;

Because FA_INVENTORY is small and changes infrequently, it is well suited to being cached or extracted as a dimension alongside fact tables built from FA_INV_INTERFACE or asset inventory detail tables.

Related Objects

  • FA_INV_INTERFACE — The most significant dependent object. Its INVENTORY_NAME column carries a foreign key to FA_INVENTORY.INVENTORY_NAME, meaning every interface record is attributed to a defined physical inventory.
  • FA_INVENTORY_PK and FA_INVENTORY_U1 — The primary key constraint and unique index, both defined on INVENTORY_NAME, enforcing uniqueness of the inventory business key.
  • Other asset inventory and reconciliation objects in the OFA - Assets product (for example, asset inventory detail and physical inventory report programs) depend on FA_INVENTORY as the parent definition record, though the documented metadata for this object exposes only the FA_INV_INTERFACE relationship explicitly.

Oracle Proprietary, Confidential Information — Legal Notices.