Search Results fte_invoice_lines




Overview
Explore in AI Chat

Overview

FTE_INVOICE_LINES is a Transportation Execution (FTE) module table that stores the individual line-level details of freight and transportation invoices processed within Oracle E-Business Suite. It resides in the FTE schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Where the parent FTE_INVOICE_HEADERS table captures invoice-level attributes such as carrier, invoice number, and totals, FTE_INVOICE_LINES holds the granular charge, quantity, weight, volume, rate, discount, and surcharge information that constitutes each billed item on a transportation invoice.

The table is central to freight payment and audit workflows, providing the structured detail needed to reconcile carrier invoices against shipment and rate data. From a Data Vault modeling perspective, the documented foreign-key structure suggests a hub-leaning classification, with INVOICE_LINE_ID acting as the durable business key for each invoice line. Downstream tables across multiple modules reference this table, confirming its role as a foundational entity in the transportation execution data model.

Key Information Stored

The table contains 30 documented columns. The most significant are:

Common Use Cases and Queries

Typical uses include freight invoice audit reports, carrier spend analysis, line-level reconciliation against shipment and rate tables, and extraction into Accounts Payable interfaces for payment. A common query pattern joins the line to its header and filters by approved amount or line type:

  • SELECT l.invoice_line_id, l.invoice_line_num, l.invoice_line_type, l.approved_amount, h.carrier_id FROM fte.fte_invoice_lines l JOIN fte.fte_invoice_headers h ON h.invoice_header_id = l.invoice_header_id WHERE l.approved_amount > 0;
  • Aggregate freight charges by carrier or line type for spend reporting.
  • Reconcile billed weight and volume (TOTAL_WEIGHT, TOTAL_VOLUME) against shipment data to detect billing discrepancies.
  • Extract lines into AP_INVOICE_LINES_INTERFACE or AP_EXPENSE_FEED_DISTS_ALL using the INVOICE_LINE_ID reference for downstream payment processing.

Related Objects

  • FTE_INVOICE_HEADERS — Parent table; joined via INVOICE_HEADER_ID.
  • FTE_FAILURE_REASONS — References this table through PARENT_ID, capturing audit failure reasons per line.
  • AP_INVOICE_LINES_INTERFACE — AP interface table referencing INVOICE_LINE_ID for payable import.
  • AP_EXPENSE_FEED_DISTS_ALL — Expense distribution table referencing INVOICE_LINE_ID.
  • AP_PPA_INVOICE_LINES_GT — Global temporary table referencing INVOICE_LINE_ID during processing.
  • FV_IPAC_IMPORT / FV_IPAC_IMPORT_HISTORY — IPAC import structures referencing INVOICE_LINE_ID.
  • OKL_XTL_PAY_INVS_ALL_B — Lease payment invoice table referencing INVOICE_LINE_ID.
  • FA_LEASE_PAYMENT_ITEMS — Fixed Assets lease payment items referencing INVOICE_LINE_ID.