Search Results fte_load_details




Overview
Explore in AI Chat

Overview

The FTE_LOAD_DETAILS table is a core data object within the Oracle Transportation Execution (FTE) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store granular details about the physical contents of a shipment, serving as the transactional foundation for freight management. Each record in this table represents a specific item, package, or freight unit that is part of a larger shipment defined in the parent FTE_LOAD_HEADERS table. This detailed breakdown is critical for processes such as freight rating, shipment costing, carrier tendering, and shipment tracking, enabling precise management of multi-line and multi-package shipments throughout the transportation lifecycle.

Key Information Stored

The table's structure is designed to capture detailed shipment composition. The primary key is LOAD_DETAIL_ID, which uniquely identifies each line item. A critical foreign key is LOAD_ID, which links the detail line to its master shipment record in FTE_LOAD_HEADERS. The table supports hierarchical packaging through the PARENT_LOAD_DETAIL_ID column, which can reference another record within the same table, allowing for the modeling of pallets containing cartons, which in turn contain individual items. While the specific descriptive columns are not enumerated in the provided metadata, typical data stored includes item identifiers, descriptions, quantities, weights, dimensions, freight classes, and references to the original source documents (e.g., sales orders, purchase orders). This data is essential for accurate freight calculation and carrier compliance.

Common Use Cases and Queries

This table is central to operational and analytical reporting within Transportation Execution. Common use cases include generating detailed packing lists, auditing freight charges against shipped quantities, and analyzing freight density or weight utilization per shipment. A typical query would join FTE_LOAD_DETAILS to FTE_LOAD_HEADERS to retrieve a complete shipment manifest. For example:

  • SELECT h.load_number, d.item_description, d.quantity, d.weight
    FROM fte_load_headers h, fte_load_details d
    WHERE h.load_id = d.load_id
    AND h.load_number = '<LOAD_NUMBER>';

Another common pattern involves querying hierarchical packaging structures using self-joins on PARENT_LOAD_DETAIL_ID. Integration and data validation scripts also frequently target this table to ensure shipment details are correctly propagated from source systems like Order Management or Purchasing.

Related Objects

FTE_LOAD_DETAILS is a central hub within the Transportation Execution schema, with several key relationships. Its primary parent is the FTE_LOAD_HEADERS table, which defines the shipment master. As indicated by the foreign keys, it has direct relationships with tables that store associated financial and attribute data: FTE_LOAD_CHARGES for accrued freight costs and FTE_LOAD_PRC_ATTRIBUTES for rating-specific details. The self-referencing foreign key on PARENT_LOAD_DETAIL_ID enables the modeling of nested packaging hierarchies. Furthermore, it is referenced by FTE_PA_SHIP_DETAILS, linking shipment execution data to Project Accounting for project-related freight. These relationships underscore the table's integral role in connecting logistical execution to financial costing and broader enterprise processes.