Search Results parameter_instance_id

Overview

The FTE_PRC_PARAMETERS table is a core data object within the Oracle E-Business Suite (EBS) Transportation Execution (FTE) module. Its primary function is to store detailed pricing parameters that govern the freight rating and costing processes. This table acts as a junction point, linking specific transportation lanes, pricing lists, and parameter definitions to create a comprehensive and configurable pricing rule set. The integrity of its data is critical for accurate freight cost calculations, carrier selection, and shipment planning within the Oracle Transportation Management framework of EBS.

Key Information Stored

The table's structure is designed to associate pricing logic with specific operational contexts. Its primary key is PARAMETER_INSTANCE_ID, which uniquely identifies each parameter record. The most significant columns define the relationships that give the parameters their meaning: LANE_ID links to a specific transportation lane in FTE_LANES, LIST_HEADER_ID references a pricing list in QP_LIST_HEADERS_B (from the Pricing module), and PARAMETER_ID connects to the master definition of the parameter type in FTE_PRC_PARAMETER_DEFAULTS. Together, these columns establish which pricing rule (from which list) applies to which lane, forming the basis for the rating engine's lookups.

Common Use Cases and Queries

This table is central to freight cost determination. A common operational query involves retrieving all active pricing parameters for a specific lane to evaluate applicable rates during shipment creation or planning. For reporting and auditing, analysts may run queries to list all pricing parameters associated with a particular carrier's price list to validate contract coverage. Troubleshooting incorrect freight charges often involves tracing data from this table to verify that the correct lane-list-parameter associations are in place. A typical diagnostic SQL pattern would join FTE_PRC_PARAMETERS with FTE_LANES and QP_LIST_HEADERS_B to validate the relationships for a given shipment's origin, destination, and carrier.

Related Objects

The FTE_PRC_PARAMETERS table maintains defined foreign key relationships with several key EBS objects, as documented in the ETRM metadata:

• FTE_LANES: Joined via FTE_PRC_PARAMETERS.LANE_ID = FTE_LANES.LANE_ID. This links pricing parameters to specific origin-destination lane definitions.
• QP_LIST_HEADERS_B: Joined via FTE_PRC_PARAMETERS.LIST_HEADER_ID = QP_LIST_HEADERS_B.LIST_HEADER_ID. This relationship connects parameters to the Qualifier (Pricing) module's price lists, which contain the actual rate schedules and modifiers.
• FTE_PRC_PARAMETER_DEFAULTS: Joined via FTE_PRC_PARAMETERS.PARAMETER_ID = FTE_PRC_PARAMETER_DEFAULTS.PARAMETER_ID. This ties the instance to the master definition of the parameter, which controls its data type, validation, and default behavior.

These relationships position FTE_PRC_PARAMETERS as a critical hub between transportation network data (lanes), pricing master data (lists), and configurable rating logic (parameter definitions).