Search Results wsh_carrier_services

The WSH_CARRIER_SERVICES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Oracle Shipping Execution module. It serves as a repository for carrier service information, enabling organizations to manage shipping carriers and their associated services efficiently. This table plays a pivotal role in logistics and transportation management by linking carriers to specific services, facilitating rate calculations, and supporting shipping document generation. Below is a detailed breakdown of its structure, functionality, and integration within Oracle EBS.

Table Structure and Key Columns

The WSH_CARRIER_SERVICES table contains columns that define carrier services, their attributes, and relationships with other entities. Key columns include:

• CARRIER_SERVICE_ID: Primary key, uniquely identifying each carrier service.
• CARRIER_ID: Foreign key referencing WSH_CARRIERS, linking the service to a carrier.
• SERVICE_CODE: A unique code representing the service (e.g., "GROUND" or "EXPRESS").
• DESCRIPTION: A human-readable description of the service.
• ACTIVE_FLAG: Indicates whether the service is active (Y/N).
• MODE_OF_TRANSPORT: Specifies the transportation mode (e.g., Air, Road, Ocean).
• RATE_SERVICE_FLAG: Determines if the service is used for rate calculations.
• TRACKING_SERVICE_FLAG: Indicates whether the service supports package tracking.

Functional Role in Oracle Shipping Execution

The table supports core shipping functionalities:

1. Carrier Service Configuration: Stores predefined services offered by carriers (e.g., FedEx Priority Overnight).
2. Rate Management: Integrates with WSH_RATE_SERVICES to enable freight cost calculations based on service selection.
3. Shipment Documentation: Associates services with shipping documents (e.g., bills of lading) via WSH_DOCUMENT_SERVICES.
4. Tracking Integration: Flags services that support real-time tracking through carrier APIs.

Integration with Other Modules

The table interacts with multiple EBS components:

• Order Management: Service selections influence delivery schedules and costs in OE_ORDER_LINES.
• Inventory: Shipping service constraints may affect warehouse picking rules.
• Advanced Pricing: Freight charges derived from carrier services feed into pricing engines.

Technical Considerations

• Indexing: The table is indexed on CARRIER_SERVICE_ID and CARRIER_ID for performance optimization.
• API Dependencies: Oracle Shipping APIs (WSH_CARRIER_SERVICES_PUB) provide programmatic access to this table.
• Upgrade Impact: Schema changes between 12.1.1 and 12.2.2 are minimal, ensuring backward compatibility.

Customization and Extensions

Organizations often extend this table by:

• Adding custom columns for service-level SLAs or regional restrictions.
• Integrating with third-party logistics providers through service code mappings.
• Implementing triggers to validate service-carrier combinations.

In summary, the WSH_CARRIER_SERVICES table is foundational to Oracle Shipping Execution, enabling precise control over carrier service definitions and their operational impact across the supply chain. Its design supports scalability, integration, and compliance with global shipping standards.