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.

Table: WSH_CARRIERS 12.2.2
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_CARRIERS, object_name:WSH_CARRIERS, status:VALID, product: WSH - Shipping Execution , description: Shipping Carrier Information , implementation_dba_data: WSH.WSH_CARRIERS ,
Table: WSH_CARRIERS 12.1.1
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_CARRIERS, object_name:WSH_CARRIERS, status:VALID, product: WSH - Shipping Execution , description: Shipping Carrier Information , implementation_dba_data: WSH.WSH_CARRIERS ,
APPS.MSC_SATP_FUNC dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_PRICING_SPECIAL dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_UTIL_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_TL_LOADER dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_MBOLS_PVT dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_CONC_UTIL_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.OE_INVOICE_PUB dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_TL_RATING dependencies on WSH_CARRIERS 12.2.2
APPS.INV_DETAIL_UTIL_PVT dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_TMS_RELEASE dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_LANE_SEARCH_QUERY_GEN dependencies on WSH_CARRIERS 12.2.2
APPS.WMS_XDOCK_PEGGING_PUB dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_TRACKING_WRAPPER dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_FREIGHT_PRICING dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_CARRIERS_GRP dependencies on WSH_CARRIERS 12.2.2
APPS.OE_BULK_PROCESS_HEADER dependencies on WSH_CARRIERS 12.1.1
APPS.WMS_XDOCK_PEGGING_PUB dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_TL_RATING dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.HZ_PURGE_GEN dependencies on WSH_CARRIERS 12.1.1
APPS.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_RATING_PUB dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_COMP_CONSTRAINT_UTIL dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_VALIDATION_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_TL_LOADER dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_VALIDATION_PKG dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_OTM_RIQ_XML dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_CARRIER_SERVICES_PKG dependencies on WSH_CARRIERS 12.2.2
APPS.OE_DEFAULT_LINE dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_FPA_UTIL dependencies on WSH_CARRIERS 12.2.2
APPS.WSH_AUTO_MANIFEST dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_SOURCE_LINE_CONSOLIDATION dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_CARRIER_SERVICES_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_LOCATIONS_PKG dependencies on WSH_CARRIERS 12.1.1
APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_PRICING dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_PRICING_UTIL dependencies on WSH_CARRIERS 12.1.1
APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_CARRIERS 12.2.2
APPS.FTE_FREIGHT_PRICING dependencies on WSH_CARRIERS 12.2.2