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

The WSH_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.
Additional columns track audit information (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 as WSH_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 to WSH_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

The WSH_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.