Search Results shipping




The WSH_SHIPPING_PARAMETERS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for shipping-related configuration parameters within the Oracle Shipping Execution module. This table stores system-wide and organization-level settings that govern shipping operations, including default values, processing rules, and integration points with other Oracle modules such as Order Management, Inventory, and Transportation Management. Below is a detailed technical breakdown of its structure, purpose, and functional significance.

Table Structure and Key Columns

The WSH_SHIPPING_PARAMETERS table contains columns that define shipping behavior across the application. Key columns include:
  • ORGANIZATION_ID: Links parameters to specific inventory organizations, enabling multi-org configurations.
  • PARAMETER_CODE: A unique identifier for each parameter (e.g., 'AUTO_CREATE_DELIVERY', 'ALLOW_PARTIAL_SHIPPING').
  • PARAMETER_VALUE: Stores the configured value (e.g., 'Y'/'N' for flags, numeric thresholds, or reference codes).
  • DESCRIPTION: Provides contextual details about the parameter's purpose.
  • CREATION_DATE and LAST_UPDATE_DATE: Audit columns tracking parameter maintenance.

Functional Role in Shipping Execution

The table acts as a control center for shipping workflows:
  1. Delivery Creation Rules: Parameters like AUTO_CREATE_DELIVERY determine whether deliveries are auto-generated from sales orders or require manual intervention.
  2. Partial Shipments: Flags such as ALLOW_PARTIAL_SHIPPING define whether order lines can be split across multiple shipments.
  3. Freight Calculations: Parameters integrate with Oracle Transportation Management (OTM) or third-party freight engines, specifying rate service URLs and authentication details.
  4. Label Printing: Configures default label formats, printers, and batch printing behaviors.
  5. Carrier Integration: Stores API endpoints and credentials for electronic communication with carriers (e.g., FedEx, UPS).

Integration with Other Modules

The table's parameters influence cross-module processes:
  • Order Management: Shipping parameters may enforce validation rules during order booking (e.g., weight/volume validations).
  • Inventory: Controls pick release and ship confirmation workflows, including backorder handling.
  • Financials: Flags like INVOICE_ON_SHIP_CONFIRM trigger invoicing upon shipment completion.

Technical Considerations

  • Multi-Org Support: Parameters can be set globally or overridden per organization using ORGANIZATION_ID.
  • Upgrade Impact: Custom parameters added via extensions must be preserved during EBS upgrades.
  • Performance: Frequent queries on this table (e.g., during delivery creation) necessitate proper indexing.

Customization and Extensibility

The table supports custom parameters through user-defined PARAMETER_CODE values, enabling tailored shipping rules without code modifications. However, custom logic accessing these parameters must be implemented via Oracle's API layer (e.g., WSH_UTIL package) to ensure upgrade compatibility.

Security

Access to WSH_SHIPPING_PARAMETERS is typically restricted to shipping administrators due to its operational impact. Changes should be logged using Oracle's AuditVault in regulated environments.

Conclusion

The WSH_SHIPPING_PARAMETERS table is a foundational component of Oracle Shipping Execution, providing granular control over shipping operations. Its configuration directly impacts order fulfillment efficiency, carrier compliance, and customer satisfaction. Proper management of this table is essential for optimizing shipping workflows in EBS 12.1.1 and 12.2.2 deployments.