Search Results wsh_shipping_parameters_u1

Overview

WSH.WSH_SHIPPING_PARAMETERS is a seed-level configuration table in the Oracle E-Business Suite Shipping Execution module. It stores the shipping execution parameters that govern Pick Release, Pick Confirm, Ship Confirm, packing, trip closure, freight calculation, and export compliance behavior for each inventory organization. Because Oracle Shipping operates at the organization level, the table contains one row per inventory organization, and every Warehouse Management or Order Management transaction that touches outbound logistics consults the applicable row to determine defaulting, validation, and auto-processing behavior.

The table resides in the APPS_TS_SEED tablespace, consistent with its role as reference and setup data rather than high-volume transactional data. Under a heuristic Data Vault classification, WSH_SHIPPING_PARAMETERS models as a standalone reference table with no upstream foreign-key parents, meaning it can be treated as a hub-like or standalone dimension rather than a satellite or link. This characterization is a modeling suggestion derived from the absence of inbound foreign keys, not an ETRM-declared classification.

Key Information Stored

The surrogate primary key is ORGANIZATION_ID, enforced through the WSH_SHIPPING_PARAMETERS_PK constraint. The ETRM metadata also documents WSH_SHIPPING_PARAMETERS_U1 as a unique NORMAL index on ORGANIZATION_ID in APPS_TS_SEED, which means the unique index and the primary key are effectively co-located on the same business-key candidate column. ORGANIZATION_ID identifies the inventory organization whose shipping behavior the row controls.

The most operationally significant columns include:

• GOODS_DISPATCHED_ACCOUNT — the accounting flexfield used by the Inventory Interface when cost of goods dispatched is transferred.
• WEIGHT_UOM_CLASS / VOLUME_UOM_CLASS / WEIGHT_UOM_CODE / VOLUME_UOM_CODE — UOM classification and codes used for weight and volume validation.
• WEIGHT_VOLUME_FLAG — controls whether weight and volume are calculated manually (M) or automatically (A).
• PERCENT_FILL_BASIS_FLAG — determines fill percentage basis by quantity (Q), volume (V), or weight (W).
• PICK_SEQUENCE_RULE_ID / PICK_GROUPING_RULE_ID — foreign keys into the WSH_PICK_SEQUENCE_RULES table that drive pick sequencing and grouping.
• PRINT_PICK_SLIP_MODE — whether pick slips print immediately (I) or at end of pick release (E).
• PACK_SLIP_REQUIRED_FLAG — enforces pack slip printing at Ship Confirm.
• AUTOCREATE_DEL_ORDERS_FLAG / AUTOCREATE_DELIVERIES_FLAG — govern automatic delivery grouping during Pick Release.
• DEFAULT_STAGE_SUBINVENTORY / DEFAULT_STAGE_LOCATOR_ID — default staging location used when moving picked material.
• SHIP_CONFIRM_RULE_ID — foreign key into WSH_SHIP_CONFIRM_RULES controlling ship confirm processing.
• TRIP_REPORT_SET_ID / DELIVERY_REPORT_SET_ID / PICK_RELEASE_REPORT_SET_ID — default report sets for trip close, ship confirm, and pick release.

The table also carries WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the standard 15 ATTRIBUTE flex columns.

Common Use Cases and Queries

Shipping administrators query this table to audit or compare organization-level behavior across the enterprise. A typical query retrieving core shipping configuration for a given organization is:

• SELECT organization_id, weight_volume_flag, pick_sequence_rule_id, pick_grouping_rule_id, print_pick_slip_mode, pack_slip_required_flag FROM wsh.wsh_shipping_parameters WHERE organization_id = :org_id;
• Comparing auto-create delivery flags across organizations: SELECT organization_id, autocreate_del_orders_flag, autocreate_deliveries_flag FROM wsh.wsh_shipping_parameters;
• Identifying organizations using automatic weight/volume calculation: SELECT organization_id FROM wsh.wsh_shipping_parameters WHERE weight_volume_flag = 'A';
• Locating organizations mapped to a specific pick rule for impact analysis before modifying WSH_PICK_SEQUENCE_RULES.

Reporting use cases include setup migration validation between environments, troubleshooting pick release or ship confirm behavior, and documenting freight tolerance configuration through FPA_POSITIVE_TOL_AMT and FPA_NEGATIVE_TOL_AMT.

Related Objects

The ETRM metadata documents the following foreign-key relationships from WSH_SHIPPING_PARAMETERS:

• WSH_PICK_SEQUENCE_RULES — referenced via PICK_SEQUENCE_RULE_ID.
• WSH_PICK_GROUPING_RULES — referenced via PICK_GROUPING_RULE_ID.
• WSH_SHIP_CONFIRM_RULES — referenced via SHIP_CONFIRM_RULE_ID.

Operationally, the table is also consumed by Shipping Execution pick release and ship confirm concurrent programs, by the WSH_DELIVERY_DETAILS and WSH_DELIVERY_ASSIGNMENTS transactional tables that inherit organization-level defaulting, and by the pick slip and packing slip report sets referenced through the report set columns. Inventory organizations are defined in MTL_PARAMETERS and ORG_ORGANIZATION_DEFINITIONS, whose ORGANIZATION_ID values correspond to the primary key here.