Search Results price_adjustments

Overview

ONT.OE_PRICE_ADJS_IFACE_ALL is the Sales Order Price Adjustments Interface table in Oracle Order Management. It is a multi-org open interface table that stages price adjustment (discount, surcharge, and modifier) information originating from external feeder systems prior to import into Oracle Order Management through the Order Import concurrent program. The table resides in the APPS_TS_INTERFACE tablespace with PCT Free 10, and its lifecycle status is active and valid in both Oracle EBS 12.1.1 and 12.2.2. Its FND Design Data identifier is ONT.OE_PRICE_ADJS_IFACE_ALL, and its product short name is ONT.

Because the table is an interface (staging) object, rows are transient: they are inserted by the feeder system, processed by Order Import, and ultimately moved into the operational pricing adjustment tables. Oracle documents the object category as BUSINESS_ENTITY ONT_SALES_ORDER, reinforcing its role as a business entity interface rather than a permanent transactional store. The heuristic Data Vault classification mined from the foreign key structure suggests this table behaves as a link, since it primarily associates order source, price list, discount, and pricing phase references through a dense set of foreign key relationships rather than holding descriptive master attributes on its own.

Key Information Stored

The table contains 94 documented columns. The columns below are the most operationally significant:

• PRICE_ADJUSTMENT_ID — Surrogate/numeric identifier for the price adjustment record; serves as the primary handle for the adjustment in downstream processing.
• ORDER_SOURCE_ID — Foreign key to ONT.OE_ORDER_SOURCES; identifies the source system from which the order originated. Indexed via OE_PRICE_ADJS_IFACE_ALL_N2.
• ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, ORIG_SYS_DISCOUNT_REF, CHANGE_SEQUENCE — The composite business key used by Order Import to match interface rows to source-system documents and lines, and to sequence changes. These columns are indexed together in OE_PRICE_ADJS_IFACE_ALL_N2.
• REQUEST_ID — Concurrent request identifier of the Order Import run; indexed via OE_PRICE_ADJS_IFACE_ALL_N1.
• ORG_ID — Organization identifier; the table is multi-org enabled.
• LIST_HEADER_ID, LIST_LINE_ID, DISCOUNT_ID, DISCOUNT_LINE_ID, PRICING_PHASE_ID — Foreign keys to QP_LIST_HEADERS_B, QP_LIST_LINES, SO_DISCOUNTS, SO_DISCOUNT_LINES_115, and QP_PRICING_PHASES respectively, tying the adjustment to its pricing source.
• MODIFIER_NAME, MODIFIER_MECHANISM_TYPE_CODE, OPERAND, ARITHMETIC_OPERATOR, PERCENT, ADJUSTED_AMOUNT — Descriptive and arithmetic attributes defining the adjustment itself.
• INTERFACE_STATUS, STATUS_FLAG, ERROR_FLAG — Process control flags indicating import success or failure.
• Standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and PROGRAM_* columns — Audit and concurrent program context.

The two non-unique indexes (OE_PRICE_ADJS_IFACE_ALL_N1 on REQUEST_ID and OE_PRICE_ADJS_IFACE_ALL_N2 on the source-reference and modifier columns) reflect the dominant access paths used during Order Import processing. No unique index is documented, so the surrogate key is PRICE_ADJUSTMENT_ID while the business-key candidate is the composite ORIG_SYS_* reference set.

Common Use Cases and Queries

Typical usage centers on loading and validating adjustments prior to Order Import, and diagnosing failures afterward.

• Identifying failed adjustments for a specific concurrent request: SELECT * FROM ONT.OE_PRICE_ADJS_IFACE_ALL WHERE REQUEST_ID = :req AND INTERFACE_STATUS = 'ERROR';
• Reconciling adjustments by source document and line: SELECT ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, MODIFIER_NAME, ADJUSTED_AMOUNT FROM ONT.OE_PRICE_ADJS_IFACE_ALL WHERE ORDER_SOURCE_ID = :src;
• Checking adjustments tied to a specific price list and phase: SELECT LIST_HEADER_ID, PRICING_PHASE_ID, OPERAND, PERCENT FROM ONT.OE_PRICE_ADJS_IFACE_ALL WHERE LIST_HEADER_ID = :lh;
• Purge operations after successful import, filtered by REQUEST_ID or INTERFACE_STATUS.
• Reporting on adjustment volumes and values per organization, leveraging ORG_ID.

Related Objects

The foreign keys documented for this table identify the principal related objects, which are essential for joins and for understanding adjustment lineage:

• ONT.OE_ORDER_SOURCES — joined on ORDER_SOURCE_ID.
• QP_LIST_HEADERS_B — joined on LIST_HEADER_ID (price list header).
• QP_LIST_LINES — joined on LIST_LINE_ID (price list line).
• SO_DISCOUNTS — joined on DISCOUNT_ID.
• SO_DISCOUNT_LINES_115 — joined on DISCOUNT_LINE_ID.
• QP_PRICING_PHASES — joined on PRICING_PHASE_ID.

In addition, the operational Order Management pricing tables (such as OE_PRICE_ADJUSTMENTS) receive the imported rows, and the Order Import concurrent program consumes this interface in conjunction with the documented Oracle Manufacturing APIs and Open Interfaces Manual. Together these relationships position OE_PRICE_ADJS_IFACE_ALL as the pricing-adjustment entry point of the Order Import pipeline.