Search Results qp_qualifier_rules




Overview
Explore in AI Chat

Overview

The QP_QUALIFIER_RULES table is a core repository within the Oracle E-Business Suite Advanced Pricing (QP) module. It functions as the header-level table for storing the definition and control information for all qualifier rules. In the context of Advanced Pricing, a qualifier rule is a logical construct that defines the specific conditions under which a pricing modifier, such as a discount or surcharge, is applicable. These conditions can be based on a wide array of attributes, including customer characteristics, sales channel, product category, or geographic location. The table's primary role is to maintain the unique identity, status, and metadata for each rule, which is then detailed through its child records in related tables.

Key Information Stored

The table's structure is designed to manage the lifecycle and identity of each qualifier rule. The most critical column is the QUALIFIER_RULE_ID, which serves as the system-generated primary key and unique identifier for every rule. While the provided ETRM metadata does not list all columns, standard practice and the table's description indicate it typically stores header-level attributes. These commonly include fields for the rule's name, a user-facing code, an effective start and end date, an active status flag, and audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. The table acts as the anchor point, with the specific qualifying conditions and their values stored in the related QP_QUALIFIERS table.

Common Use Cases and Queries

This table is central to pricing configuration analysis, troubleshooting, and impact assessment. A frequent use case involves identifying all active qualifier rules linked to a specific pricing modifier or analyzing rules that are effective within a given date range. Technical consultants often query this table to understand rule dependencies or to generate configuration reports. A foundational query pattern involves joining to the QP_QUALIFIERS table to see the complete rule definition.

  • Sample Query: Retrieve active qualifier rule headers:
    SELECT qualifier_rule_id, name, start_date_active, end_date_active FROM qp_qualifier_rules WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
  • Sample Query: Join to child qualifiers:
    SELECT qr.qualifier_rule_id, qr.name, q.qualifier_context, q.qualifier_attribute, q.qualifier_attr_value FROM qp_qualifier_rules qr, qp_qualifiers q WHERE qr.qualifier_rule_id = q.qualifier_rule_id ORDER BY qr.qualifier_rule_id;

Related Objects

The QP_QUALIFIER_RULES table has a direct and essential parent-child relationship within the Advanced Pricing schema, as documented in the provided foreign key metadata.

  • QP_QUALIFIERS: This is the primary dependent table. The foreign key QP_QUALIFIERS.CREATED_FROM_RULE_ID references the QP_QUALIFIER_RULES.QUALIFIER_RULE_ID column. Each record in QP_QUALIFIER_RULES can have multiple child records in QP_QUALIFIERS, which store the detailed qualifying conditions (e.g., Customer = "ACME Corp", Item Category = "ELECTRONICS") that constitute the full rule logic.
  • QP_QUALIFIER_RULES_PK: The primary key constraint on the QUALIFIER_RULE_ID column, ensuring the uniqueness of each rule header.

Indirectly, qualifier rules are associated with pricing entities like modifiers and formulas through the pricing engine's internal logic, though these relationships are typically managed through other interface or setup tables not listed in the provided metadata.