Search Results fte_lanes

Overview

The FTE_LANES table is a core data object within the Oracle E-Business Suite (EBS) Transportation Execution (FTE) module. It serves as the master repository for defining and storing lane descriptions within the system's services catalog. A lane is a fundamental concept in transportation management, representing a specific origin-to-destination pairing used for planning, rating, and scheduling freight movements. The table's primary role is to provide a centralized definition of these transportation corridors, which are then referenced by numerous other transactional and configuration entities to enforce business rules, calculate costs, and manage carrier service schedules.

Key Information Stored

While the provided metadata does not list individual columns, the structure and foreign key relationships define its critical data elements. The primary key, LANE_ID, uniquely identifies each lane record. Two essential foreign keys, ORIGIN_ID and DESTINATION_ID, link to the WSH_REGIONS table, defining the geographic start and end points of the lane. This establishes the lane's fundamental route. The table likely contains additional descriptive columns such as a lane name, effective dates, and attributes controlling its active status and usage in planning engines. The existence of related tables for commodities, equipment, and services suggests the lane record acts as a header, with detailed constraints and offerings stored in child tables.

Common Use Cases and Queries

This table is central to transportation rate and service inquiries. A common operational query involves finding all active lanes between two regions to determine available services for a shipment. For example:

• SELECT lane_id, lane_name FROM fte_lanes WHERE origin_id = :p_origin AND destination_id = :p_dest AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate+1);

Reporting use cases include analyzing lane utilization by joining to transactional tables like FTE_SCHEDULES or FTE_LOAD_CHARGES. Integration and data migration scripts frequently query or populate this table when setting up a new transportation network or synchronizing lane definitions from an external system. Troubleshooting often involves tracing a lane's configuration through its related child tables to diagnose rating or scheduling failures.

Related Objects

The FTE_LANES table is a pivotal hub with extensive relationships, as indicated by its numerous foreign key constraints. Key dependent objects include:

• WSH_REGIONS: Provides the origin and destination definitions via the ORIGIN_ID and DESTINATION_ID foreign keys.
• FTE_SCHEDULES & FTE_LOAD_SCHEDULES: Reference the lane to define carrier service timetables and planned freight movements.
• FTE_LANE_RATE_CHARTS & FTE_LOAD_CHARGES: Store pricing and freight cost information specific to the lane.
• FTE_LANE_COMMODITIES, FTE_LANE_EQUIPMENTS, FTE_LANE_SERVICES: Define the allowable commodities, equipment types, and transportation services for the lane.
• FTE_PRC_PARAMETERS & FTE_LANE_GROUP_COMPONENTS: Link the lane to pricing parameters and lane groups for advanced configuration.