Search Results wms_org_hierarchy_objs




Overview
Explore in AI Chat

Overview

The WMS_ORG_HIERARCHY_OBJS table is a core data structure within the Warehouse Management System (WMS) module of Oracle E-Business Suite (EBS). Its primary role is to define and store the search order for sourcing strategies, a critical component of the WMS inventory allocation and fulfillment logic. In the context of order management, this table directly influences how the system locates inventory to satisfy sales orders, work orders, or other material requests. It enables the configuration of a prioritized list of subinventories, locators, or other warehouse objects within an organization, allowing for complex, rule-based inventory sourcing that optimizes warehouse operations and order fulfillment paths.

Key Information Stored

The table's structure centers on defining a hierarchy of warehouse objects for a specific organization and object type. Its primary key consists of three columns, establishing a unique entry for each object in the search sequence. The ORGANIZATION_ID links to the MTL_PARAMETERS table, identifying the inventory organization. The TYPE_CODE categorizes the kind of warehouse object being sequenced (e.g., subinventory, locator). The OBJECT_ID, linked to WMS_OBJECTS_B, identifies the specific warehouse object, such as a particular subinventory. The implicit sequence of rows for a given ORGANIZATION_ID and TYPE_CODE defines the search order, which is typically established and maintained through the WMS user interface, not by direct DML on this table.

Common Use Cases and Queries

The most prevalent use case is determining the prioritized list of sourcing locations for order fulfillment. For example, when processing a sales order line, the WMS engine queries this table to find the sequence of subinventories to search for available inventory. A typical analytical query would join this table to inventory and object tables to understand the configured sourcing hierarchy.

  • Sample Query to List Subinventory Search Order: SELECT whoo.organization_id, whoo.type_code, wob.object_name, wob.description FROM wms_org_hierarchy_objs whoo, wms_objects_b wob WHERE whoo.object_id = wob.object_id AND whoo.organization_id = :org_id AND whoo.type_code = 'SUBI' ORDER BY whoo.rowid;
  • Reporting Use Case: Auditing and documenting the configured sourcing strategies across multiple organizations to ensure compliance with business rules, such as prioritizing specific subinventories for certain sales channels.

Related Objects

WMS_ORG_HIERARCHY_OBJS is centrally connected to other fundamental WMS and Inventory tables. Its integrity is enforced by foreign key relationships to MTL_PARAMETERS (for the organization definition) and WMS_OBJECTS_B (for the warehouse object definition). The WMS_OBJECTS_B table is particularly crucial as it stores the master list of all configurable objects like subinventories, locators, and zones. This table is referenced by the WMS strategy engine during allocation processes. While not directly referenced in the provided metadata, it is intrinsically linked to the setup and execution of WMS sourcing rules, pick release, and allocation concurrent programs that drive order management fulfillment within the warehouse.