Search Results qp_qualifiers




The QP_QUALIFIERS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Advanced Pricing module, which governs the application of pricing rules, discounts, and promotions. This table stores qualifier conditions that determine eligibility for pricing adjustments based on predefined business criteria. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.

1. Purpose and Role in Oracle EBS

The QP_QUALIFIERS table defines the conditions under which pricing adjustments (e.g., discounts, surcharges, or special offers) are applied to transactions. It works in conjunction with other Advanced Pricing tables (QP_PRICING_ATTRIBUTES, QP_LIST_HEADERS, etc.) to evaluate whether a transaction meets the criteria for a pricing rule. Qualifiers can be based on attributes like customer type, order value, product category, or geographic region.

2. Key Columns and Structure

The table includes columns such as:

  • QUALIFIER_ID: Primary key.
  • LIST_HEADER_ID: Links to QP_LIST_HEADERS for the pricing rule.
  • QUALIFIER_GROUPING_NO: Groups related qualifiers.
  • COMPARISON_OPERATOR (e.g., "=", ">="): Defines the logic for evaluation.
  • ATTRIBUTE_TYPE: Specifies the attribute being evaluated (e.g., customer, item, date).
  • ATTRIBUTE_VALUE: The value to compare against (e.g., customer ID "10045").
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Validity period.

3. Integration with Pricing Engine

During order entry (e.g., in Order Management or Quoting), the Pricing Engine references QP_QUALIFIERS to validate if the transaction qualifies for a pricing rule. For example, a discount may apply only if:

  • The customer belongs to a "GOLD" tier (ATTRIBUTE_TYPE = 'CUSTOMER', ATTRIBUTE_VALUE = 'GOLD').
  • The order total exceeds $1,000 (COMPARISON_OPERATOR = '>=', ATTRIBUTE_VALUE = '1000').
The engine evaluates these conditions hierarchically, often combining multiple qualifiers using AND/OR logic.

4. Customization and Extensions

Oracle EBS allows extensions to QP_QUALIFIERS via:

  • User-Defined Attributes: Custom columns can be added to support unique business rules.
  • API Hooks: QP_PREQ_PROCESS and QP_CALCULATE_PRICE APIs enable programmatic qualifier overrides.
  • Modifier Contexts: Qualifiers can be context-sensitive (e.g., apply only during seasonal promotions).

5. Performance Considerations

Large-scale deployments may require indexing strategies on LIST_HEADER_ID and ATTRIBUTE_TYPE to optimize query performance. Partitioning by date ranges (START_DATE_ACTIVE) is recommended for historical data management.

6. Example Use Case

A retail company configures a holiday promotion where:

  • Qualifier 1: ATTRIBUTE_TYPE = 'ITEM_CATEGORY', ATTRIBUTE_VALUE = 'ELECTRONICS'.
  • Qualifier 2: ATTRIBUTE_TYPE = 'ORDER_DATE', COMPARISON_OPERATOR = 'BETWEEN', ATTRIBUTE_VALUE = '01-DEC-2023:31-DEC-2023'.
The Pricing Engine checks QP_QUALIFIERS to apply a 15% discount only to electronics orders placed in December 2023.

7. Conclusion

The QP_QUALIFIERS table is foundational to Oracle EBS Advanced Pricing, enabling granular control over pricing strategies. Its design supports complex, multi-attribute conditions while maintaining flexibility for customization. Proper configuration ensures accurate, performant pricing calculations aligned with business requirements.

  • Table: QP_QUALIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_QUALIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_INTERFACE_QUALIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_QUALIFIERS,  object_name:QP_INTERFACE_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_INTERFACE_QUALIFIERS , 

  • Table: QP_INTERFACE_QUALIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_QUALIFIERS,  object_name:QP_INTERFACE_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_INTERFACE_QUALIFIERS , 

  • Table: QP_QUALIFIER_RULES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIER_RULES,  object_name:QP_QUALIFIER_RULES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIER_RULES stores the header information for all qualifier rules ,  implementation_dba_data: QP.QP_QUALIFIER_RULES , 

  • View: QP_LINE_LVL_QUAL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINE_LVL_QUAL_V,  object_name:QP_LINE_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual ,  implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V , 

  • View: QP_LINE_LVL_QUAL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINE_LVL_QUAL_V,  object_name:QP_LINE_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual ,  implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V , 

  • Table: QP_QUALIFIER_RULES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIER_RULES,  object_name:QP_QUALIFIER_RULES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIER_RULES stores the header information for all qualifier rules ,  implementation_dba_data: QP.QP_QUALIFIER_RULES , 

  • Table: QP_QUALIFIERS_EBS_LOG 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS_EBS_LOG,  object_name:QP_QUALIFIERS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_QUALIFIERS_EBS_LOG , 

  • Table: QP_QUALIFIERS_EBS_LOG 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS_EBS_LOG,  object_name:QP_QUALIFIERS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_QUALIFIERS_EBS_LOG , 

  • View: QP_HDR_LVL_QUAL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_HDR_LVL_QUAL_V,  object_name:QP_HDR_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual ,  implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V , 

  • View: QP_HDR_LVL_QUAL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_HDR_LVL_QUAL_V,  object_name:QP_HDR_LVL_QUAL_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual ,  implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V , 

  • View: QPBV_QUALIFIERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_QUALIFIERS,  object_name:QPBV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_QUALIFIERS , 

  • View: QPBV_QUALIFIERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_QUALIFIERS,  object_name:QPBV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_QUALIFIERS , 

  • View: QPFV_QUALIFIERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_QUALIFIERS,  object_name:QPFV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_QUALIFIERS , 

  • View: QPBV_SECONDARY_PRICE_LISTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • View: QPFV_QUALIFIERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_QUALIFIERS,  object_name:QPFV_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Qualifiers attached to a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_QUALIFIERS , 

  • View: QPBV_SECONDARY_PRICE_LISTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • View: QP_QUALIFIERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIERS_V,  object_name:QP_QUALIFIERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier information ,  implementation_dba_data: APPS.QP_QUALIFIERS_V , 

  • View: QP_QUALIFIERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIERS_V,  object_name:QP_QUALIFIERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier information ,  implementation_dba_data: APPS.QP_QUALIFIERS_V , 

  • View: QP_QUALIFIER_RULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIER_RULES_V,  object_name:QP_QUALIFIER_RULES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier Rule information ,  implementation_dba_data: APPS.QP_QUALIFIER_RULES_V , 

  • View: QP_QUALIFIER_RULES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_QUALIFIER_RULES_V,  object_name:QP_QUALIFIER_RULES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View of Qualifier Rule information ,  implementation_dba_data: APPS.QP_QUALIFIER_RULES_V , 

  • Table: QP_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • View: OE_DISCOUNT_CUSTOMERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNT_CUSTOMERS_V,  object_name:OE_DISCOUNT_CUSTOMERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNT_CUSTOMERS_V , 

  • View: OE_DISCOUNT_CUSTOMERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNT_CUSTOMERS_V,  object_name:OE_DISCOUNT_CUSTOMERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNT_CUSTOMERS_V , 

  • Table: QP_LIST_HEADERS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • Table: QP_LIST_HEADERS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • View: OE_DISCOUNTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V , 

  • View: OE_DISCOUNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V ,