Search Results wms_device_requests_hist




Overview
Explore in AI Chat

Overview

The WMS_DEVICE_REQUESTS_HIST table is a Warehouse Management System (WMS) history table that stores a complete record of all device requests submitted through Oracle EBS mobile and RF (radio frequency) device interfaces. It resides in the WMS schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. In the context of Oracle Warehouse Management, this table serves as the persistent audit trail for transactions initiated from handheld scanners, barcode devices, and other mobile hardware that communicate with the EBS WMS module. Each row represents a single device request, capturing the task context, inventory details, transaction quantities, device assignment, and request outcome.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning, based on its foreign key structure. This suggests that WMS_DEVICE_REQUESTS_HIST functions primarily as a descriptive satellite, holding attribute-rich historical data keyed to a parent entity rather than acting as a hub or link. The single documented foreign key, DEVICE_ID referencing WMS_DEVICES_B, reinforces this interpretation: the table attaches granular request history to the device hub.

Key Information Stored

The table contains 42 documented columns. The most significant include:

Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are also present, along with device status and reason identifiers.

Common Use Cases and Queries

WMS_DEVICE_REQUESTS_HIST is primarily used for auditing, troubleshooting, and performance analysis of mobile warehouse transactions. Common scenarios include tracing failed or rejected device requests, analyzing device throughput, and reconciling inventory movements against submitted transactions.

A typical query to retrieve recent requests for a specific device:

  • SELECT request_id, device_id, status_code, status_msg, request_date FROM wms.wms_device_requests_hist WHERE device_id = :device_id ORDER BY request_date DESC;

A query to analyze failures by task type:

  • SELECT task_type_id, status_code, COUNT(*) FROM wms.wms_device_requests_hist WHERE status_code != 'SUCCESS' GROUP BY task_type_id, status_code;

Reporting use cases include device utilization reports, exception dashboards highlighting non-successful requests, and reconciliation of transaction quantities against inventory balances.

Related Objects

The primary documented relationship is the foreign key from WMS_DEVICE_REQUESTS_HIST.DEVICE_ID to WMS_DEVICES_B, which defines the device master referenced by each request. Additional functionally related objects in the WMS module typically include:

These relationships make WMS_DEVICE_REQUESTS_HIST central to end-to-end traceability of mobile warehouse activity within Oracle EBS.