Search Results warehouse




The WMS_ELS_RATINGS_SETUP table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component within the Warehouse Management System (WMS) module, specifically designed to support the Enterprise Logistics Shipping (ELS) functionality. This table stores configuration data related to carrier rating services, which are essential for determining shipping costs, selecting optimal carriers, and streamlining logistics operations. Below is a detailed breakdown of its structure, purpose, and integration within Oracle EBS.

Purpose and Functional Context

The WMS_ELS_RATINGS_SETUP table acts as a repository for carrier rating rules and parameters used by the ELS module. It enables organizations to automate freight cost calculations by interfacing with third-party rating engines or Oracle's native rating logic. Key functionalities supported include:
  • Carrier Rate Configuration: Defines rate structures, discounts, and surcharges for carriers.
  • Service Level Mapping: Associates shipping services (e.g., "Next-Day Air") with carrier-specific codes.
  • Zone-Based Pricing: Stores zone definitions and corresponding rates for regional shipping.
  • Weight/Dimensional Rules: Configures rules for freight cost calculations based on weight breaks or dimensional weight.

Table Structure and Key Columns

The table comprises columns that define rating logic, carrier relationships, and validation rules. Notable columns include:
  • RATING_SETUP_ID: Primary key, uniquely identifying each rating configuration.
  • CARRIER_ID: References the carrier (from WMS_CARRIERS) associated with the rating rules.
  • SERVICE_LEVEL: Specifies the shipping service (e.g., "GROUND," "EXPRESS").
  • RATE_TYPE: Indicates whether rates are flat, tiered, or zone-based.
  • MIN_CHARGE: Defines the minimum freight cost for a shipment.
  • START_DATE/END_DATE: Validity period for the rating rule.
  • ATTRIBUTE_CATEGORY/ATTRIBUTE_n: Flexfield columns for custom extensions.

Integration with Oracle EBS Modules

The WMS_ELS_RATINGS_SETUP table integrates with several EBS modules:
  1. Shipping Execution: Provides real-time freight cost estimates during shipment creation.
  2. Order Management: Informs order promising logic by incorporating shipping costs and delivery timelines.
  3. Accounts Payable: Validates carrier invoices against contracted rates stored in the table.

Technical Considerations

  • Indexing: Typically indexed on CARRIER_ID and SERVICE_LEVEL for performance optimization.
  • Partitioning: In high-volume environments, partitioning by END_DATE may be implemented.
  • API Dependencies: Accessed via Oracle's WSH_RATING_PUB PL/SQL APIs for rating calculations.

Customization and Extensions

Organizations often extend the table's functionality by:
  • Leveraging flexfields to capture custom rate determinants (e.g., fuel surcharge formulas).
  • Integrating with external rating engines via Oracle's SOA Gateway.
  • Developing triggers to enforce business rules (e.g., rate validation against contracts).

Upgrade Implications

Between EBS 12.1.1 and 12.2.2, the table's structure remains largely consistent, but 12.2.2 introduces:
  • Enhanced support for REST-based carrier integrations.
  • Additional columns for multi-currency rating in global deployments.
In summary, the WMS_ELS_RATINGS_SETUP table is a cornerstone of Oracle WMS's shipping cost management capabilities, enabling precise, automated freight calculations while maintaining flexibility for complex logistics scenarios.