Search Results wms_strategies_b




Overview
Explore in AI Chat

Overview

The WMS_STRATEGIES_B table is a core master data table within the Oracle E-Business Suite Warehouse Management (WMS) module. It serves as the primary repository for defining picking and put-away strategies, which are rule-based methodologies that govern how inventory is selected for outbound orders and located for inbound receipts within a warehouse. These strategies are fundamental to automating and optimizing warehouse operations, directly influencing the efficiency of material transactions. The table stores the base, non-translatable attributes of each strategy, with its translatable name and description maintained in the related WMS_STRATEGIES_TL table.

Key Information Stored

The table's primary identifier is the STRATEGY_ID, a system-generated unique key. A critical column is ORGANIZATION_ID, which links the strategy to a specific inventory organization via a foreign key relationship to MTL_PARAMETERS, allowing for strategy definition at the organizational level. While the provided metadata does not list all columns, typical attributes stored in such a base table include creation and last update dates, the enabling status of the strategy, and potentially a strategy type code to distinguish between picking and put-away rule sets. The core definition of the strategy's logic and sequencing is stored in child tables, such as WMS_STRATEGY_MEMBERS.

Common Use Cases and Queries

This table is central to configuring and reporting on warehouse operational rules. Common use cases include auditing all strategies defined for an organization, identifying which strategies are assigned to specific subinventories or locators, and troubleshooting material transaction requests. A frequent reporting query involves joining the strategy base table with its translations and assignments. For example, to list all active picking strategies for an organization, one might use a SQL pattern such as:

  • SELECT ws.STRATEGY_ID, wst.NAME, ws.ORGANIZATION_ID FROM WMS_STRATEGIES_B ws, WMS_STRATEGIES_TL wst WHERE ws.STRATEGY_ID = wst.STRATEGY_ID AND wst.LANGUAGE = USERENV('LANG') AND ws.ORGANIZATION_ID = :org_id;

Strategies defined here are directly referenced during the creation of Material Transaction Requests (MTL_TXN_REQUEST_LINES) for both pick and put-away operations.

Related Objects

The WMS_STRATEGIES_B table maintains integral relationships with several key WMS and Inventory tables, as documented in the foreign key metadata.

  • Primary Key Dependency: WMS_STRATEGIES_B_PK on STRATEGY_ID.
  • Parent Table: MTL_PARAMETERS, joined via ORGANIZATION_ID, ties strategies to an inventory organization.
  • Child Tables (Referencing STRATEGY_ID):
    • WMS_STRATEGIES_TL: Stores translated names and descriptions.
    • WMS_STRATEGY_ASSIGNMENTS: Assigns strategies to specific subinventories, locators, or items.
    • WMS_STRATEGY_MEMBERS: Defines the sequential rules (members) that constitute the strategy.
  • Transactional Reference: MTL_TXN_REQUEST_LINES references STRATEGY_ID twice—via PICK_STRATEGY_ID and PUT_AWAY_STRATEGY_ID—to determine the rule set used for fulfilling each requested transaction line.