Search Results qp_limit_attributes




Overview
Explore in AI Chat

Overview

QP_LIMIT_ATTRIBUTES is a table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. It stores the attributes that define the dimensions of a pricing limit or balance — for example customer, product, or other qualifier dimensions used by Oracle Advanced Pricing limits. Each row associates a single attribute definition and its value with a parent limit record in QP_LIMITS, effectively specifying "which dimension" a limit is applied across and "what value" that dimension takes.

From a Data Vault modeling perspective, the FK relationship (LIMIT_ATTRIBUTE_ID as the primary key, LIMIT_ID referencing QP_LIMITS) suggests a satellite-leaning classification: the table carries descriptive, context-dependent attributes keyed to a single parent hub/link (the limit). This is a heuristic suggestion, not a documented Oracle classification, but it reflects the table's role as a descriptive extension of the limit entity.

Key Information Stored

The table is documented with 33 columns in the ETRM 12.2.2 physical schema. The most significant are:

Common Use Cases and Queries

Typical reporting scenarios include retrieving all attribute dimensions for a given limit, verifying which customer or product dimensions a limit spans, and auditing attribute changes. A common join pattern is:

  • Join QP_LIMIT_ATTRIBUTES to QP_LIMITS on LIMIT_ATTRIBUTES.LIMIT_ID = QP_LIMITS.LIMIT_ID to report limit definitions alongside their attribute dimensions.
  • Filter by LIMIT_ATTRIBUTE_TYPE or LIMIT_ATTRIBUTE to enumerate limits by dimension category (e.g., all limits driven by customer attribute).
  • Query COMPARISON_OPERATOR_CODE and LIMIT_ATTR_DATATYPE to validate limit evaluation logic in pricing setups.
  • Extract CONTEXT and ATTRIBUTE1–15 for DFF-based reporting on custom limit metadata.

Because the table is a child of QP_LIMITS, queries usually begin from the parent limit and drill into the attributes, or aggregate attributes per limit to detect limits with incomplete dimension coverage.

Related Objects

  • QP_LIMITS — the direct parent table; joined via QP_LIMIT_ATTRIBUTES.LIMIT_ID = QP_LIMITS.LIMIT_ID. This is the most significant relationship.
  • QP_LIMIT_ATTRIBUTES_PK — the primary key constraint on LIMIT_ATTRIBUTE_ID.
  • QP_LIMIT_ATTRIBUTES_U1 — the unique index on LIMIT_ATTRIBUTE_ID.
  • QP_LIMIT_BALANCES and related QP limit/balance tables — consume attribute dimensions to evaluate balance limits against qualifier values.
  • QP pricing qualifier and modifier views — reporting views in the Advanced Pricing module frequently join QP_LIMIT_ATTRIBUTES to resolve qualifier context for pricing rules.

These objects collectively form the Advanced Pricing limits framework, with QP_LIMIT_ATTRIBUTES serving as the dimensional detail layer beneath each limit definition.