Search Results carrier




The FTE_FACILITY_CARRIERS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Oracle Transportation Management (OTM) and Oracle Global Trade Management (GTM) modules. This table serves as a junction between facilities (warehouses, distribution centers, or other logistical nodes) and carriers (transportation service providers), enabling organizations to manage carrier assignments, service levels, and transportation planning efficiently. Below is a detailed analysis of its purpose, structure, key columns, and functional relevance.

Purpose and Functional Context

The FTE_FACILITY_CARRIERS table acts as a mapping entity that defines which carriers are associated with specific facilities. This relationship is essential for:
  • Transportation Planning: Determines eligible carriers for shipments originating from or destined to a facility.
  • Rate Management: Links carriers to facility-specific contracts, rates, and service agreements.
  • Shipment Execution: Facilitates carrier selection during freight booking or tendering processes.
  • Compliance: Ensures adherence to trade regulations by associating carriers with facilities based on geographic or regulatory constraints.
This table is particularly relevant in multi-carrier environments where facilities may have preferred or restricted carrier partnerships.

Key Columns and Data Structure

The FTE_FACILITY_CARRIERS table typically includes the following columns:
  • FACILITY_ID: Foreign key referencing the facility (e.g., warehouse ID) from FTE_FACILITY or WMS_LICENSE_PLATE_NUMBERS.
  • CARRIER_ID: Foreign key linking to the carrier record in FTE_CARRIERS or WSH_CARRIERS.
  • ORIGIN_DESTINATION_TYPE: Indicates whether the carrier is assigned for inbound, outbound, or both types of shipments.
  • EFFECTIVE_DATE / END_DATE: Defines the validity period of the carrier-facility association.
  • SERVICE_LEVEL: Specifies the default service level (e.g., "Standard," "Expedited") for the carrier at the facility.
  • PRIORITY: Determines selection precedence when multiple carriers are available for a facility.
  • STATUS: Active or inactive status of the association.

Integration with Other Modules

The table integrates with several Oracle EBS modules:
  • Oracle Warehouse Management (WMS): Aligns carrier assignments with warehouse operations.
  • Oracle Shipping Execution: Informs carrier selection during shipment creation.
  • Oracle Procurement: Supports carrier selection for inbound shipments.
  • Oracle Order Management: Influences outbound carrier choices based on facility-specific rules.

Technical Considerations

  • Indexing: Typically indexed on FACILITY_ID and CARRIER_ID for performance optimization.
  • Data Volume: The table size depends on the number of facilities and carriers, but it is generally lightweight.
  • Custom Extensions: Organizations may extend the table with custom columns (e.g., carrier-specific attributes) via Oracle's extension frameworks.

Business Process Impact

The FTE_FACILITY_CARRIERS table directly impacts:
  • Cost Optimization: Enables preferential routing through cost-effective carriers.
  • Service Level Agreements (SLAs): Ensures compliance with delivery commitments by associating facilities with reliable carriers.
  • Scalability: Supports dynamic carrier assignments as supply chain networks expand.
In summary, the FTE_FACILITY_CARRIERS table is a pivotal component in Oracle EBS logistics workflows, bridging facilities and carriers to streamline transportation operations, reduce costs, and enhance supply chain visibility. Its design reflects Oracle's emphasis on configurability and integration across the EBS ecosystem.