Search Results end_onh_val_b




Overview
Explore in AI Chat

Overview

APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV is a reporting view in the Oracle E-Business Suite Process Manufacturing (OPM) module that surfaces daily inventory status balances for the Enterprise Data Warehouse (EDW) layer. The name follows the OPI_EDW naming convention, where "OPI" designates Process Manufacturing Intelligence, "EDW" designates the data warehouse staging/consumption layer, and "_FCV" indicates a foreign-key-conformed view. This view is intended for analytical reporting and integration into downstream warehouse fact tables rather than for transactional processing.

The view assembles a composite daily inventory status record per organization, warehouse, location, item, lot, and transaction date, drawing from OPM inventory summary tables (aliased OPMSUM) and joined to instance, item, organization, and currency metadata. Its central purpose is to present beginning, average, and ending on-hand quantities and values (in both base and global currencies) alongside inter-org transfer quantities and values — the classic daily inventory statistics extract used in inventory value reporting.

Notably, the source query references the column BEG_ONH_VAL_B, which is the documented search term (beg_onh_val_b). This column carries the beginning on-hand valuation in the base currency and is a key measure exposed by the view.

Underlying Base Objects

ETRM documents no referenced base objects for this view, meaning the metadata excerpt does not enumerate the tables underlying the SELECT. The view text, however, references several aliased sources:

  • OPMSUM — the OPM daily inventory summary source providing CO_CODE, ORGN_CODE, WHSE_CODE, LOCATION, ITEM_ID, TRX_DATE, LOT_ID, and the on-hand quantity/value measures.
  • GPM — the Process Manufacturing financial/book source supplying SOB_ID and BASE_CURRENCY_CODE.
  • INST — instance metadata providing INSTANCE_CODE.
  • MSI / IWM / ILM / IIM / MP — item master, inventory organization, locator, locator-control, and organization parameter sources used to resolve the item-org and locator foreign keys.
  • UOM — unit of measure definitions for base UOM resolution.

The view also invokes EDW utility packages — EDW_UTIL, EDW_ORGANIZATION_PKG, EDW_ITEMS_PKG, edw_mtl_inventory_loc_pkg, EDW_TIME_PKG, and EDW_CURRENCY — to derive surrogate foreign keys and convert base-currency values into global currency.

Key Columns

Common Use Cases and Queries

This view supports daily inventory valuation reporting, period-to-date balance trending, and EDW fact loading. A representative query filtering ending on-hand valuation for a specific item and date range:

  • SELECT INV_ORG_FK, ITEM_ORG_FK, TRX_DATE_FK, BEG_ONH_QTY, BEG_ONH_VAL_B, END_ONH_VAL_B FROM APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV WHERE ITEM_ORG_FK = :item AND TRX_DATE_FK BETWEEN :from_dt AND :to_dt;
  • SELECT TRX_DATE_FK, SUM(END_ONH_VAL_G) FROM APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV GROUP BY TRX_DATE_FK ORDER BY TRX_DATE_FK;
  • SELECT BEG_ONH_VAL_B, BEG_ONH_VAL_G FROM APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV WHERE LOT_FK IS NOT NULL;

Because it is a view rather than a table, queries should be restricted to bounded date ranges and specific organizations to limit the cost of the embedded currency conversion and key-derivation calls. The view is read-only and intended for reporting consumption.