Search Results fte_freight_costs_temp_pk1

Overview

The FTE_FREIGHT_COSTS_TEMP table is a temporary data store within the Oracle E-Business Suite Transportation Execution (FTE) module. Its primary function, as defined in the ETRM documentation, is to hold temporary data specifically generated during the process of calculating freight rating estimates. This table acts as a transient repository, facilitating complex rating engine calculations by storing intermediate results before they are finalized, committed to permanent tables, or presented to the user. It is a critical technical component in the workflow for generating freight cost quotes and shipment estimates, enabling performance and data isolation during the rating process.

Key Information Stored

While the provided ETRM excerpt is concise, it confirms the existence of a primary key column named FREIGHT_COST_ID, enforced by the constraint FTE_FREIGHT_COSTS_TEMP_PK1. Based on its purpose for rating estimates, the table's structure typically includes columns to store the calculated cost breakdowns, such as base freight charges, accessorial fees, taxes, and total estimated cost. It will also contain key identifiers to link the temporary data to the specific rating request, shipment, lane, carrier, and service level being evaluated. Other common columns include rate sheet references, currency codes, unit of measure, and weight or distance bands used in the calculation. The temporary nature of the data implies the table is regularly purged or uses a session or context identifier to manage data lifecycle.

Common Use Cases and Queries

This table is primarily accessed programmatically by the FTE rating engine. Common use cases involve generating a freight quote from the "Shipment" or "Rate Request" forms, running a batch rating process, or performing a "what-if" analysis for different carrier or service options. Direct querying by end-users or standard reports is uncommon, as the data is transient. However, technical support or custom development may query it for debugging rating logic. A typical diagnostic query would join on the temporary session identifier.

SELECT freight_cost_id, estimated_amount, currency_code, carrier_id
FROM fte.fte_freight_costs_temp
WHERE session_id = :p_session_id
ORDER BY freight_cost_id;

Another pattern involves examining cost details for a specific estimate before the data is purged or committed.

Related Objects

The FTE_FREIGHT_COSTS_TEMP table interacts closely with several core FTE objects. It is a precursor to permanent freight cost tables like FTE_FREIGHT_COSTS. Its data is populated by and feeds into key rating engine packages, such as FTE_RATING_PUB. The table's content is directly tied to the definitions in FTE_RATE_OFFERS and FTE_RATE_GEOGRAPHIES, which provide the rules for calculation. Furthermore, it relates to master data tables including FTE_CARRIERS, FTE_SERVICE_LEVELS, and the shipping transaction tables (e.g., WSHP_DELIVERY_DETAILS), as these entities provide the context for the rating estimate.