Search Results wsh_shipping_parameters




Overview
Explore in AI Chat

Overview

WSH_SHIPPING_PARAMETERS is the organization-level configuration table for Oracle Shipping Execution (WSH) in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds the operational defaults, picking and packing rules, delivery grouping options, freight and export-screening settings, and workflow/OTM integration flags that govern how a given inventory organization performs outbound shipping. Because shipping behavior in EBS is defined per organization rather than globally, this table acts as the central control record consulted by the Shipping Transaction window, the Autocreate Delivery process, Pick Confirm, Ship Confirm, and the various shipping report and label programs.

The documented primary key is WSH_SHIPPING_PARAMETERS_PK on ORGANIZATION_ID, and a unique index WSH_SHIPPING_PARAMETERS_U1 (ORGANIZATION_ID) is recorded — indicating a strict one-row-per-organization model. In Data Vault terms, the heuristic classification is standalone; from a modeling perspective this suggests a compact reference or configuration dataset keyed naturally by ORGANIZATION_ID, with no dependent child structure within the table itself. Its foreign keys reach outward to rule tables, confirming its role as an assembly point for shipping rule configuration rather than a transactional fact source.

Key Information Stored

Common Use Cases and Queries

Typical scenarios include auditing shipping configuration differences across organizations, diagnosing why pick slips or deliveries behave inconsistently, and building reports on automation flags prior to a rollout. A common query retrieves the parameters for a specific organization:

  • SELECT organization_id, enforce_packing_flag, autocreate_deliveries_flag, pick_sequence_rule_id FROM wsh_shipping_parameters WHERE organization_id = :org_id;
  • Comparing grouping and freight automation flags across organizations to standardize carrier selection.
  • Joining PICK_SEQUENCE_RULE_ID to WSH_PICK_SEQUENCE_RULES to display the human-readable rule name alongside the parameter record.
  • Reporting on OTM_ENABLED and RAISE_BUSINESS_EVENTS to confirm integration readiness before enabling Transportation Management.

Related Objects