Search Results shipment




The FTE_QP_LINE_DETAIL_TEMP table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as a temporary staging table for freight transaction details during the processing of freight rate calculations and pricing within the Oracle Transportation Management (OTM) and Oracle Advanced Pricing (QP) integration framework. This table is primarily utilized by the Freight Transaction Engine (FTE) to temporarily store line-level details before they are processed or transferred to permanent tables. Below is a detailed breakdown of its purpose, structure, and functional context.

Purpose and Functional Context

The FTE_QP_LINE_DETAIL_TEMP table acts as an intermediary storage for freight-related line items during the pricing and rating process. When a freight transaction is initiated, Oracle EBS leverages this table to hold transient data such as shipment details, pricing attributes, and charge breakdowns before applying business rules, discounts, or surcharges via Oracle Advanced Pricing (QP). This temporary storage ensures data integrity during complex pricing calculations and allows for rollback mechanisms in case of errors. The table is typically populated during the execution of freight rating programs or APIs, such as those invoked by the Freight Transaction Engine or OTM integrations.

Key Columns and Data Structure

While the exact schema may vary slightly between EBS 12.1.1 and 12.2.2, the table generally includes the following critical columns:
  • TRANSACTION_ID: A unique identifier linking temporary records to the main freight transaction.
  • LINE_ID: Identifies individual line items within a freight transaction.
  • SHIPMENT_NUMBER: References the associated shipment in OTM or EBS.
  • PRICING_ATTRIBUTES: Stores freight-specific attributes (e.g., weight, distance, service level) used for pricing calculations.
  • CHARGE_TYPE: Indicates the type of freight charge (e.g., base freight, accessorial).
  • RATE: The calculated or proposed rate for the line item.
  • STATUS: Tracks the processing state (e.g., 'Pending', 'Processed', 'Error').
  • CREATION_DATE and LAST_UPDATE_DATE: Timestamps for auditing and troubleshooting.

Integration with Oracle Modules

The table integrates with several Oracle EBS modules:
  1. Oracle Advanced Pricing (QP): Supplies pricing rules and modifiers applied to the temporary data.
  2. Freight Transaction Engine (FTE): Manages the lifecycle of freight transactions, including populating and clearing this table.
  3. Order Management (OM): Links freight charges to sales orders or returns when applicable.
  4. Oracle Transportation Management (OTM): Shares shipment data for rate shopping and execution.

Data Lifecycle and Cleanup

Records in FTE_QP_LINE_DETAIL_TEMP are transient and typically deleted after successful processing or upon system cleanup jobs. Administrators may monitor this table for orphaned records, which can indicate failed transactions. In EBS 12.2.2, enhanced purge utilities automate this maintenance, reducing manual intervention compared to 12.1.1.

Performance Considerations

Given its temporary nature, the table is often indexed on TRANSACTION_ID and STATUS to optimize query performance during pricing runs. Excessive record retention can lead to storage bloat, so periodic audits are recommended. In summary, FTE_QP_LINE_DETAIL_TEMP is a critical component in Oracle EBS freight and pricing workflows, ensuring accurate, auditable, and efficient processing of line-level freight data across integrated modules.