Search Results wsh_delivery_assignments




The WSH_DELIVERY_ASSIGNMENTS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Shipping Execution module. It serves as a junction table that establishes relationships between deliveries, delivery details, and other entities involved in the shipping process. This table plays a pivotal role in managing the assignment of delivery lines to shipments, ensuring accurate tracking and execution of outbound logistics operations.

Purpose and Functionality

The primary purpose of WSH_DELIVERY_ASSIGNMENTS is to maintain associations between:
  • Deliveries (WSH_NEW_DELIVERIES)
  • Delivery details (WSH_DELIVERY_DETAILS)
  • Trips and trip stops (WSH_TRIPS, WSH_TRIP_STOPS)
  • Freight costs and carriers
This table enables the system to track which items (delivery details) are assigned to specific shipments (deliveries) and their logistical routing.

Key Columns and Relationships

The table contains several important columns that define these relationships:
  • DELIVERY_ASSIGNMENT_ID - Primary key identifier
  • DELIVERY_ID - Foreign key to WSH_NEW_DELIVERIES
  • DELIVERY_DETAIL_ID - Foreign key to WSH_DELIVERY_DETAILS
  • TRIP_ID - Links to the WSH_TRIPS table
  • TRIP_STOP_ID - References WSH_TRIP_STOPS
  • ASSIGNED_TO_TRIP_FLAG - Indicates if assigned to a trip
  • ASSIGNED_TO_DELIVERY_FLAG - Indicates if assigned to a delivery
  • STATUS_CODE - Tracks assignment status

Business Process Integration

The WSH_DELIVERY_ASSIGNMENTS table supports several key shipping processes:
  1. Delivery Creation: When a delivery is created, assignments are generated to link order lines to the delivery.
  2. Shipment Planning: During trip planning, assignments are updated to reflect which deliveries are assigned to specific trips and stops.
  3. Freight Costing: The table helps determine which items should be included in freight calculations.
  4. Shipping Execution: Maintains the current state of items as they move through the shipping process.

Technical Considerations

For technical implementations:
  • The table is heavily indexed to support performance of shipping transactions
  • Triggers and constraints maintain data integrity
  • It integrates with Oracle Inventory, Order Management, and Transportation modules
  • Custom reports often join this table with delivery and trip information

Version-Specific Notes

Between 12.1.1 and 12.2.2:
  • Schema changes are minimal, maintaining backward compatibility
  • 12.2.2 may include additional indexes for performance
  • Both versions use the same basic assignment logic

Common Customizations

Implementations often extend this table's functionality through:
  • Custom workflow statuses
  • Additional assignment attributes via descriptive flexfields
  • Integration with third-party logistics systems
The WSH_DELIVERY_ASSIGNMENTS table remains a fundamental component of Oracle Shipping Execution, providing the structural foundation for managing complex shipping operations in Oracle EBS implementations.