Search Results fa_inv_interface

Overview

The FA_INV_INTERFACE table is the Oracle Assets (OFA) open interface table for Physical Inventory processing. Physical inventory in Oracle Assets is the periodic exercise of verifying that assets recorded in the fixed asset register physically exist, and reconciling discrepancies such as missing tags, mislocated assets, and unrecorded units. The FA_INV_INTERFACE table serves as the staging area for data loaded from external sources — bar-code scanners, spreadsheet extracts produced by physical inventory teams, or third-party asset tracking systems — before the Physical Inventory reconciliation program validates and applies that data to the core asset inventory records.

The object resides in the FA schema and is documented as VALID in ETRM for 12.1.1 and 12.2.2. Under the heuristic Data Vault classification derived from its foreign key structure, FA_INV_INTERFACE is satellite-leaning: it holds descriptive and status-oriented attributes that qualify, reconcile, and track a parent inventory record identified by its natural business key, rather than acting as an independent hub. This classification is a modeling suggestion, not a physical implementation constraint.

Key Information Stored

The table contains 25 documented columns. The surrogate primary key is INVENTORY_ID, enforced by FA_INV_INTERFACE_PK and additionally backed by the unique index FA_INV_INTERFACE_U1 (INVENTORY_ID), which also serves as the candidate business key. The most operationally significant columns are:

INVENTORY_NAME — the natural-key value that ties the staged row to the parent FA_INVENTORY record via foreign key.
ASSET_ID, ASSET_NUMBER, ASSET_KEY_CCID — identifiers that link the inventory line to the specific asset being verified.
TAG_NUMBER, DESCRIPTION, MODEL_NUMBER, SERIAL_NUMBER, MANUFACTURER_NAME — physical identification attributes used to match scanned or observed assets to register records.
ASSET_CATEGORY_ID — the asset category assigned to the inventory line.
UNITS, UNIT_ADJ, UNIT_RECONCILE_MTH — the counted quantity, the adjustment quantity, and the reconciliation method applied to units.
LOCATION_ID, LOCATION_ADJ, LOC_RECONCILE_MTH — the observed location, the location adjustment, and the reconciliation method applied to location.
STATUS — the processing state of the interface row (for example, staged, validated, or applied).
DISTRIBUTION_ID, RECONCILIATION_ID — references to the distribution and reconciliation context controlling how the row is processed.
Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical usage centres on staging, validating, and reconciling physical inventory data. A common pattern is to identify rows that have not yet been processed for a given inventory batch:

SELECT inventory_id, inventory_name, asset_number, tag_number, units, status FROM fa.fa_inv_interface WHERE status IS NULL OR status = 'NEW';

Reconciliation reporting often aggregates unit and location adjustments by inventory name:

SELECT inventory_name, unit_reconcile_mth, loc_reconcile_mth, SUM(unit_adj) AS total_unit_adj, SUM(location_adj) AS total_loc_adj FROM fa.fa_inv_interface GROUP BY inventory_name, unit_reconcile_mth, loc_reconcile_mth;

Asset-level matching queries join back to the asset register on ASSET_ID or ASSET_NUMBER to compare counted units against book units. Because the table is an open interface, direct DML is normally performed only by the loading program; production OLTP access is limited to the Physical Inventory interface and reconciliation processes.

Related Objects

FA_INVENTORY — parent table referenced by FA_INV_INTERFACE.INVENTORY_NAME; the authoritative physical inventory definition.
CN_TRX_LINES_ALL — references FA_INV_INTERFACE.INVENTORY_ID, tying interface rows into transaction-line processing.
FA_ADDITIONS — the asset register table against which ASSET_ID and ASSET_NUMBER values are validated.
FA_CATEGORIES — source of ASSET_CATEGORY_ID values.
Oracle Assets Physical Inventory interface and reconciliation concurrent programs, which consume and clear rows from this table.

Table: FA_INV_INTERFACE 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_INV_INTERFACE, object_name:FA_INV_INTERFACE, status:VALID, product: OFA - Assets , description: Open Interface table to Physical Inventory , implementation_dba_data: FA.FA_INV_INTERFACE ,
Table: FA_INV_INTERFACE 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_INV_INTERFACE, object_name:FA_INV_INTERFACE, status:VALID, product: OFA - Assets , description: Open Interface table to Physical Inventory , implementation_dba_data: FA.FA_INV_INTERFACE ,
Table: FA_INVENTORY 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_INVENTORY, object_name:FA_INVENTORY, status:VALID, product: OFA - Assets , description: Physical Inventory entry , implementation_dba_data: FA.FA_INVENTORY ,
Table: FA_INVENTORY 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_INVENTORY, object_name:FA_INVENTORY, status:VALID, product: OFA - Assets , description: Physical Inventory entry , implementation_dba_data: FA.FA_INVENTORY ,
View: FA_INVENTORY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_INVENTORY_V, object_name:FA_INVENTORY_V, status:VALID, product: OFA - Assets , description: This view shows reconciliation information on assets that have been included in physical inventory , implementation_dba_data: APPS.FA_INVENTORY_V ,
View: FA_INV_INTERFACE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_INV_INTERFACE_V, object_name:FA_INV_INTERFACE_V, status:VALID, product: OFA - Assets , description: - Retrofitted , implementation_dba_data: APPS.FA_INV_INTERFACE_V ,
View: FA_INVENTORY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_INVENTORY_V, object_name:FA_INVENTORY_V, status:VALID, product: OFA - Assets , description: This view shows reconciliation information on assets that have been included in physical inventory , implementation_dba_data: APPS.FA_INVENTORY_V ,
View: FA_INV_INTERFACE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_INV_INTERFACE_V, object_name:FA_INV_INTERFACE_V, status:VALID, product: OFA - Assets , description: - Retrofitted , implementation_dba_data: APPS.FA_INV_INTERFACE_V ,