Search Results wsh_delivery_details




The WSH_DELIVERY_DETAILS table is a critical component in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Oracle Shipping Execution module. It serves as the primary repository for tracking detailed information about delivery lines, which are the individual items or components that make up a shipment. This table is integral to the order fulfillment and logistics processes, linking sales orders, inventory, and transportation management.

Key Attributes of WSH_DELIVERY_DETAILS

The table contains numerous columns that capture essential data for shipping operations. Some of the most significant fields include:
  • DELIVERY_DETAIL_ID: The primary key, uniquely identifying each delivery line.
  • SOURCE_CODE: Indicates the origin of the delivery line (e.g., "OE" for Order Entry).
  • SOURCE_LINE_ID: References the line ID from the source system (e.g., Order Entry line ID).
  • INVENTORY_ITEM_ID: Links to the item in Oracle Inventory.
  • ORGANIZATION_ID: Specifies the inventory organization.
  • REQUESTED_QUANTITY: The quantity requested for shipment.
  • SHIPPED_QUANTITY: The actual quantity shipped.
  • DELIVERY_ID: Foreign key linking to the WSH_DELIVERIES table, associating the detail with a delivery.
  • STATUS_CODE: Reflects the current status (e.g., "OP" for Open, "CL" for Closed).
  • TRACKING_NUMBER: Carrier-provided tracking information.

Functional Role in Shipping Execution

The WSH_DELIVERY_DETAILS table acts as the backbone for shipping workflows. When a sales order is booked in Order Management, corresponding records are created in this table. These records are then processed through the Shipping Execution module, where they are grouped into deliveries, assigned to trips, and eventually shipped. The table is updated at each stage to reflect changes in status, quantities, and other attributes.

Integration with Other Modules

This table integrates with multiple Oracle EBS modules:
  • Order Management (OM): Source lines from sales orders are referenced via SOURCE_LINE_ID.
  • Inventory (INV): Items and quantities are validated against inventory data.
  • Warehouse Management (WMS): Supports pick release, packing, and shipping tasks.
  • Transportation Management (WSH): Links to trips and carriers for logistics planning.

Technical Considerations

The table is heavily indexed to support performance-critical operations, such as pick release and shipping confirmation. Key indexes include those on DELIVERY_DETAIL_ID, SOURCE_LINE_ID, and DELIVERY_ID. Additionally, it participates in complex joins with tables like WSH_DELIVERIES, OE_ORDER_LINES_ALL, and MTL_SYSTEM_ITEMS_B.

Customization and Extensions

Organizations often extend this table with custom columns to capture additional shipping attributes. These extensions are typically implemented via descriptive flexfields (DFFs) or through custom PL/SQL logic. However, care must be taken to avoid conflicts with standard Oracle functionality.

Conclusion

The WSH_DELIVERY_DETAILS table is a cornerstone of Oracle Shipping Execution, enabling end-to-end tracking of delivery lines from order creation to shipment. Its design supports high-volume transactions, seamless integration with other modules, and flexibility for customization. Understanding its structure and relationships is essential for effective implementation and support of Oracle EBS shipping processes.