Search Results fte_lane_group_components




Overview
Explore in AI Chat

Overview

The FTE_LANE_GROUP_COMPONENTS table is a core transactional table within the Oracle Transportation Execution (FTE) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a detail table that defines the composition of a lane group. A lane group is a logical entity used to aggregate multiple individual shipping lanes, typically to simplify rate and service assignment during freight planning and execution. This table establishes the many-to-many relationship between a parent lane group and its constituent lanes, enabling complex transportation network modeling and rule application.

Key Information Stored

The table's primary role is to store the association between a lane group and its member lanes. While the specific column list is not fully detailed in the provided metadata, the foreign key relationships explicitly identify the critical columns. The LANE_GROUP_ID column links to the parent lane group definition. The LANE_ID column is a foreign key to the FTE_LANES table, identifying each specific lane included in the group. This structure implies the table likely contains a primary key composed of LANE_GROUP_ID and LANE_ID, or a unique sequence identifier, to prevent duplicate entries. Additional columns may exist to manage sequencing, effective dates, or other control attributes for the component relationship.

Common Use Cases and Queries

This table is central to operations where transportation rates, schedules, or carrier assignments are defined at a group level. A primary use case is during freight rate shopping or lane assignment, where the system can evaluate a shipment against a lane group's criteria instead of checking hundreds of individual lanes. Common queries involve listing all components of a specific lane group or identifying which lane groups a particular lane belongs to for impact analysis.

  • Find all lanes in a lane group: SELECT lane_id FROM fte_lane_group_components WHERE lane_group_id = <GROUP_ID>;
  • Find all groups containing a specific lane: SELECT lane_group_id FROM fte_lane_group_components WHERE lane_id = <LANE_ID>;
  • Reporting on lane group composition: Joining this table with FTE_LANES and the lane group header table provides detailed reports for auditing and network design.

Related Objects

The FTE_LANE_GROUP_COMPONENTS table has direct dependencies on two key FTE objects, as defined by its foreign keys.

  • FTE_LANES: This is the master table for transportation lane definitions. The LANE_ID foreign key in FTE_LANE_GROUP_COMPONENTS references this table to identify the specific origin, destination, and service attributes of each component.
  • FTE_LANE_GROUPS (implied): Although not explicitly listed in the metadata, the foreign key on LANE_GROUP_ID must reference a parent lane group header table, which is typically named FTE_LANE_GROUPS or similar. This table holds the overarching definition and attributes of the lane group itself.

This table is integral to the FTE module's data model, acting as the junction between high-level grouping logic and granular lane-level transportation data.