Search Results qp_limit_attributes_pk

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:

• LIMIT_ATTRIBUTE_ID — the surrogate primary key, enforced by QP_LIMIT_ATTRIBUTES_PK and also by the unique index QP_LIMIT_ATTRIBUTES_U1. This is the only documented business-key candidate.
• LIMIT_ID — foreign key to QP_LIMITS, linking each attribute row to its owning limit.
• LIMIT_ATTRIBUTE_TYPE — classifies the attribute being defined (e.g., the category of dimension).
• LIMIT_ATTRIBUTE_CONTEXT — the context under which the attribute applies.
• LIMIT_ATTRIBUTE — the attribute itself (the dimension name).
• LIMIT_ATTR_VALUE — the value assigned to that attribute for the limit.
• LIMIT_ATTR_DATATYPE — the data type of the attribute value.
• COMPARISON_OPERATOR_CODE — the comparison operator used when evaluating the attribute value (e.g., equals, greater than).
• CONTEXT — a reserved context column, part of the standard descriptive flexfield implementation.
• ATTRIBUTE1 through ATTRIBUTE15 — the DFF segments used to store flexfield-defined descriptive data.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and the concurrent program columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) that track audit and interface provenance.

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.