Search Results FTE_LANE_RATE_CHARTS




Overview
Explore in AI Chat

Overview

The FTE_LANE_RATE_CHARTS table is a core data object within the Oracle E-Business Suite (EBS) Transportation Execution (FTE) module. It functions as a junction or association table, establishing a critical link between transportation lanes and pricing rate charts. Its primary role is to enable the assignment of specific pricing lists (rate charts) to defined transportation lanes, thereby forming the foundation for freight cost calculations and rate lookups during the shipment planning and execution processes. This association is essential for automating freight rating and ensuring that the correct, negotiated carrier rates are applied based on the origin, destination, and service level of a given shipment.

Key Information Stored

While the provided ETRM excerpt does not list individual columns, the documented foreign key relationships reveal the table's fundamental structure. The table stores at least two critical foreign key columns that create the association. The LANE_ID column references the FTE_LANES table, which defines a specific transportation lane based on attributes like origin, destination, and service level. The LIST_HEADER_ID column references the QP_LIST_HEADERS_B table from the Pricing (QP) module, which stores the header information for a price list or rate chart. The combination of these keys defines which rate chart is applicable for a given lane. The table likely also includes standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing and may contain attributes to manage effective dates or precedence of multiple rate charts on a single lane.

Common Use Cases and Queries

This table is central to freight rating operations. A common use case is determining the applicable rate chart for a shipment during the rate-shopping phase. The system queries this table using the lane identifier to retrieve the associated pricing list ID. Another key scenario is the administration and maintenance of lane-rate relationships within the FTE application's user interface. Sample SQL to retrieve all rate charts for a specific lane would be:

  • SELECT lrc.list_header_id, qlh.name FROM fte_lane_rate_charts lrc, qp_list_headers_b qlh WHERE lrc.lane_id = :p_lane_id AND lrc.list_header_id = qlh.list_header_id;

Reporting use cases include auditing lane coverage by analyzing which lanes have rate charts assigned and identifying lanes missing rate assignments, which would cause rating failures.

Related Objects

The FTE_LANE_RATE_CHARTS table has direct dependencies on two primary tables, as confirmed by its foreign keys. The FTE_LANES table is the source for the LANE_ID, providing the detailed definition of the transportation lane. The QP_LIST_HEADERS_B table from the Oracle Pricing module is the source for the LIST_HEADER_ID, providing access to the full rate chart, including its lines, qualifiers, and pricing attributes. This table is also likely referenced by various FTE pricing and rating engine APIs and views that consolidate lane and rate information for application logic and user inquiries within the Transportation Execution module.