Search Results qp_qualifiers

Overview

QP_QUALIFIERS is a core Advanced Pricing (QP) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores qualifier attribute information. Qualifiers are the conditional filters attached to price lists, modifier lists, and promotion lists that determine when a given price, adjustment, or benefit should apply to a transaction line. Each qualifier row defines a single qualifying condition — for example, "attribute X of the pricing context equals value Y" — and may be grouped with other qualifier rows to form a compound Boolean expression. The table is owned by the QP schema and is classified as VALID across both releases.

From a heuristic Data Vault modeling perspective, QP_QUALIFIERS is best treated as a link entity rather than a hub. Its surrogate primary key, QUALIFIER_ID (enforced via QP_QUALIFIERS_PK), anchors the row, but the table's semantics are defined largely by its foreign key relationships to pricing list headers, list lines, and qualifier rules, which together describe the intersection of a pricing list context and a qualifying condition.

Key Information Stored

QP_QUALIFIERS contains 55 documented columns in 12.2.2. The most operationally significant are:

• QUALIFIER_ID — the surrogate primary key (QP_QUALIFIERS_PK); unique within the table.
• QUALIFIER_CONTEXT and CONTEXT — the pricing context under which the qualifier operates (for example, CUSTOMER, ORDER, or ITEM).
• QUALIFIER_ATTRIBUTE and QUALIFIER_ATTR_VALUE — the attribute being tested and its target value.
• QUALIFIER_DATATYPE, COMPARISON_OPERATOR_CODE, and QUALIFIER_ATTR_VALUE_TO — control the data type and the operator (such as equals, between, or greater than), enabling range qualifications when a lower/upper pair is used.
• QUAL_ATTR_VALUE_FROM_NUMBER and QUAL_ATTR_VALUE_TO_NUMBER — numeric bounds used for numeric range qualifiers.
• QUALIFIER_GROUPING_NO, QUALIFIER_GROUP_CNT, and OTHERS_GROUP_CNT — the grouping and Boolean-connector metadata that assembles individual rows into a complete qualifier expression.
• EXCLUDER_FLAG — indicates whether the condition acts as an inclusion or exclusion filter.
• LIST_HEADER_ID and LIST_LINE_ID — foreign keys tying the qualifier to its parent price list, modifier list, or promotion and its specific line.
• QUALIFIER_RULE_ID and CREATED_FROM_RULE_ID — foreign keys referencing QP_QUALIFIER_RULES, supporting rule-based generation of qualifiers.
• START_DATE_ACTIVE, END_DATE_ACTIVE, and ACTIVE_FLAG — effective dating and enablement controls.
• SEGMENT_ID — foreign key to CSF_TDS_SEGMENTS, linking the qualifier to a descriptive flexfield segment definition.

Common Use Cases and Queries

The most frequent requirement is to list all qualifiers for a given price list or promotion. For example:

SELECT q.qualifier_id, q.qualifier_context, q.qualifier_attribute,
       q.qualifier_attr_value, q.comparison_operator_code,
       q.excluder_flag, q.active_flag
  FROM qp.qp_qualifiers q
 WHERE q.list_header_id = :header_id
   AND NVL(q.active_flag,'Y') = 'Y';

Because promotion and modifier lists frequently change, tuning reports often join QP_QUALIFIERS to QP_LIST_HEADERS_B to expose the list name alongside qualifier detail, and to QP_LIST_LINES to identify which benefit line the qualifier gates. Effective-dating queries filtering on START_DATE_ACTIVE and END_DATE_ACTIVE support price list validation and historic analysis. Analysts also reconcile qualifiers to QP_QUALIFIER_RULES to confirm which expressions were generated automatically versus entered manually, using CREATED_FROM_RULE_ID. Data-quality checks frequently count distinct qualifier attributes per list to detect redundant or orphaned qualifier rows following list maintenance.

Related Objects

• QP_LIST_HEADERS_B — parent price, modifier, or promotion list; joined on QP_QUALIFIERS.LIST_HEADER_ID = QP_LIST_HEADERS_B.LIST_HEADER_ID.
• QP_LIST_LINES — the specific list line a qualifier applies to; joined on QP_QUALIFIERS.LIST_LINE_ID = QP_LIST_LINES.LIST_LINE_ID.
• QP_QUALIFIER_RULES — the rule definitions that generate or reference qualifiers; joined via QUALIFIER_RULE_ID and CREATED_FROM_RULE_ID.
• CSF_TDS_SEGMENTS — the descriptive flexfield segment source for the qualifier; joined on QP_QUALIFIERS.SEGMENT_ID = CSF_TDS_SEGMENTS.SEGMENT_ID.
• QP_PRICING_ATTRIBUTES — commonly used alongside QP_QUALIFIERS to resolve valid contexts and attribute names.
• QP_QUALIFIERS_TL (where present in translated installs) — the translation table for qualifier descriptions, joined on QUALIFIER_ID.