Results for “batch_limit”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS_DEVICES_B is the base (language-independent) definition table for warehouse devices in the Oracle E-Business Suite Warehouse Management (WMS) module. It stores the configured characteristics of each device — such as barcode scanners, RF terminals, label printers, and material-handling equipment — that is registered against a specific warehouse organization. Because it is a "_B" table, it holds the descriptive attributes, while translatable text (device name and description) is held in the companion WMS_DEVICES_TL table.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as hub-leaning. It functions as a central entity hub keyed on the surrogate device identifier, with most of its 38 columns acting as descriptive satellite attributes and a modest set of outbound and inbound links to other warehouse objects.

Key Information Stored

• DEVICE_ID — the surrogate primary key, enforced by WMS_DEVICES_B_PK1 and also backed by unique index WMS_DEVICES_B_U1. This is the definitive business-key candidate for the table.
• DEVICE_TYPE_ID — classifies the device (for example RF scanner, printer, or terminal) and drives behavioral defaults.
• ORGANIZATION_ID — the warehouse organization the device belongs to; foreign key to MTL_PARAMETERS.
• ENABLED_FLAG — indicates whether the device is active and available for use.
• INPUT_METHOD_ID / OUTPUT_METHOD_ID — the configured input and output method identifiers for reading and writing device data.
• LOT_SERIAL_CAPABLE — flags whether the device can capture lot and serial numbers during transactions.
• BATCH_LIMIT — the maximum number of records the device processes per batch.
• SUBINVENTORY_CODE — the default subinventory associated with the device.
• LOCATOR_ID — the default locator tied to the device.
• DEVICE_MODEL — the hardware or model descriptor of the physical device.
• NOTIFICATION_FLAG, FORCE_SIGN_ON_FLAG, MULTI_SIGN_ON — operational control flags governing notifications and sign-on behavior.
• MESSAGE_TEMPLATE_ID — links the device to its output message template.

The table also carries standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the 15 generic ATTRIBUTE columns with ATTRIBUTE_CATEGORY for extensibility.

Common Use Cases and Queries

Typical uses include listing active devices by organization, auditing device configuration, and joining to MTL_PARAMETERS to resolve the owning warehouse. A representative query returns enabled devices for a warehouse:

SELECT d.DEVICE_ID, d.DEVICE_MODEL, d.ENABLED_FLAG
FROM   WMS.WMS_DEVICES_B d
WHERE  d.ORGANIZATION_ID = :org_id
AND    d.ENABLED_FLAG = 'Y';

Reporting scenarios include reconciliation of devices by type, capacity planning via BATCH_LIMIT, and resolving human-readable names by joining to WMS_DEVICES_TL on DEVICE_ID for the appropriate language. Auditing queries frequently filter on the LAST_UPDATE_DATE and LAST_UPDATED_BY columns to trace configuration changes.

Related Objects

• WMS_DEVICES_TL — stores translatable device names/descriptions; join on WMS_DEVICES_TL.DEVICE_ID = WMS_DEVICES_B.DEVICE_ID.
• MTL_PARAMETERS — the warehouse organization master; join on WMS_DEVICES_B.ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID.
• WMS_BUS_EVENT_DEVICES — maps business events to devices; references WMS_DEVICES_B.DEVICE_ID.
• WMS_DEVICE_REQUESTS_HIST — historical device request records keyed by DEVICE_ID, useful for activity reporting.

These relationships confirm WMS_DEVICES_B as the hub for device configuration data referenced across WMS device transactions.