Search Results wsh_delivery_legs




The WSH_DELIVERY_LEGS table is a critical component in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Shipping Execution module. This table stores detailed information about the legs of a delivery, which represent the segments of a shipment's journey from the source location to the destination. Each leg corresponds to a portion of the route handled by a specific carrier or mode of transport. Below is a detailed breakdown of its structure, purpose, and key attributes in the context of Oracle EBS.

Purpose and Functionality

The WSH_DELIVERY_LEGS table serves as a repository for tracking the movement of shipments across multiple legs or segments of a delivery route. It enables logistics and supply chain teams to monitor and manage the progress of shipments, ensuring visibility into each stage of transportation. This table is integral to the Shipping Execution module, which orchestrates the end-to-end shipping process, including carrier selection, freight costing, and delivery scheduling.

Key Attributes

The table contains several important columns that define the characteristics of each delivery leg:
  • DELIVERY_LEG_ID: A unique identifier for each delivery leg, serving as the primary key.
  • DELIVERY_ID: References the parent delivery record in the WSH_NEW_DELIVERIES table.
  • START_ORGANIZATION_ID: Identifies the starting location (warehouse or facility) for the leg.
  • END_ORGANIZATION_ID: Identifies the destination location for the leg.
  • CARRIER_ID: Specifies the carrier responsible for transporting the shipment during this leg.
  • MODE_OF_TRANSPORT: Indicates the transportation method (e.g., truck, air, ocean).
  • ACTUAL_DEPARTURE_DATE: The date and time when the shipment physically departs from the start location.
  • ACTUAL_ARRIVAL_DATE: The date and time when the shipment arrives at the end location.
  • PLANNED_DEPARTURE_DATE: The scheduled departure date for the leg.
  • PLANNED_ARRIVAL_DATE: The scheduled arrival date for the leg.
  • STATUS_CODE: Reflects the current status of the leg (e.g., "In Transit," "Completed").

Integration with Other Modules

The WSH_DELIVERY_LEGS table integrates with several other Oracle EBS modules, including:
  • Inventory Management: Tracks the movement of goods between organizations.
  • Order Management: Links delivery legs to sales orders and fulfillment processes.
  • Freight Management: Associates legs with freight costs and carrier contracts.

Business Process Flow

The table supports the following business processes:
  1. Delivery Creation: When a delivery is created, one or more legs are defined based on the route and carrier assignments.
  2. Shipment Execution: As the shipment progresses, the leg statuses are updated to reflect real-time movements.
  3. Freight Costing: Costs are calculated per leg, enabling accurate freight expense tracking.
  4. Reporting and Analytics: Data from this table feeds into dashboards and reports for logistics performance analysis.

Technical Considerations

In Oracle EBS 12.1.1 and 12.2.2, the WSH_DELIVERY_LEGS table is optimized for high-volume transaction processing. Indexes on key columns like DELIVERY_LEG_ID and DELIVERY_ID ensure efficient query performance. The table also supports concurrent updates, which is critical for real-time logistics operations.

Conclusion

The WSH_DELIVERY_LEGS table is a foundational element of Oracle EBS Shipping Execution, enabling granular tracking and management of shipment legs. Its integration with other modules ensures seamless logistics operations, while its structured design supports scalability and performance. Understanding this table is essential for consultants and administrators working with Oracle EBS transportation and logistics functionalities.