Search Results fte_chrg_prc_attributes

Overview

The FTE_CHRG_PRC_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Transportation Execution (FTE) module, specifically for versions 12.1.1 and 12.2.2. It functions as a detailed audit and reference table for the freight rating and pricing engine. Its primary role is to store the specific qualifying conditions and pricing attributes that were applied during the rating process to determine a particular freight charge for a shipment (Load) or a line item (Load Detail). This establishes a critical link between a calculated charge and the exact business rules, such as accessorials, commodity codes, or service levels, that justified its application, ensuring pricing transparency and auditability.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the description and foreign key relationship define its core data structure. The table's purpose is to hold attribute pairs that qualified a charge. Based on standard Oracle Pricing architecture, typical columns would include a foreign key to the parent charge record and attribute-value pairs. The confirmed critical column is LOAD_CHARGE_ID, which links each attribute record back to its parent charge in the FTE_LOAD_CHARGES table. Other expected columns would define the attribute type (e.g., qualifier context, pricing attribute) and its corresponding value, effectively answering *why* a specific rate or surcharge was applied to the shipment.

Common Use Cases and Queries

The primary use case is investigative reporting and dispute resolution for freight charges. Analysts can query this table to produce detailed charge justifications. A common SQL pattern involves joining to the main charges and loads tables to list all attributes for a specific shipment or charge. For example, to audit all charges on a load, one might use a query joining FTE_LOAD_CHARGES to FTE_CHRG_PRC_ATTRIBUTES via LOAD_CHARGE_ID. This reveals if a fuel surcharge was applied due to a specific fuel index qualifier or if a hazardous material fee was triggered by a commodity code attribute. It is essential for generating detailed customer invoices that break down charge components and for internal analysis of pricing rule effectiveness.

Related Objects

• FTE_LOAD_CHARGES: This is the primary parent table. The FTE_CHRG_PRC_ATTRIBUTES.LOAD_CHARGE_ID column is a foreign key to FTE_LOAD_CHARGES, meaning each row in this attributes table is a child of a specific calculated freight charge.
• FTE_LOADS / FTE_LOAD_DETAILS: As the ultimate sources for rating, these tables are indirectly related. Charges (FTE_LOAD_CHARGES) are created for loads or details, and their justifying attributes are stored in FTE_CHRG_PRC_ATTRIBUTES.
• QP_* Tables (Qualifiers, Attributes, Pricing Formulas): The specific qualifier and pricing attribute definitions that populate FTE_CHRG_PRC_ATTRIBUTES are typically managed within Oracle's Pricing (QP) module tables.