Results for “so_price_adjustments_interface”

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

Overview

The SO_PRICE_ADJUSTMENTS_INTERFACE table is an Order Entry (OE) interface table in the Oracle E-Business Suite, owned by the OE schema. It serves as a staging and import structure for price adjustments—most notably discounts—applied to sales orders received from external source systems. Records are written into this table by external applications, middleware, or conversion routines, then consumed by Oracle's order import concurrent programs, which validate and transfer the data into the permanent pricing and discount tables that ultimately drive order pricing.

Within Oracle's standard pricing model, a price adjustment represents a modifier such as a discount, surcharge, or promotion. This interface table captures the imported representation of such adjustments before they are validated against the order headers staged in the header interface and linked to the appropriate discount definitions. As an interface table, it is transient by nature: rows generally do not persist after a successful import and are typically purged on a scheduled basis.

Based on the foreign key structure, a Data Vault classification of link is the recommended modeling heuristic. The table associates an imported order header reference with a discount definition and an optional discount line, rather than acting as a standalone hub of business entities or a pure descriptive satellite.

Key Information Stored

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

• ORIGINAL_SYSTEM_REFERENCE — the external order identifier that ties the adjustment to the staged sales order header; it carries a foreign key to SO_HEADERS_INTERFACE_ALL. Together with ORIGINAL_SYSTEM_LINE_REFERENCE, it forms the principal business-key candidate for reconciling an adjustment to its order line.
• DISCOUNT_ID and DISCOUNT_NAME — the discount definition being applied; DISCOUNT_ID references SO_DISCOUNTS.
• DISCOUNT_LINE_ID — references SO_DISCOUNT_LINES_115, identifying the specific discount line when applicable.
• PERCENT — the percentage value of the adjustment.
• ORDER_SOURCE_ID — identifies the order source used to determine import behavior and validation rules.
• PRICING_CONTEXT and PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTE15 — the descriptive flexfield (DFF) context and segment values that qualify the pricing adjustment.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — a second descriptive flexfield for additional, user-defined adjustment detail.
• AUTOMATIC_FLAG — indicates whether the adjustment was applied automatically by the pricing engine.
• INTERFACE_STATUS, ERROR_FLAG, and OPERATION_CODE — control columns indicating import processing state, validation errors, and the intended operation (for example, insert versus update).
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — standard concurrency and audit tracking.

No explicit surrogate primary key column is documented in the available metadata; the table functions primarily as a staging area keyed by the interface reference columns.

Common Use Cases and Queries

Typical scenarios include loading discounts alongside orders from legacy systems or external e-commerce platforms, troubleshooting failed order imports, and reconciling imported adjustments against the final priced order.

Identifying unresolved import errors:

SELECT original_system_reference, original_system_line_reference,
       discount_name, interface_status, error_flag
FROM   oe.so_price_adjustments_interface
WHERE  error_flag = 'Y' OR interface_status = 'ERROR';

Correlating adjustments to their staged headers:

SELECT p.discount_name, p.percent, h.original_system_reference
FROM   oe.so_price_adjustments_interface p,
       oe.so_headers_interface_all    h
WHERE  p.original_system_reference = h.original_system_reference;

Reporting commonly aggregates the PERCENT and flexfield attributes by ORDER_SOURCE_ID to audit imported pricing behavior.

Related Objects

• SO_HEADERS_INTERFACE_ALL — joined on ORIGINAL_SYSTEM_REFERENCE; holds the staged order header for each imported adjustment.
• SO_DISCOUNTS — joined on DISCOUNT_ID; the discount definition applied by the adjustment.
• SO_DISCOUNT_LINES_115 — joined on DISCOUNT_LINE_ID; the specific discount line.
• OE_ORDER_PUB — the Order Management public API that accepts imported order and pricing data.
• QP_PRICE_ADJUSTMENTS and related pricing entities — the operational pricing tables that receive validated adjustments.
• Order Import concurrent programs — the processors that read, validate, and populate this interface table's contents into permanent structures.