Search Results oe_price_adj_assocs




Overview
Explore in AI Chat

Overview

The OE_PRICE_ADJ_ASSOCS table is a core data object within the Oracle E-Business Suite (EBS) Order Management (ONT) module, specifically in versions 12.1.1 and 12.2.2. It functions as the central repository for managing associations related to pricing adjustments on sales orders. Its primary role is to store the critical relationships between an order line and the price adjustments applied to it, as well as the hierarchical relationships between different price adjustments themselves. This table is essential for maintaining the integrity of complex pricing calculations, ensuring that discounts, surcharges, and other modifiers are correctly linked to the appropriate order lines and to each other for proper cascading and precedence logic.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which capture the essential linkages. The primary key, PRICE_ADJ_ASSOC_ID, uniquely identifies each association record. The most significant columns are the foreign keys that establish relationships: LINE_ID associates a price adjustment with a specific sales order line in OE_ORDER_LINES_ALL. PRICE_ADJUSTMENT_ID links to the main price adjustment definition in the OE_PRICE_ADJUSTMENTS table. RLTD_PRICE_ADJ_ID is a pivotal column that creates associations between different price adjustments, enabling scenarios where one adjustment (e.g., a promotional discount) is linked to or modifies another (e.g., a list price modifier). This structure allows the system to model complex, multi-layered pricing rules.

Common Use Cases and Queries

This table is central to pricing analysis and troubleshooting. A common use case is auditing all price adjustments applied to a specific order line to verify pricing accuracy or diagnose calculation errors. For reporting, it enables the aggregation of total discounts or surcharges by order, customer, or product. Development and support teams frequently query this table to understand the adjustment hierarchy for a given line. A typical analytical SQL pattern joins OE_PRICE_ADJ_ASSOCS to OE_ORDER_LINES_ALL and OE_PRICE_ADJUSTMENTS to retrieve adjustment details:

  • SELECT ola.line_number, opa.adjustment_name, opa.adjustment_value, opa.operand FROM oe_price_adj_assocs opaa JOIN oe_order_lines_all ola ON opaa.line_id = ola.line_id JOIN oe_price_adjustments opa ON opaa.price_adjustment_id = opa.price_adjustment_id WHERE ola.header_id = <order_header_id>;

Another critical query involves tracing related adjustments using the RLTD_PRICE_ADJ_ID to understand dependent pricing logic.

Related Objects

OE_PRICE_ADJ_ASSOCS is intrinsically linked to other key tables in the Order Management schema via documented foreign key relationships. Its primary dependencies are:

  • OE_ORDER_LINES_ALL: Linked via the LINE_ID column. This is the foundational relationship connecting a price adjustment to the sales order line it affects.
  • OE_PRICE_ADJUSTMENTS (Primary Link): Linked via the PRICE_ADJUSTMENT_ID column. This references the core definition and attributes of the price adjustment being applied.
  • OE_PRICE_ADJUSTMENTS (Related Adjustment Link): Linked via the RLTD_PRICE_ADJ_ID column. This self-referential relationship to the same parent table allows one price adjustment to be associated with another, forming a hierarchy or dependency chain between modifiers.

These relationships make OE_PRICE_ADJ_ASSOCS a vital junction table for the entire pricing engine within Oracle Order Management.

  • Table: OE_PRICE_ADJ_ASSOCS 12.2.2

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS,  object_name:OE_PRICE_ADJ_ASSOCS,  status:VALID,  product: ONT - Order Management ,  description: This table stores the association between order lines and price adjustments and also between price adjustments ,  implementation_dba_data: ONT.OE_PRICE_ADJ_ASSOCS , 

  • Table: OE_PRICE_ADJ_ASSOCS 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS,  object_name:OE_PRICE_ADJ_ASSOCS,  status:VALID,  product: ONT - Order Management ,  description: This table stores the association between order lines and price adjustments and also between price adjustments ,  implementation_dba_data: ONT.OE_PRICE_ADJ_ASSOCS , 

  • View: OE_PRICE_ADJ_ASSOCS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS_V,  object_name:OE_PRICE_ADJ_ASSOCS_V,  status:VALID,  product: ONT - Order Management ,  description: This is a view on table OE_PRICE_ADJ_ASSOCS. ,  implementation_dba_data: APPS.OE_PRICE_ADJ_ASSOCS_V , 

  • View: OE_PRICE_ADJ_ASSOCS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS_V,  object_name:OE_PRICE_ADJ_ASSOCS_V,  status:VALID,  product: ONT - Order Management ,  description: This is a view on table OE_PRICE_ADJ_ASSOCS. ,  implementation_dba_data: APPS.OE_PRICE_ADJ_ASSOCS_V , 

  • Table: OE_PRICE_ADJUSTMENTS 12.2.2

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PRICE_ADJUSTMENTS,  object_name:OE_PRICE_ADJUSTMENTS,  status:VALID,  product: ONT - Order Management ,  description: This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the ,  implementation_dba_data: ONT.OE_PRICE_ADJUSTMENTS , 

  • Table: OE_PRICE_ADJUSTMENTS 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PRICE_ADJUSTMENTS,  object_name:OE_PRICE_ADJUSTMENTS,  status:VALID,  product: ONT - Order Management ,  description: This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the ,  implementation_dba_data: ONT.OE_PRICE_ADJUSTMENTS , 

  • View: OE_ACCRUALS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_ACCRUALS_V,  object_name:OE_ACCRUALS_V,  status:VALID,  product: ONT - Order Management ,  description: This view shows accrued price adjustments in Order Management System. ,  implementation_dba_data: APPS.OE_ACCRUALS_V , 

  • Table: OE_ORDER_LINES_ALL 12.2.2

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_ORDER_LINES_ALL,  object_name:OE_ORDER_LINES_ALL,  status:VALID,  product: ONT - Order Management ,  description: OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. ,  implementation_dba_data: ONT.OE_ORDER_LINES_ALL , 

  • View: OE_ACCRUALS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_ACCRUALS_V,  object_name:OE_ACCRUALS_V,  status:VALID,  product: ONT - Order Management ,  description: This view shows accrued price adjustments in Order Management System. ,  implementation_dba_data: APPS.OE_ACCRUALS_V , 

  • Table: OE_ORDER_LINES_ALL 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_ORDER_LINES_ALL,  object_name:OE_ORDER_LINES_ALL,  status:VALID,  product: ONT - Order Management ,  description: OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. ,  implementation_dba_data: ONT.OE_ORDER_LINES_ALL ,