Search Results qp_qualifiers

Overview

The QP_QUALIFIERS table is a core data structure within the Oracle E-Business Suite Advanced Pricing (QP) module. It functions as the central repository for storing detailed qualifier attribute information. In the context of the pricing engine, a qualifier defines the specific conditions under which a price, modifier, or promotion is applicable. This table holds the discrete attribute values that constitute these conditions, linking them to specific pricing entities such as price lists or individual list lines. Its role is critical for enabling complex, attribute-based pricing rules that are fundamental to the Advanced Pricing module's functionality in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store the linkage between a pricing rule and the specific attribute values that qualify its application. The key columns, as indicated by the metadata, include the primary key QUALIFIER_ID, which uniquely identifies each qualifier record. The table maintains relationships to major pricing objects via foreign keys: LIST_HEADER_ID links to QP_LIST_HEADERS_B for header-level qualifiers, LIST_LINE_ID links to QP_LIST_LINES for line-level qualifiers, and CREATED_FROM_RULE_ID links to QP_QUALIFIER_RULES, indicating the rule template from which the qualifier was instantiated. Other typical columns (implied by its function) would store the qualifier context (e.g., Customer, Product), attribute code, operator (e.g., =, BETWEEN), and the attribute value(s).

Common Use Cases and Queries

This table is primarily accessed for troubleshooting pricing engine behavior, auditing pricing rules, and generating custom price qualification reports. A common query involves identifying all qualifiers attached to a specific price list to understand its applicability. For example:

• SELECT qualifier_id, list_header_id, attribute, operand FROM qp_qualifiers WHERE list_header_id = <price_list_id>;

Another frequent use case is analyzing the lineage of a qualifier by joining to QP_QUALIFIER_RULES via CREATED_FROM_RULE_ID. Reporting on customer-specific or product-specific pricing conditions also requires querying this table to extract the stored attribute values that define those conditions.

Related Objects

As defined by its foreign keys, QP_QUALIFIERS has direct, integral relationships with several core pricing tables. It is a child table of QP_LIST_HEADERS_B (for price lists) and QP_LIST_LINES (for price list lines and modifiers). It is also derived from QP_QUALIFIER_RULES, which stores the reusable qualifier rule templates. The table is heavily referenced by the pricing engine's internal logic during price list and modifier validation, as well as during the price request processing to evaluate which pricing rules qualify for a given transaction.