Search Results oe_order_price_attribs




Overview
Explore in AI Chat

Overview

The OE_ORDER_PRICE_ATTRIBS table is a core data object within the Oracle E-Business Suite (EBS) Order Management (ONT) module. It serves as the primary repository for capturing and storing pricing-related contextual information that is manually entered by users or automatically derived during the order entry and pricing processes. Its fundamental role is to persist supplemental pricing attributes, such as promotions, deals, and coupon codes, which are critical for applying the correct pricing logic and discounts to sales orders. This table is integral to the pricing engine's ability to accurately calculate final line and header-level amounts based on specific commercial agreements and marketing incentives.

Key Information Stored

The table's structure is designed to link pricing attributes to specific order lines or the entire order header. The primary key, ORDER_PRICE_ATTRIB_ID, uniquely identifies each attribute record. Two critical foreign key columns establish the relationship to the main order entities: HEADER_ID links to OE_ORDER_HEADERS_ALL for header-level attributes, and LINE_ID links to OE_ORDER_LINES_ALL for line-level attributes. While the provided metadata does not list all columns, the description confirms the table stores the specific values for user-entered or system-captured promotions, deals, and coupon numbers. These attributes act as qualifiers that the pricing engine references against defined price lists and modifiers to determine final pricing.

Common Use Cases and Queries

A primary use case is auditing and reporting on the application of promotional pricing. Analysts may query this table to identify all orders that used a specific coupon code or were part of a particular deal. Another common scenario is troubleshooting pricing discrepancies by examining the raw attribute data stored against an order line. Sample SQL to retrieve this information often involves joining to the main order tables.

  • Finding all lines with a specific promotion: SELECT ooha.order_number, oola.line_number, oopa.* FROM oe_order_price_attribs oopa JOIN oe_order_lines_all oola ON oopa.line_id = oola.line_id JOIN oe_order_headers_all ooha ON oola.header_id = ooha.header_id WHERE oopa.promotion_name = 'YOUR_PROMOTION';
  • Identifying orders with any pricing attribute: SELECT header_id, line_id, COUNT(*) FROM oe_order_price_attribs GROUP BY header_id, line_id;

Related Objects

The OE_ORDER_PRICE_ATTRIBS table has defined foreign key relationships with two principal Order Management transaction tables, as documented in the metadata.

  • OE_ORDER_HEADERS_ALL: Linked via the OE_ORDER_PRICE_ATTRIBS.HEADER_ID column. This relationship stores pricing attributes applicable at the overall sales order level.
  • OE_ORDER_LINES_ALL: Linked via the OE_ORDER_PRICE_ATTRIBS.LINE_ID column. This is the more common relationship, storing pricing attributes specific to an individual order line.

These relationships ensure referential integrity and are essential for any query joining pricing attribute data to the main order flow. The table is also central to the pricing engine's internal processes and may be referenced by various ONT APIs and views responsible for returning price calculations.