Search Results wsh_carriers




The WSH_CARRIERS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Shipping Execution module, which falls under the Oracle Transportation Management (OTM) and Oracle Global Trade Management (GTM) umbrella. This table stores carrier-related information, enabling organizations to manage shipping carriers, their services, and associated attributes efficiently. Below is a detailed breakdown of its structure, functionality, and integration within Oracle EBS.

Table Structure and Key Columns

The WSH_CARRIERS table contains columns that define carrier details, including:

  • CARRIER_ID: Primary key, uniquely identifying each carrier.
  • NAME: The name of the carrier (e.g., FedEx, UPS).
  • CARRIER_NUMBER: An optional identifier for internal or external reference.
  • SCAC_CODE: Standard Carrier Alpha Code, a unique identifier for transportation providers.
  • MODE_OF_TRANSPORT: Specifies the transportation method (e.g., Air, Ocean, Road).
  • STATUS: Indicates whether the carrier is active or inactive.
  • ORGANIZATION_ID: Links the carrier to a specific operating unit.
  • FREIGHT_BILLING_CODE: Used for freight billing and invoicing.

Functional Role in Oracle EBS

The WSH_CARRIERS table supports the following functionalities:

  • Carrier Setup and Maintenance: Organizations can define carriers, their modes of transport, and service levels, which are essential for shipping and logistics operations.
  • Integration with Shipping Documents: Carriers defined in this table are referenced in shipping documents, such as bills of lading and shipping manifests.
  • Freight Cost Calculation: The table integrates with Oracle Transportation Management to calculate freight costs based on carrier-specific rates.
  • Carrier Compliance: SCAC codes and other regulatory attributes ensure compliance with shipping standards.

Integration with Other Modules

The WSH_CARRIERS table interacts with several Oracle EBS modules, including:

  • Order Management (OM): Carriers are linked to sales orders for fulfillment and shipping.
  • Inventory (INV): Supports the movement of goods by associating carriers with shipments.
  • Purchasing (PO): Used for inbound logistics and supplier shipments.
  • Oracle Transportation Management (OTM): Enables advanced freight management and carrier rate negotiations.

Customization and Extensions

Organizations can extend the WSH_CARRIERS table by:

  • Adding custom columns to capture carrier-specific attributes.
  • Integrating with third-party logistics providers via APIs.
  • Leveraging Oracle Workflow or Oracle Integration Cloud for automated carrier updates.

Conclusion

The WSH_CARRIERS table is a foundational element in Oracle EBS Shipping Execution, enabling efficient carrier management, compliance, and logistics coordination. Its integration with core modules ensures seamless shipping processes, from order fulfillment to freight cost calculation. Proper configuration and maintenance of this table are essential for optimizing supply chain operations in Oracle EBS 12.1.1 and 12.2.2.