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
TheWSH_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 onDELIVERY_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
TheWSH_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.
-
Table: WSH_DELIVERY_DETAILS
12.1.1
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_DELIVERY_DETAILS, object_name:WSH_DELIVERY_DETAILS, status:VALID, product: WSH - Shipping Execution , description: Delivery Details , implementation_dba_data: WSH.WSH_DELIVERY_DETAILS ,
-
Table: WSH_DELIVERY_DETAILS
12.2.2
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_DELIVERY_DETAILS, object_name:WSH_DELIVERY_DETAILS, status:VALID, product: WSH - Shipping Execution , description: Delivery Details , implementation_dba_data: WSH.WSH_DELIVERY_DETAILS ,
-
APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OKE_FLOWDOWN_UTILS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_SHIPPING_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_MGD_MVT_SO_MDTR dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OE_SHIP_CONFIRMATION_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.JAI_CMN_ST_FORMS_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_MO_PURGE dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_LABEL_PVT7 dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_LPN_SYNC_COMM_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OE_INVOICE_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_LPN_LOVS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.CSD_DEPOT_UPDATE_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_DLVB_COMMON_ACTIONS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_PARTY_MERGE dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_WF dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_PUTAWAY_UTILS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_TP_RELEASE_INT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.MST_SNAPSHOT_TASK_UTIL dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_TASK_MGMT_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_WMSSTCON_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_PR_CRITERIA dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.GMI_RESERVATION_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.GMI_OM_ALLOC_API_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_SHIPPING_LOVS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OKE_DTS_INTEGRATION_PKG dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.GMI_OM_UTIL dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_EXPRESS_PICK_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WMS_OP_INBOUND_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_DELIVERY_DETAILS_SPLITTER dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.FTE_TL_CACHE dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_INTERFACE dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.OE_SHIPPING_WF dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.CSD_MASS_RCV_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.GML_RCV_DB_COMMON dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.INV_DETAIL_UTIL_PVT dependencies on WSH_DELIVERY_DETAILS
12.1.1
-
APPS.CSD_DEPOT_REPAIR_CNTR dependencies on WSH_DELIVERY_DETAILS
12.1.1