Search Results fte_prc_parameter_defaults




Overview
Explore in AI Chat

Overview

The FTE_PRC_PARAMETER_DEFAULTS table is a core data object within the Oracle E-Business Suite Transportation Execution (FTE) module. Its primary function is to store the default values assigned to pricing parameters used in freight rating and costing calculations. This table acts as a central repository for baseline configuration, ensuring that pricing engines and processes have consistent, pre-defined values to use when specific parameter inputs are not provided during a transaction. Its role is critical for maintaining standardized and predictable freight cost determinations across the logistics lifecycle.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the key, the structure centers on the relationship between a parameter and its default value. The primary column is PARAMETER_ID, which serves as the unique identifier linking back to the master list of pricing parameters. The table likely contains additional columns to store the actual default value (potentially named DEFAULT_VALUE or similar) and possibly contextual attributes such as an effective date range (START_DATE, END_DATE) or a modifier to indicate how the default is applied. The existence of a primary key on PARAMETER_ID confirms that each parameter can have, at most, one default record in this table.

Common Use Cases and Queries

This table is primarily accessed during the freight rating process. When a user or an integrated system requests a freight cost for a shipment, the pricing engine references parameter defaults to populate any missing information required for the complex rate calculations. Common administrative use cases include auditing and maintaining the default pricing configuration. A typical query would join this table to the master parameters table to review the complete setup.

  • Sample Query to List All Parameter Defaults:
    SELECT p.PARAMETER_NAME, d.DEFAULT_VALUE
    FROM FTE.FTE_PRC_PARAMETERS p,
    FTE.FTE_PRC_PARAMETER_DEFAULTS d
    WHERE p.PARAMETER_ID = d.PARAMETER_ID
    AND SYSDATE BETWEEN d.START_DATE AND NVL(d.END_DATE, SYSDATE+1);
  • Reporting Use Case: Generating a report of all pricing parameters that do not have a configured default value, highlighting potential gaps in the pricing setup.

Related Objects

The table has a direct and documented foreign key relationship with the master parameters table. This relationship is fundamental to its purpose.

  • FTE_PRC_PARAMETERS: This is the primary parent table. The foreign key constraint links FTE_PRC_PARAMETER_DEFAULTS.PARAMETER_ID to FTE_PRC_PARAMETERS.PARAMETER_ID. Any parameter default must correspond to a valid record in this master definition table. This table defines the parameter's name, data type, and other control attributes.
  • The table is also intrinsically related to the core FTE pricing engine and any APIs or views that retrieve pricing parameter values, such as those used by the Rate Manager or Shipment Costing processes.