Search Results aso_price_adj_attribs




Overview
Explore in AI Chat

Overview

The ASO_PRICE_ADJ_ATTRIBS table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module, specifically for versions 12.1.1 and 12.2.2. It functions as a detailed supporting table for the pricing engine, capturing the specific qualification criteria and attribute data that were satisfied to apply a particular price adjustment to an order line. Its primary role is to provide a granular audit trail, documenting not just that a discount, surcharge, or other price modifier was applied, but precisely why it was applied based on the transaction's characteristics. This data is critical for pricing transparency, complex discount analysis, and troubleshooting pricing logic.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented structure reveals its essential components. The table's primary key is PRICE_ADJ_ATTRIB_ID, which uniquely identifies each qualifier or attribute record. The most critical foreign key is PRICE_ADJUSTMENT_ID, which links each record to its parent price adjustment line in the ASO_PRICE_ADJUSTMENTS table. The table's description indicates it stores two key types of information: qualifiers (the conditions that were met, such as customer segment, product category, or promotion code) and pricing attributes (the specific values from the transaction that satisfied those qualifiers, like the actual customer number or product ID). This design allows a single price adjustment to be associated with multiple qualifying conditions.

Common Use Cases and Queries

A primary use case is diagnosing and reporting on applied pricing adjustments. Analysts can query this table to understand the breakdown of complex promotional discounts or contract-based pricing. For example, to retrieve all qualification details for adjustments on a specific order line, a common SQL pattern would join from the order line to ASO_PRICE_ADJUSTMENTS and then to ASO_PRICE_ADJ_ATTRIBS. Another critical use case is auditing pricing consistency and validating that adjustments were applied according to defined business rules. Sample queries often focus on aggregating adjustments by qualifier type (e.g., list all adjustments triggered by a specific promotion code) to measure promotional effectiveness.

Related Objects

This table has a direct and fundamental relationship with the primary price adjustments table. The documented foreign key relationship is:

  • ASO_PRICE_ADJUSTMENTS: This is the parent table. The foreign key ASO_PRICE_ADJ_ATTRIBS.PRICE_ADJUSTMENT_ID references a record in ASO_PRICE_ADJUSTMENTS. Every qualifier/attribute record must belong to a single price adjustment line. The ASO_PRICE_ADJUSTMENTS table itself is typically linked to quotation or order lines (e.g., in ASO_QUOTE_LINES_ALL), establishing the full hierarchy from the order line down to the pricing qualifiers.

Given its function, this table is also integral to the pricing engine's internal APIs and is likely referenced by various pricing diagnostic reports and customer-facing price explanation documents within the Order Capture module.