Search Results so_price_adjustments




Overview
Explore in AI Chat

Overview

The SO_PRICE_ADJUSTMENTS table is a core transactional data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically in releases 12.1.1 and 12.2.2. It serves as the central repository for recording all price modifications applied to sales orders and their constituent lines. This table is fundamental to the pricing engine, capturing the results of complex pricing rules, manual overrides, and promotional discounts. Its existence ensures a complete audit trail of how a final line or order total was derived from its base price, which is critical for financial reporting, customer inquiries, and order fulfillment processes.

Key Information Stored

The table's primary function is to link an adjustment to a specific order header or line and to the discount rule that generated it. The critical columns, as indicated by its primary and foreign key structure, include PRICE_ADJUSTMENT_ID (the unique identifier), HEADER_ID (linking to SO_HEADERS_ALL for order-level adjustments), and LINE_ID (linking to SO_LINES_ALL for line-level adjustments). Crucially, it stores DISCOUNT_ID and DISCOUNT_LINE_ID, which reference the SO_DISCOUNTS and SO_DISCOUNT_LINES_115 tables, respectively. These foreign keys connect the adjustment amount to the specific pricing rule, modifier list, or manual discount that caused it. While the provided metadata does not list all columns, typical data would include the adjustment amount, its type (e.g., discount, surcharge), the adjusted quantity, and the applied price list.

Common Use Cases and Queries

This table is essential for diagnosing pricing outcomes and generating detailed price audit reports. A common scenario involves analyzing all adjustments applied to a specific sales order to verify pricing accuracy or explain a total to a customer. Another key use case is reporting on the performance of promotional discounts by summarizing the total discount value granted by a specific DISCOUNT_ID over a period. A typical analytical query would join SO_PRICE_ADJUSTMENTS to SO_HEADERS_ALL and SO_LINES_ALL to retrieve order/line details, and to SO_DISCOUNTS to obtain the discount name and reason code.

SELECT oha.order_number,
       ola.line_number,
       spa.adjusted_amount,
       sd.name discount_name
FROM oe.so_price_adjustments spa,
     oe.so_headers_all oha,
     oe.so_lines_all ola,
     oe.so_discounts sd
WHERE spa.header_id = oha.header_id
AND spa.line_id = ola.line_id(+)
AND spa.discount_id = sd.discount_id
AND oha.order_number = '12345';

Related Objects

The SO_PRICE_ADJUSTMENTS table is a central node in the Order Entry schema, with documented foreign key relationships to several key transactional tables. These relationships are fundamental for data integrity and query joins:

  • SO_HEADERS_ALL: Links via HEADER_ID. This relationship stores order-level price adjustments.
  • SO_LINES_ALL: Links via LINE_ID. This relationship stores line-level price adjustments.
  • SO_DISCOUNTS: Links via DISCOUNT_ID. This connects the adjustment to the master discount definition.
  • SO_DISCOUNT_LINES_115: Links via DISCOUNT_LINE_ID. This finer-grained link associates the adjustment with a specific line from a modifier list within the pricing engine.

The primary key constraint SO_PRICE_ADJUSTMENTS_PK on PRICE_ADJUSTMENT_ID ensures each adjustment record is uniquely identifiable.