Results for “pricing_attribute”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO_PRICE_ADJ_ATTRIBS is a table within the ASO (Order Capture) schema in Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the qualifier and pricing attribute records that a corresponding price adjustment line qualified for during pricing engine evaluation. When Oracle Advanced Pricing determines that a modifier or price adjustment applies to a given pricing context, the specific attributes and values that triggered or satisfied that qualification are persisted here. In effect, this table provides the audit trail explaining why a particular price adjustment matched a given line.

From a modeling perspective, the metadata's heuristic Data Vault classification labels this object as satellite-leaning. This is a reasonable suggestion: the table is a child of ASO_PRICE_ADJUSTMENTS and carries descriptive "context" attributes (the pricing attribute and its qualifying values) rather than acting as an independent hub or a many-to-many link. The satellite interpretation reflects that these rows exist to describe the adjustment they hang off.

Key Information Stored

The table contains 19 documented columns. The most operationally significant are:

• PRICE_ADJ_ATTRIB_ID — the surrogate primary key, enforced by ASO_PRICE_ADJ_ATTRIBS_PK and reinforced by unique index ASO_PRICE_ADJ_ATTRIBS_U1. This alone constitutes the business-key candidate.
• PRICE_ADJUSTMENT_ID — foreign key to ASO_PRICE_ADJUSTMENTS, tying each attribute row to its parent adjustment line. This is the critical join column.
• PRICING_CONTEXT — identifies the pricing context in which the attribute was evaluated.
• PRICING_ATTRIBUTE — names the specific attribute used as the qualifier (for example, a customer or product attribute).
• PRICING_ATTR_VALUE_FROM and PRICING_ATTR_VALUE_TO — the qualifying value or value range the adjustment matched against.
• COMPARISON_OPERATOR — the operator (equal, between, and so on) applied to the from/to values.
• FLEX_TITLE — the descriptive flexfield title associated with the pricing attribute.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org/security partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column.
• Standard WHO/audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus concurrent-program columns PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID.

The distinction is important: PRICE_ADJ_ATTRIB_ID is purely a surrogate key, while the semantic identity of a row is really the combination of PRICE_ADJUSTMENT_ID plus PRICING_CONTEXT/PRICING_ATTRIBUTE.

Common Use Cases and Queries

Typical scenarios include diagnosing why a promotion or modifier fired, auditing qualifier values for a specific adjustment, and reconciling pricing setup against executed orders.

A common pattern joins attributes to their parent adjustment:

• SELECT a.PRICE_ADJUSTMENT_ID, a.PRICING_ATTRIBUTE, a.PRICING_ATTR_VALUE_FROM, a.PRICING_ATTR_VALUE_TO, a.COMPARISON_OPERATOR FROM ASO_PRICE_ADJ_ATTRIBS a WHERE a.PRICE_ADJUSTMENT_ID = :adj_id;
• Reporting qualifier usage: aggregate COUNT by PRICING_ATTRIBUTE to find the most frequently used pricing qualifiers.
• Troubleshooting: filter on PRICING_ATTR_VALUE_FROM/TO to locate adjustments matching a specific customer or item value.
• Security-scoped extraction: join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID where org-level isolation is required.

Related Objects

• ASO_PRICE_ADJUSTMENTS — the parent object; join via ASO_PRICE_ADJ_ATTRIBS.PRICE_ADJUSTMENT_ID = ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data security partitioning.
• ASO_PRICE_ADJ_ATTRIBS_PK / ASO_PRICE_ADJ_ATTRIBS_U1 — the primary key constraint and unique index enforcing record identity.
• Pricing APIs in the QP (Advanced Pricing) module, whose evaluation logic populates these rows at runtime.
• Order Capture views in the ASO schema that surface adjustment qualifier details during order line processing.