Search Results fte_load_charges




Overview
Explore in AI Chat

Overview

The FTE_LOAD_CHARGES table is a core transactional data store within the Oracle Transportation Execution (FTE) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for all price-related details associated with a tendered shipment. When a freight shipment is tendered to a carrier and a rate is applied, the resulting charge lines—including base freight, accessorials, discounts, and surcharges—are recorded in this table. Its primary role is to maintain a detailed and auditable pricing breakdown for each shipment, linking the physical load details to the commercial pricing terms derived from the system's quoting engine or manual entry.

Key Information Stored

The table's structure is defined by its foreign key relationships, which reveal the critical data it holds. The primary key, LOAD_CHARGE_ID, uniquely identifies each charge line. Essential relational columns include LOAD_ID, LOAD_SCHEDULE_ID, and LOAD_DETAIL_ID, which anchor the charge to its parent shipment, schedule, and specific line item, respectively. For pricing integration, PRICING_LIST_HEADER_ID and PRICING_LIST_LINE_ID link to the Oracle Quoting (QP) module's lists, while PRICING_PHASE_ID categorizes the charge type (e.g., base, discount). The LANE_ID associates the charge with a specific freight lane. The table also supports complex charge structures through self-referential columns: APPLIED_TO_LOAD_PRICE_ID links a discount or surcharge to a specific base charge, and BREAK_LINE_FOR_CHARGE_ID manages tiered or broken pricing lines.

Common Use Cases and Queries

This table is fundamental for freight cost analysis, carrier invoice auditing, and shipment profitability reporting. A common use case is generating a detailed freight invoice or cost accrual report for a specific load. A typical query would join FTE_LOAD_CHARGES to its parent header and detail tables to aggregate charges.

  • Sample Query for Load Charges Summary:
    SELECT flh.load_number, SUM(flc.charge_amount)
    FROM fte_load_charges flc, fte_load_headers flh
    WHERE flc.load_id = flh.load_id
    AND flh.load_number = '<LOAD_NUMBER>'
    GROUP BY flh.load_number;
  • Auditing Pricing Application: Queries often join to QP_LIST_HEADERS_B and QP_LIST_LINES to verify the correct pricing list and line were applied during tendering.
  • Analyzing Charge Composition: Reporting on charge types by joining to QP_PRICING_PHASES to break down total cost by base freight, fuel surcharge, and other accessorials.

Related Objects

FTE_LOAD_CHARGES is a central hub within the FTE schema, with extensive dependencies. Its primary relationships are with the main load transactional tables: FTE_LOAD_HEADERS, FTE_LOAD_SCHEDULES, and FTE_LOAD_DETAILS. For pricing intelligence, it integrates directly with the Oracle Quoting module via QP_LIST_HEADERS_B, QP_LIST_LINES, and QP_PRICING_PHASES. The table FTE_LANES provides the freight lane context for the charge. Furthermore, the table FTE_CHRG_PRC_ATTRIBUTES holds additional pricing attributes for each charge record, linked via LOAD_CHARGE_ID. The table's self-referential foreign keys indicate its capability to model complex, hierarchical charge structures internally.