Search Results wsh_new_deliveries
The WSH_NEW_DELIVERIES
table is a critical component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Oracle Shipping Execution module. This table serves as a foundational structure for managing delivery-related data, acting as a staging area for newly created deliveries before they are fully processed and integrated into the broader shipping workflow. Below is a detailed analysis of its purpose, structure, and functional significance in Oracle EBS.
Purpose and Functional Context
TheWSH_NEW_DELIVERIES
table is designed to temporarily hold delivery records during the initial stages of the shipping process. It facilitates the creation and validation of deliveries before they are moved to permanent tables such as WSH_DELIVERIES
. This staging mechanism ensures data integrity and allows for validation checks, such as verifying carrier assignments, delivery dates, and shipment priorities, before commitments are finalized. The table is primarily used by the Delivery Workbench and other shipping APIs to streamline the delivery creation process.
Key Columns and Data Structure
The table comprises columns that capture essential delivery attributes, including:- DELIVERY_ID: A unique identifier for the delivery record, often populated by a sequence.
- STATUS_CODE: Reflects the delivery's workflow state (e.g., "IN PROGRESS" or "CONFIRMED").
- ORGANIZATION_ID: Links the delivery to an inventory organization.
- SHIP_METHOD_CODE: Specifies the shipping carrier or method (e.g., FEDEX, UPS).
- ACTUAL_SHIPMENT_DATE: The date when the delivery is physically shipped.
- WAYBILL_AIRBILL_NUM: Stores tracking numbers assigned by carriers.
- ATTRIBUTE_CATEGORY/ATTRIBUTE_n: Flexfield columns for custom attributes.
CREATED_BY
, CREATION_DATE
), weight/volume metrics, and references to associated sales orders or trips.
Integration with Shipping Execution
The table interacts with several Oracle Shipping Execution APIs, such asWSH_DELIVERIES_PUB.CREATE_DELIVERY
, which initializes records in WSH_NEW_DELIVERIES
. Once validated, data is transferred to WSH_DELIVERIES
via background processes or explicit API calls. The table also integrates with Oracle Transportation Management (OTM) and Warehouse Management Systems (WMS) for advanced logistics coordination.
Customization and Extensibility
Oracle EBS allows extensions toWSH_NEW_DELIVERIES
through descriptive flexfields (DFFs), enabling organizations to add context-specific fields. Custom workflows or triggers can be implemented to enforce business rules during the delivery creation phase. However, direct modifications to the table's core structure are discouraged to maintain upgrade compatibility.
Performance Considerations
As a transient table,WSH_NEW_DELIVERIES
should be periodically purged of stale records to optimize performance. Indexes on frequently queried columns (e.g., DELIVERY_ID
, STATUS_CODE
) are recommended for large-scale deployments. Partitioning may be employed in high-volume environments to enhance query efficiency.
Conclusion
TheWSH_NEW_DELIVERIES
table is a pivotal element in Oracle EBS Shipping Execution, providing a robust framework for managing delivery lifecycle transitions. Its design balances flexibility with data integrity, ensuring seamless integration with downstream logistics processes. Understanding its structure and behavior is essential for troubleshooting, customization, and performance tuning in Oracle EBS 12.1.1 and 12.2.2 implementations.
-
Table: WSH_NEW_DELIVERIES
12.1.1
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_NEW_DELIVERIES, object_name:WSH_NEW_DELIVERIES, status:VALID, product: WSH - Shipping Execution , description: Deliveries , implementation_dba_data: WSH.WSH_NEW_DELIVERIES ,
-
Table: WSH_NEW_DELIVERIES
12.2.2
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_NEW_DELIVERIES, object_name:WSH_NEW_DELIVERIES, status:VALID, product: WSH - Shipping Execution , description: Deliveries , implementation_dba_data: WSH.WSH_NEW_DELIVERIES ,
-
APPS.JL_ZZ_RECEIV_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.OKE_FORM_DD250 dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_CONTAINER_UTILITIES dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WMS_RFID_DEVICE_PUB dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WF dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WSHRDVLS_XMLP_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.FTE_TL_RATING dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMI_UPDATE_ORDER dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMD_COA_DATA_OM dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INTEGRATION dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_ROUTING_RESPONSE_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.INV_UI_ITEM_LOVS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERIES_PUB dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WMS_LPN_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CLN_SHOWSHIP_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMD_COA_DATA_OM dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_TRIPS_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_PICK_LIST dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DELIVERIES_PUB dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_RLM_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_WF_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DOCUMENT_SETS dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.QA_ERES_SHIPPING dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.JA_JAINARE1_XMLP_PKG dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.FTE_TRIP_RATING_GRP dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_PACKING_SLIPS_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.GMD_COA_DATA_OM_NEW dependencies on WSH_NEW_DELIVERIES
12.2.2