Search Results fa_inv_interface_u1

Overview

FA.FA_INV_INTERFACE is an Oracle E-Business Suite interface table residing in the FA (Fixed Assets) schema. It serves as the staging repository for inventory-derived asset information that is loaded into Oracle Assets through the Mass Additions process. Physical inventory and warehouse records, originating from Oracle Inventory and related manufacturing or distribution modules, are written into this table before Oracle Assets validates and converts each row into a fixed asset. The table lives in the APPS_TS_INTERFACE tablespace, reflecting its role as transient, batch-oriented interface storage rather than a transactional or master data object.

The FND Design Data reference is OFA.FA_INV_INTERFACE, and the object carries a VALID status in the documented release. Under the heuristic Data Vault classification supplied in the metadata, this table leans toward the satellite category: it carries descriptive and reconciling attributes attached to an inventory-driven business event rather than acting as a pure hub or an associative link. Modeling teams treating this as a satellite would place INVENTORY_ID or INVENTORY_NAME as the driving business key and the remaining descriptive fields as dependent attributes.

Key Information Stored

The table contains 25 documented columns. Its most significant entries include:

• INVENTORY_ID (NUMBER) — the primary key column backing the unique index FA_INV_INTERFACE_U1; the surrogate identifier for each interface row.
• INVENTORY_NAME (VARCHAR2 80) — the inventory item name and business-key candidate, indexed by the non-unique index FA_INV_INTERFACE_N1; it also participates in the FK relationship to FA_INVENTORY.
• ASSET_ID, ASSET_NUMBER, ASSET_KEY_CCID, TAG_NUMBER — the asset identity and accounting key flexfield reference.
• DESCRIPTION, MODEL_NUMBER, SERIAL_NUMBER, MANUFACTURER_NAME — descriptive attributes passed into the asset record.
• ASSET_CATEGORY_ID — links the staged row to the applicable asset category for depreciation and account derivation.
• UNITS, LOCATION_ID, STATUS — quantity, physical location, and processing status.
• UNIT_ADJ, UNIT_RECONCILE_MTH, LOCATION_ADJ, LOC_RECONCILE_MTH — reconciliation adjustments and the reconciliation method applied to units and location.
• DISTRIBUTION_ID, RECONCILIATION_ID — references to distribution and reconciliation tracking records.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.

The surrogate primary key is INVENTORY_ID, exposed through the unique index FA_INV_INTERFACE_U1 that the user searched for. INVENTORY_NAME serves as the principal business-key candidate and is separately indexed for lookup performance.

Common Use Cases and Queries

The primary use case is populating and reconciling physical inventory data before Mass Additions processing in Oracle Assets. Common queries include locating staged rows by inventory or asset identifier:

• Retrieve an interface row by business key: SELECT * FROM FA.FA_INV_INTERFACE WHERE INVENTORY_ID = :p_id;
• Look up by item name using the non-unique index: SELECT * FROM FA.FA_INV_INTERFACE WHERE INVENTORY_NAME = :p_name;
• Identify rows awaiting reconciliation: SELECT INVENTORY_ID, INVENTORY_NAME, STATUS, UNIT_ADJ, LOCATION_ADJ FROM FA.FA_INV_INTERFACE WHERE STATUS IS NULL OR UNIT_ADJ IS NOT NULL;

Reporting use cases include inventory-to-asset reconciliation reports, category assignment audits (via ASSET_CATEGORY_ID), and location adjustment tracking. The audit columns support change-tracking and purge routines for interface cleanup.

Related Objects

The metadata documents the following key relationships:

• FA.FA_INVENTORY — referenced through the FK on INVENTORY_NAME, providing the master inventory definition.
• CN_TRX_LINES_ALL — references FA_INV_INTERFACE via INVENTORY_ID on the transaction lines side.
• APPS.FA_INV_INTERFACE — the APPS-layer synonym or view through which the base table is commonly accessed.

Practically, this table also integrates with the Oracle Assets Mass Additions workflow, which consumes staged rows to create asset records in FA_ASSETS and related depreciation, book, and category tables. The unique index FA_INV_INTERFACE_U1 and the non-unique index FA_INV_INTERFACE_N1 are the primary access paths for all lookups against this object.