Search Results wsh_regions

Overview

The WSH_REGIONS table is a core reference table within the Oracle E-Business Suite Shipping Execution (WSH) module. It serves as the central repository for non-translated geographic region information, which is fundamental for defining and managing shipping logistics. The table's primary role is to store region codes and establish a hierarchical structure for geographic areas, enabling the system to model complex shipping lanes, calculate freight costs, and validate delivery locations. This structured geographic data is essential for the accurate execution and planning of shipments across the supply chain.

Key Information Stored

The table's structure is designed to capture region identifiers and their hierarchical relationships. While the full column list is not detailed in the provided metadata, the primary key is explicitly documented as REGION_ID. This column uniquely identifies each geographic region record. Based on its description of storing region hierarchy, the table likely contains additional columns such as a REGION_CODE, NAME, PARENT_REGION_ID (to define the hierarchy), and potentially attributes for region type or classification. The critical aspect is that this table holds the non-translated, base data for regions, which is then referenced by translated descriptive flexfields or other entities for user-facing descriptions.

Common Use Cases and Queries

This table is primarily used in setup, validation, and reporting scenarios within shipping operations. A common administrative task is querying the region hierarchy to understand geographic groupings. For reporting, analysts often join WSH_REGIONS to transactional tables like WSH_DELIVERY_DETAILS or WSH_NEW_DELIVERIES to analyze shipment volumes by origin or destination region. Furthermore, the table is integral to freight engine (FTE) configuration, as lanes are defined between specific origin and destination regions. A typical query pattern involves selecting regions or joining to related transactional data:

• SELECT region_id, region_code FROM wsh_regions WHERE parent_region_id = :p_country_id ORDER BY region_code;
• SELECT d.delivery_id, r.region_code AS ship_from_region FROM wsh_new_deliveries d, wsh_regions r WHERE d.ship_from_location_id = r.region_id;

Related Objects

The WSH_REGIONS table has defined relationships with several other EBS objects, as indicated by its foreign key constraints. Most notably, it is referenced by the FTE_LANES table twice: for the ORIGIN_ID and DESTINATION_ID columns. This directly supports the Freight Management functionality by allowing the definition of shipping lanes between specific geographic regions. While not listed in the excerpt, it is also commonly referenced by various shipping APIs, setup forms for defining shipping parameters, and potentially by location hierarchies (HR_LOCATIONS) within the HRMS module. Its data is foundational for the geographic dimension in Oracle EBS reporting.