Search Results qp_attribute_groups




Overview
Explore in AI Chat

Overview

QP_ATTRIBUTE_GROUPS is a core Advanced Pricing (QP) table in Oracle EBS 12.1.1 and 12.2.2 that stores the attribute grouping definitions applied to pricing list lines and modifier list lines. Each row defines a set of qualifier attributes (a "group") that must be evaluated together when the pricing engine determines whether a list line or modifier line qualifies for a given transaction. The table effectively bridges pricing list lines, qualifier patterns, and pricing phases, allowing the pricing engine to organize and evaluate complex qualifier logic.

From a data-modeling perspective, the mined foreign key structure classifies QP_ATTRIBUTE_GROUPS heuristically as a standalone object, though its dependency on QP_LIST_LINES, HR_PATTERNS, and QP_PRICING_PHASES suggests it functions more like a detail/satellite table in practice. Each row is owned by a specific list line and belongs to a pricing phase, so it is best understood as an extension of the pricing list line structure rather than an independent reference entity.

Key Information Stored

The table contains 52 documented columns in the 12.2.2 schema. The most functionally significant are:

The table does not expose a single documented surrogate primary key in the metadata, but LIST_LINE_ID combined with GROUPING_NO and PRICING_PHASE_ID typically serves as the effective business-key candidate. Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_ID, REQUEST_ID) are present for concurrent program tracking.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios include identifying which attribute groups are active for a given list line, verifying qualifier configuration before pricing runs, and tracing why a particular modifier did or did not qualify. A common query pattern:

  • Joining QP_ATTRIBUTE_GROUPS to QP_LIST_LINES on LIST_LINE_ID and LIST_HEADER_ID to retrieve the qualifier group for a specific price list.
  • Joining to QP_PRICING_PHASES on PRICING_PHASE_ID to determine evaluation order.
  • Joining to HR_PATTERNS on PATTERN_ID to review validation patterns.
  • Filtering on ACTIVE_FLAG = 'Y' and current date between START_DATE_ACTIVE_Q and END_DATE_ACTIVE_Q.
  • Aggregating counts by PRICING_PHASE_ID and MODIFIER_LEVEL_CODE for configuration health checks.

DBAs also use this table during pricing engine cache diagnostics, since HASH_KEY and CACHE_KEY are maintained for performance-critical lookups.

Related Objects

  • QP_LIST_LINES – joined on LIST_LINE_ID; the primary parent of each attribute group.
  • QP_LIST_HEADERS – joined on LIST_HEADER_ID; governs the pricing list context.
  • HR_PATTERNS – joined on PATTERN_ID; supplies attribute validation patterns.
  • QP_PRICING_PHASES – joined on PRICING_PHASE_ID; defines evaluation phase.
  • QP_QUALIFIERS and QP_QUALIFIER_ATTRIBUTES – consume grouping definitions to evaluate qualifiers.
  • QP_PRICING_ATTRIBUTES – provides the underlying attribute metadata referenced by groups.
  • QP_MODIFIERS and QP_PRICE_LIST_LINES – downstream consumers of group-based qualification logic.
  • Pricing engine PL/SQL APIs such as QP_Price_Request / QP_PREQ packages – programmatic consumers at runtime.