Search Results wsh




DeepSeek eTRM - WSH Tables and Views in Oracle EBS 12.1.1/12.2.2

The Oracle E-Business Suite (EBS) Shipping Execution module relies on a structured database schema to manage shipping transactions, tracking, and logistics. The DeepSeek Electronic Technical Reference Manual (eTRM) provides comprehensive documentation on the underlying tables and views associated with the WSH (Shipping) module in Oracle EBS 12.1.1 and 12.2.2. This summary outlines the key tables, views, and their functional significance in the shipping process.

Core WSH Tables

The WSH module's database schema consists of several critical tables:

  • WSH_DELIVERIES: Stores delivery header information, including delivery IDs, statuses, and dates. This is the primary table for tracking shipments.
  • WSH_DELIVERY_DETAILS: Contains line-level details of deliveries, such as item quantities, weights, and references to sales orders or inventory moves.
  • WSH_TRIPS: Manages trip records, which group multiple deliveries for consolidated shipping.
  • WSH_TRIP_STOPS: Tracks stops (pickup/drop-off locations) associated with trips.
  • WSH_CARRIERS: Stores carrier information, including names, service levels, and tracking methods.
  • WSH_FREIGHT_COSTS: Captures freight charges and billing details for shipments.

Key WSH Views

Oracle EBS provides views to simplify reporting and integration:

  • WSH_DELIVERIES_V: A comprehensive view combining delivery headers with related attributes.
  • WSH_DELIVERY_DETAILS_V: Aggregates delivery line details with item and order information.
  • WSH_TRIPS_V: Enhances trip data with carrier and stop details for logistics planning.
  • WSH_FREIGHT_CHARGES_V: Facilitates freight cost analysis by joining cost tables with delivery data.

Functional Workflow

The WSH tables support end-to-end shipping operations:

  1. Order Fulfillment: Sales orders or inventory transfers trigger delivery creation in WSH_DELIVERIES and WSH_DELIVERY_DETAILS.
  2. Consolidation: Deliveries are grouped into trips (WSH_TRIPS) with defined stops (WSH_TRIP_STOPS).
  3. Carrier Assignment: WSH_CARRIERS links shipments to logistics providers.
  4. Freight Calculation: WSH_FREIGHT_COSTS records shipping expenses for invoicing.
  5. Tracking: Status updates propagate through tables, enabling real-time visibility.

Integration Points

WSH tables interface with other EBS modules:

  • Order Management (OM): WSH_DELIVERY_DETAILS references OE_ORDER_LINES_ALL.
    • Inventory (INV): Shipments link to MTL_MATERIAL_TRANSACTIONS.
  • Receivables (AR): Freight costs integrate with RA_CUSTOMER_TRX_ALL for billing.

Conclusion

The DeepSeek eTRM for WSH tables and views in Oracle EBS 12.1.1/12.2.2 provides a foundational blueprint for shipping execution. By leveraging these structures, organizations can automate logistics, improve shipment visibility, and ensure seamless integration with supply chain and financial processes. Understanding these tables is essential for custom reporting, performance tuning, and extending shipping functionality.