Results for “ship_method_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WSH_SHIP_CONFIRM_RULES is a Shipping Execution (WSH) configuration table that stores automated ship confirm rules in Oracle E-Business Suite 12.1.1 and 12.2.2. Ship confirm is the transaction that closes the picking and shipping cycle, relieving inventory, updating order lines, and triggering downstream interface activity such as Advance Shipping Notices (ASNs). Rather than forcing operators to specify every ship confirm option manually, Oracle EBS allows administrators to define reusable rules that prescribe default actions and flags for the ship confirm process.
Each row in this table represents one named, time-bound rule. Rules are date-effective: an EFFECTIVE_START_DATE and EFFECTIVE_END_DATE bracket the period during which the rule is valid, and a NAME (enforced unique through the WSH_SHIP_CONFIRM_RULES_U1 index) identifies the rule for selection by users and setup screens. The table is referenced from several operational objects — picking rules, picking batches, and shipping parameters — so a single rule definition can be reused consistently across shipping workflows. From a heuristic Data Vault modeling perspective, the mined FK structure classifies this table as standalone; in Data Vault terms it behaves as a reference or configuration hub, since it is a source of authoritative rule identities that other objects point to rather than a transactional link or a pure descriptive satellite.
Key Information Stored
The surrogate primary key is SHIP_CONFIRM_RULE_ID, defined by the WSH_SHIP_CONFIRM_RULES_PK constraint and used as the foreign key target by dependent tables. The business-key candidate is NAME, enforced by the unique index WSH_SHIP_CONFIRM_RULES_U1, and effective dating is captured through EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
Behavioral control columns determine how the ship confirm executes:
- ACTION_FLAG — drives the primary action taken during ship confirm.
- STAGE_DEL_FLAG — controls deletion of staged delivery details.
- SHIP_METHOD_CODE and SHIP_METHOD_DEFAULT_FLAG — assign or default the shipping method.
- AC_ACTUAL_DEP_DATE_DEFAULT, AC_INTRANSIT_FLAG, AC_CLOSE_TRIP_FLAG, AC_BOL_FLAG, AC_DEFER_INTERFACE_FLAG — autocreate (AC) options governing departure date defaulting, in-transit status, trip closure, bill of lading handling, and deferral of the order management interface.
- MC_INTRANSIT_FLAG, MC_CLOSE_TRIP_FLAG, MC_DEFER_INTERFACE_FLAG, MC_BOL_FLAG — manual confirm (MC) equivalents for the same decisions.
- REPORT_SET_ID — identifies the report set invoked during processing.
- SEND_945_FLAG — controls whether the 945 (warehouse shipping advice) EDI transaction is transmitted.
Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) support change tracking.
Common Use Cases and Queries
Typical uses include identifying the currently active rule for a warehouse or batch, auditing which flags are enabled for a given rule, and reporting on configuration drift across environments.
To list currently effective rules:
- SELECT ship_confirm_rule_id, name, effective_start_date, effective_end_date FROM wsh_ship_confirm_rules WHERE SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE);
To trace which batches use a rule:
- SELECT b.* FROM wsh_picking_batches b, wsh_ship_confirm_rules r WHERE b.ship_confirm_rule_id = r.ship_confirm_rule_id AND r.name = :rule_name;
Reporting commonly focuses on SEND_945_FLAG, ACTION_FLAG, and the AC_/MC_ flag pairs to verify that automated interface behavior matches business policy.
Related Objects
Documented foreign keys referencing this table are:
- WSH_PICKING_RULES.SHIP_CONFIRM_RULE_ID → WSH_SHIP_CONFIRM_RULES
- WSH_SHIPPING_PARAMETERS.SHIP_CONFIRM_RULE_ID → WSH_SHIP_CONFIRM_RULES
- WSH_PICKING_BATCHES.SHIP_CONFIRM_RULE_ID → WSH_SHIP_CONFIRM_RULES
WSH_SHIPPING_PARAMETERS supplies the default ship confirm rule at the organization level, while WSH_PICKING_RULES and WSH_PICKING_BATCHES attach rules to picking and batch execution. Related WSH tables such as WSH_DELIVERIES, WSH_DELIVERY_ASSIGNMENTS, and the ship confirm APIs (WSH_DELIVERY_DETAILS_PUB / ship confirm public APIs) consume the resulting confirmations rather than referencing this configuration table directly. The WSH_PICKING_BATCHES, WSH_PICKING_RULES, and WSH_SHIPPING_PARAMETERS joins remain the most significant functional dependencies.
-
Automated Ship Confirm Rules
-
View: WSH_PICKING_UPGRADE_V 12.2.2
APPS.WSH_PICKING_UPGRADE_V·↳ SO_PICKING_LINES_ALL·↳ SO_PICKING_LINE_DETAILS·↳ WSH_DEPARTURES·Explore WSH module →
-
View: WSH_SS2_SHIPMENT_V 12.2.2
APPS.WSH_SS2_SHIPMENT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ ORG_ORGANIZATION_DEFINITIONS·Explore WSH module →
-
Carrier Ship Methods
-
APPS.WSH_CARRIER_SHIP_METHODS_V·↳ FND_LOOKUP_VALUES_VL·↳ MTL_PARAMETERS·↳ ORG_FREIGHT_VL·Explore WSH module →
-
View: WSH_TRIPS_OB_GRP_V 12.1.1
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
APPS.WSH_DELIVERY_LINE_STATUS_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOCATIONS·Explore WSH module →
-
View: WSH_STND_CONTAINERS_V 12.2.2
APPS.WSH_STND_CONTAINERS_V·↳ FND_ID_FLEX_STRUCTURES_VL·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·Explore WSH module →
-
APPS.WSH_NEW_DELIVERIES_OB_GRP_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
Table: WSH_CARRIER_SERVICES 12.2.2
Carrier Services Information
-
View: WSH_TRIPS_OB_GRP_V 12.2.2
-
APPS.WSH_CARRIER_SHIP_METHODS_V·↳ FND_LOOKUP_VALUES_VL·↳ MTL_PARAMETERS·↳ ORG_FREIGHT_VL·Explore WSH module →
-
View: WSH_SS_CONTAINERS_V 12.2.2
APPS.WSH_SS_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
APPS.WSH_DELIVERY_LINE_STATUS_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOCATIONS·Explore WSH module →
-
Automated Ship Confirm Rules
-
Table: WSH_CARRIER_SERVICES 12.1.1
Carrier Services Information
-
APPS.WSH_NEW_DELIVERIES_OB_GRP_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_PICKING_UPGRADE_V 12.1.1
APPS.WSH_PICKING_UPGRADE_V·↳ SO_PICKING_LINES_ALL·↳ SO_PICKING_LINE_DETAILS·↳ WSH_DEPARTURES·Explore WSH module →
-
View: WSH_ITM_CONTAINERS_V 12.1.1
Temporary Table to return WSH_SS_CONTAINERS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
APPS.WSH_SHIP_CONFIRM_RULES_V·↳ FND_LOOKUP_VALUES_VL·↳ WSH_REPORT_SETS·↳ WSH_SHIP_CONFIRM_RULES·Explore WSH module →
-
APPS.WSH_SHIP_CONFIRM_RULES_V·↳ FND_LOOKUP_VALUES_VL·↳ WSH_REPORT_SETS·↳ WSH_SHIP_CONFIRM_RULES·Explore WSH module →
-
View: WSH_TRIPS_V 12.2.2
APPS.WSH_TRIPS_V·↳ WSH_LOOKUPS·↳ WSH_TRIPS·Explore WSH module →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
View: WSH_CARRIER_SERVICES_V 12.2.2
APPS.WSH_CARRIER_SERVICES_V·↳ FND_LOOKUP_VALUES_VL·↳ WSH_CARRIER_SERVICES·Explore WSH module →
-
View: WSH_DELIVERY_TRIPS_V 12.2.2
APPS.WSH_DELIVERY_TRIPS_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES·↳ WSH_TRIPS_V·Explore WSH module →
-
APPS.WSH_DELIVERABLE_TRIPS_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_NEW_DELIVERIES_V 12.1.1
APPS.WSH_NEW_DELIVERIES_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
Picking Batches
-
View: WSH_PICKING_RULES_V 12.2.2
APPS.WSH_PICKING_RULES_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore WSH module →
-
Table to store picking line details information during upgrade from 11 to 11i
-
Table to store picking line details information during upgrade from 11 to 11i
-
Carrier Ship Methods
-
View: WSH_SS_CONTAINERS_V 12.1.1
APPS.WSH_SS_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
Trips Interface Table
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH module →
-
View: WSH_TRIP_DELIVERIES_V 12.1.1
APPS.WSH_TRIP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIPS·Explore WSH module →
-
View: WSH_TRIP_DELIVERIES_V 12.2.2
APPS.WSH_TRIP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIPS·Explore WSH module →
-
View: WSH_ITM_CONTAINERS_V 12.2.2
Temporary Table to return WSH_SS_CONTAINERS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_PICKING_BATCHES_V 12.2.2
/* Bug: 1924581 , HR_LOCATION changes made on 8/15/01
APPS.WSH_PICKING_BATCHES_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
View: WSH_PICKING_RULES_V 12.1.1
APPS.WSH_PICKING_RULES_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore WSH module →
-
Trips Interface Table
-
View: WSH_DEL_DTL_ASSGN_V 12.2.2
APPS.WSH_DEL_DTL_ASSGN_V·↳ WSH_DEL_ASSGN_INTERFACE·↳ WSH_DEL_DETAILS_INTERFACE·Explore WSH module →
-
Deliveries Interface Table
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH module →
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
View: WSH_STOP_DELIVERIES_V 12.1.1
APPS.WSH_STOP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIP_STOPS·Explore WSH module →
-
Deliveries
-
View: WSH_NEW_DELIVERIES_V 12.2.2
APPS.WSH_NEW_DELIVERIES_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →