Search Results aso_price_attributes




Overview
Explore in AI Chat

Overview

ASO_PRICE_ATTRIBUTES is a table in the ASO (Order Capture) schema of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It stores the qualifier and pricing attribute values captured for a quote or sales order line, together with the pricing context under which those attributes were evaluated. Each row represents the set of pricing attribute values that a corresponding price adjustment line qualified against during pricing engine evaluation, providing the auditable record of why a particular modifier, discount, surcharge, or list price was applied.

From a Data Vault modeling perspective, the mined foreign key structure suggests classifying this object as a link. It carries no natural parent data of its own; instead it associates a quote header, a quote line, and a security group with the attribute payload that drove pricing. A satellite classification is also defensible because the row is descriptive rather than purely associative, but the presence of multiple outbound foreign keys to transactional parents favors the link interpretation.

Key Information Stored

The physical schema documents 138 columns. The most operationally significant are:

The surrogate key PRICE_ATTRIBUTE_ID is not a business key; uniqueness is effectively enforced through the combination of the parent quote line, pricing context, and the populated attribute slots.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include reconstructing why a discount fired on a given quote line, auditing manual pricing overrides, and extracting attribute values into downstream analytics or order management feeds.

  • Attribute capture history for a quote header and its lines, joined to ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL on QUOTE_HEADER_ID and QUOTE_LINE_ID respectively.
  • Detection of manual overrides — filter rows where OVERRIDE_FLAG is set.
  • Context-based reporting — group by PRICING_CONTEXT or FLEX_TITLE to analyze which qualifier contexts were used.
  • Reconciliation against QP pricing results by matching the populated PRICING_ATTRIBUTEn values with qualifier definitions in the QP schema.

A representative query pattern joins the header and line to the attributes:

SELECT h.QUOTE_HEADER_ID, h.QUOTE_NUMBER, l.QUOTE_LINE_ID, a.PRICING_CONTEXT, a.FLEX_TITLE, a.OVERRIDE_FLAG FROM ASO_QUOTE_HEADERS_ALL h, ASO_QUOTE_LINES_ALL l, ASO_PRICE_ATTRIBUTES a WHERE h.QUOTE_HEADER_ID = a.QUOTE_HEADER_ID AND l.QUOTE_LINE_ID = a.QUOTE_LINE_ID AND h.QUOTE_HEADER_ID = :p_header_id;

Related Objects

  • ASO_QUOTE_HEADERS_ALL — referenced via QUOTE_HEADER_ID; the parent quote or sales order header.
  • ASO_QUOTE_LINES_ALL — referenced via QUOTE_LINE_ID; the priced orchestration line.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs record-level data security.
  • QP_PRICE_ADJUSTMENTS and related QP pricing tables — hold the price adjustment lines that the attribute set logically qualified for, joined by quote line and pricing context.
  • ASO_PRICE_ADJUSTMENTS — the ASO-side counterpart that stores the adjustment applied to the quote line as a result of qualification.
  • Qp_Attr_Defns / QP qualifier setup tables — define the attribute names that populate the PRICING_ATTRIBUTEn slots and FLEX_TITLE for each PRICING_CONTEXT.

Because ASO_PRICE_ATTRIBUTES carries both the transactional linkage and the descriptive qualifier payload, it is best treated as the authoritative audit trail of pricing qualification for order capture and quoting flows across EBS 12.1.1 and 12.2.2.