Search Results qp_pricing_attributes




Overview
Explore in AI Chat

Overview

The QP_PRICING_ATTRIBUTES table is a core data object within the Oracle E-Business Suite Advanced Pricing (QP) module. It serves as the central repository for storing the detailed product and attribute conditions that define pricing rules. Every pricing rule or modifier defined in the system, such as a discount, surcharge, or promotional price, is built upon specific qualifying conditions. This table stores the granular data for those conditions, linking a pricing rule (list line) to the specific product attributes—like inventory item, product category, or customer—that must be matched for the price to apply. Its role is fundamental to the pricing engine's ability to evaluate transactions and determine the correct price based on a multitude of configurable business rules.

Key Information Stored

The table's primary function is to associate pricing attributes with specific pricing list lines. The most critical columns include PRICING_ATTRIBUTE_ID, which is the unique primary key sequence for each attribute record. The LIST_LINE_ID is a foreign key that links the attribute directly to a price or modifier defined in the QP_LIST_LINES table. The table stores the type of attribute being defined (e.g., Item, Category, Customer) and its specific value. For example, a record may specify that its parent list line applies only to a specific INVENTORY_ITEM_ID, or to items belonging to a particular PRODUCT_ATTRIBUTE_VALUE (such as a product category). Other columns manage the context and structure of the pricing rule, controlling how multiple attributes are combined (using AND/OR logic) and the sequence of evaluation.

Common Use Cases and Queries

A primary use case is troubleshooting pricing calculations. When a transaction does not receive an expected discount, analysts query this table to verify the qualifying conditions attached to the pricing rule. Common SQL patterns involve joining QP_PRICING_ATTRIBUTES to QP_LIST_LINES and related setup tables. For instance, to find all product attributes for a specific price list line:

  • SELECT pa.* FROM qp_pricing_attributes pa WHERE pa.list_line_id = <LIST_LINE_ID> ORDER BY pa.pricing_attribute_id;

Another critical reporting use case is documenting the complete structure of a price list or modifier, which requires aggregating all attribute lines associated with its constituent list lines. Developers also interact with this table when building custom pricing logic or integrations, ensuring that any programmatically created pricing rules correctly populate the necessary attribute records.

Related Objects

The QP_PRICING_ATTRIBUTES table has integral relationships with several key objects in the Advanced Pricing schema. Its most direct relationship is defined by the foreign key QP_PRICING_ATTRIBUTES.LIST_LINE_ID, which references the QP_LIST_LINES table. Every record in QP_PRICING_ATTRIBUTES must belong to a parent list line. Furthermore, the pricing engine's logic heavily relies on this table when accessing pricing rules through public APIs like QP_PREQ_GRP and QP_PRICE_REQUEST_PUB. For reporting and simplified access, Oracle provides seeded views such as QP_PRICING_ATTRIBUTES_V, which may join this table to descriptive flexfields and value sets for more user-friendly querying. The table is also closely related to product and customer master data tables, such as MTL_SYSTEM_ITEMS and HZ_CUST_ACCOUNTS, via the attribute values stored within it.