Search Results pricing_attribute41




Overview
Explore in AI Chat

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

Overview

ONT.OE_ORDER_PRICE_ATTRIBS is a transactional table in the Oracle Order Management (ONT) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the pricing attributes, "asked for" promotions, deals, and coupon numbers entered by the user during order capture, and it serves as the physical repository that the pricing engine (Advanced Pricing / QP) reads when qualifying modifiers, price lists, and promotional offers against a specific order or order line. Each row ties a set of pricing attribute values to a specific order header and, where applicable, a specific order line, allowing the pricing engine to evaluate qualifier and price-break logic deterministically at the point of pricing.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is a link. The table does not describe a standalone business entity; rather it associates an order header and an order line with a collection of pricing qualifiers, and its identity is derived from the transactional context it participates in. This classification is a modeling suggestion only, since the physical table is a conventional normalized EBS table rather than a formal Data Vault artifact.

Key Information Stored

The table contains 134 documented columns and is owned by the ONT schema. Its most significant columns are:

Common Use Cases and Queries

Typical uses include debugging why a promotion or deal did not fire on an order, extracting all "asked for" promotion and coupon data for an order, and reporting on qualifier values for pricing analytics. A representative query joining the two foreign keys is:

  • SELECT h.order_number, l.line_number, p.pricing_attribute1, p.pricing_attribute2 FROM oe_order_price_attribs p, oe_order_headers_all h, oe_order_lines_all l WHERE p.header_id = h.header_id AND p.line_id = l.line_id AND p.header_id = :p_header_id;
  • A header-level lookup: SELECT ORDER_PRICE_ATTRIB_ID, HEADER_ID, LINE_ID FROM oe_order_price_attribs WHERE header_id = :p_header_id;
  • A direct surrogate-key fetch: SELECT * FROM oe_order_price_attribs WHERE order_price_attrib_id = :p_id;

Because each order can carry many rows, aggregating by HEADER_ID is standard when summarizing which qualifications applied to a given order. The PRICING_CONTEXT and CONTEXT columns must always be inspected to identify which PRICING_ATTRIBUTEn columns are actually populated.

Related Objects

The most significant objects related to this table are:

  • OE_ORDER_HEADERS_ALL — parent of the HEADER_ID foreign key; holds order-level data.
  • OE_ORDER_LINES_ALL — parent of the LINE_ID foreign key; holds line-level data.
  • OE_PRICE_ATTS_IFACE_ALL — interface table whose ORDER_PRICE_ATTRIB_ID references this table, used during order import and pricing attribute staging.
  • QP_PRICING_ATTRIBUTES and the Advanced Pricing modifier/qualifier tables in the QP schema — consumed at runtime by the pricing engine using the qualifier values stored here.
  • OE_ORDER_PRICE_ATTRIBS_PK and OE_ORDER_PRICE_ATTRIBS_U1 — the primary key constraint and unique index enforcing row identity.

Together these objects connect order capture, order import, and pricing qualification into a single auditable chain within Order Management.