Search Results warehouse_id




Overview
Explore in AI Chat

Overview

WSH_BIS_SHIPPED_BY_DAY_V is a Business Intelligence (BIS) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Order Entry (OE) product family, though its name and underlying objects indicate it draws from Oracle Shipping Execution (WSH) data structures. The view aggregates shipping fill-rate metrics by warehouse and by day, providing a pre-summarized result set that supports operational reporting on order fulfillment performance.

Its defined purpose is to answer two related questions per warehouse-day bucket: how many scheduled shipments were due, and how many of those were actually filled. Because the aggregation is performed inside the view, consumers avoid the cost of scanning the granular fill-rate detail and can query a compact, ready-to-use result set. The view is read-only and is typically consumed by BIS reports, custom dashboards, Discoverer workbooks, or ad hoc SQL run against the APPS schema.

Underlying Base Objects

The only documented base object referenced by this view is another view: WSH_BIS_FILL_RATE_V. WSH_BIS_SHIPPED_BY_DAY_V is therefore a two-layer construct — a summarization layer built directly on top of the fill-rate detail view. The definition groups the detail rows by the truncated schedule date and by warehouse, then derives the aggregate counts. Because both layers are views rather than tables, no data is physically stored; every query executes the full definition at runtime, meaning performance depends on the base tables that ultimately feed WSH_BIS_FILL_RATE_V.

Key Columns

  • WAREHOUSE_ID — The warehouse (organization) identifier. This is the primary grouping dimension and the column most frequently used in filters, since reporting is almost always scoped to one or more specific warehouses. This is the column referenced in the user's search term.
  • DAY — The truncated SCHEDULE_DATE value, representing the day on which shipments were scheduled. It is the second grouping dimension.
  • NUMBER_DUE — The total count of rows in the under­lying detail view for that warehouse-day combination, i.e., the number of shipments scheduled.
  • NUMBER_FILLED — The count of records where the truncated schedule date equals the truncated date closed, indicating shipments that were completed on their scheduled day.

Common Use Cases and Queries

Typical scenarios include measuring daily fill-rate performance per warehouse, trend analysis of shipped-versus-due volume, and exception reporting for warehouses with low fill rates. A fill-rate percentage is easily derived as NUMBER_FILLED divided by NUMBER_DUE. Sample query:

  • SELECT warehouse_id, day, number_filled, number_due, ROUND(number_filled / NULLIF(number_due,0) * 100, 2) fill_pct FROM apps.wsh_bis_shipped_by_day_v WHERE warehouse_id = :p_warehouse ORDER BY day DESC;
  • SELECT warehouse_id, SUM(number_filled) total_filled, SUM(number_due) total_due FROM apps.wsh_bis_shipped_by_day_v WHERE day BETWEEN :from_date AND :to_date GROUP BY warehouse_id;