Search Results aso_price_adjustments




Overview
Explore in AI Chat

Overview

The ASO_PRICE_ADJUSTMENTS table is a core data repository within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. Its primary function is to persistently store all price adjustments applied during the quotation and sales order process. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is integral to managing complex pricing strategies, capturing discounts, surcharges, and promotional modifications that are calculated by the Oracle Advanced Pricing engine. It serves as the definitive system of record for these adjustments, linking them to their associated quotes, lines, or shipments, thereby ensuring accurate pricing, auditing, and financial reconciliation.

Key Information Stored

While the provided metadata does not list specific columns, the foreign key relationships and primary key structure define its critical data associations. The central identifier is the PRICE_ADJUSTMENT_ID, which uniquely defines each adjustment record. The table stores foreign keys to link each adjustment to its parent transactional entity: QUOTE_HEADER_ID (ASO_QUOTE_HEADERS_ALL), QUOTE_LINE_ID (ASO_QUOTE_LINES_ALL), and QUOTE_SHIPMENT_ID (ASO_SHIPMENTS). This structure allows adjustments to be applied at the header, line, or shipment level. Typically, such a table would also contain columns for the adjustment amount, adjustment type (e.g., discount, freight), the pricing modifier list or formula used, the applied currency, and timestamps for creation and last update.

Common Use Cases and Queries

A primary use case is generating detailed pricing audit reports for a quote or order. Analysts can query this table to list all adjustments applied, summarizing total discounts or surcharges. Another critical scenario is troubleshooting pricing discrepancies by examining the raw adjustment data stored by the system. Common SQL patterns involve joining to the primary quote and line tables.

  • Find adjustments for a specific quote: SELECT * FROM ASO_PRICE_ADJUSTMENTS WHERE QUOTE_HEADER_ID = <quote_id>;
  • Summarize adjustments by quote line: SELECT QUOTE_LINE_ID, SUM(ADJUSTMENT_AMOUNT) FROM ASO_PRICE_ADJUSTMENTS WHERE QUOTE_HEADER_ID = <quote_id> GROUP BY QUOTE_LINE_ID;
  • Link adjustments to quote header details: SELECT qha.QUOTE_NUMBER, apa.* FROM ASO_PRICE_ADJUSTMENTS apa, ASO_QUOTE_HEADERS_ALL qha WHERE apa.QUOTE_HEADER_ID = qha.QUOTE_HEADER_ID AND qha.QUOTE_NUMBER = '<number>';

Related Objects

The metadata explicitly defines several key dependencies. ASO_PRICE_ADJUSTMENTS is a child table to the primary transactional entities: ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, and ASO_SHIPMENTS. It is, in turn, a parent table to at least two other entities that store supplemental adjustment data: ASO_PRICE_ADJ_ATTRIBS (likely holding descriptive flexfield or attribute data for the adjustment) and ASO_PRICE_ADJ_RELATIONSHIPS (likely managing hierarchical or promotional relationships between different adjustments). This object is central to the pricing data model and is heavily referenced by the Order Capture and Advanced Pricing modules for display, reporting, and processing logic.