Search Results inv_units

Overview

FA_INVENTORY_V is a seeded, VALID view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered as part of the OFA (Oracle Assets) product family. As documented in ETRM, the view "shows reconciliation information on assets that have been included in physical inventory." It consolidates the physical inventory interface staging records in FA_INV_INTERFACE with the corresponding asset definition, distribution history, and lookup descriptions, exposing a single denormalized result set for reconciliation reporting. Rather than acting as a transactional entry point, FA_INVENTORY_V is a reporting and inquiry object: it presents the outcome of the physical inventory process — whether inventoried units and locations agree with the system of record — by filtering FA_INV_INTERFACE rows to the statuses DIFFERENCE, TO RECONCILE, and RECONCILED. It is therefore most relevant to Asset Inventory reconciliation workflows, where discrepancies between counted and book quantities must be reviewed, corrected, or accepted.

Underlying Base Objects

The view is defined over five documented base objects, all referenced through APPS synonyms:

• FA_INV_INTERFACE — the driving table (aliased INV); supplies inventory identifier, name, asset reference, counted units, location, adjustment amounts, reconciliation methods, and status.
• FA_DISTRIBUTION_HISTORY — joined outer (aliased DH) on both ASSET_ID and DISTRIBUTION_ID; supplies the assigned units and distribution location for comparison against counted values.
• FA_ADDITIONS_B — joined outer on ASSET_ID (aliased A); supplies asset tag, category, key flexfield CCID, current units, manufacturer, serial, and model.
• FA_ADDITIONS_TL — joined outer on ASSET_ID with LANGUAGE = USERENV('LANG'); supplies the asset description.
• FA_LOOKUPS — joined three times (LU, LU2, LU3) against INVENTORY STATUS, INVENTORY UNIT METHOD%, and INVENTORY LOCATION METHOD lookup types to resolve codes into meanings.

All joins to the asset, distribution, and description tables are outer joins, which is significant: interface rows for assets not yet fully defined still appear, preserving the full reconciliation picture.

Key Columns

For the search term inv_location_id, the view exposes INV_LOCATION_ID, sourced as INV.LOCATION_ID from FA_INV_INTERFACE — the location recorded during the physical inventory count. It is distinct from DH_LOCATION_ID (DH.LOCATION_ID), which is the location held in FA_DISTRIBUTION_HISTORY. Comparing the two identifies location-level discrepancies.

• INVENTORY_ID / INVENTORY_NAME — identifies the physical inventory batch.
• ASSET_ID / ASSET_NUMBER / TAG_NUMBER — asset identity and tag.
• INV_UNITS vs. UNITS_ASSIGNED vs. CURRENT_UNITS — counted, historically assigned, and current book units.
• UNIT_ADJ / LOCATION_ADJ — unit and location adjustment indicators.
• STATUS / STATUS_LOOKUP_CODE — reconciliation state.
• UNIT_RECONCILE_MTH / LOC_RECONCILE_MTH — decoded reconciliation methods.
• ROW_ID, DISTRIBUTION_ID, ASSET_CATEGORY_ID, SERIAL_NUMBER — supporting identifiers for drill-down and joins.

Common Use Cases and Queries

Typical uses include physical inventory reconciliation reports, discrepancy listings by location or book, and ad hoc queries returning unmatched interface rows. A representative query referencing the searched column is:

SELECT inventory_name, asset_number, tag_number, inv_units, units_assigned,
  inv_location_id, dh_location_id, status, unit_reconcile_mth, loc_reconcile_mth
FROM apps.fa_inventory_v
WHERE status = 'DIFFERENCE'
  AND inv_location_id <> NVL(dh_location_id, -1)
ORDER BY inventory_name, asset_number;

Because the view already decodes lookups and filters to reconciliation-relevant statuses, it removes the need to join FA_LOOKUPS and FA_INV_INTERFACE manually, making it suitable for BLIT/BI Publisher reports and custom inquiry forms in both 12.1.1 and 12.2.2.