Results for “automatic_flag”

8 results




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

Overview

SO_PRICE_ADJUSTMENTS is a transactional table in the OE (Order Entry) schema of Oracle E-Business Suite, holding order-level and order-line-level price adjustment records. Each row represents a single price adjustment — a discount, surcharge, promotion, or modifier — applied against an order header or a specific order line. The table stores both the magnitude of the adjustment (expressed through the PERCENT column) and its relationship to the underlying pricing structures, including the discount definition and the specific discount line from which the adjustment originated. In 12.1.1 and 12.2.2, the table's structure is identical and remains VALID across both releases, with 32 documented columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is link. This reflects the table's role as an associative entity that resolves relationships between order headers, order lines, discount definitions, and discount lines, rather than a pure hub of business keys or a descriptive satellite of a single parent.

Key Information Stored

The primary key is SO_PRICE_ADJUSTMENTS_PK, defined on the surrogate column PRICE_ADJUSTMENT_ID. A unique index, SO_PRICE_ADJUSTMENTS_U1, also exists on PRICE_ADJUSTMENT_ID, making it the sole documented business-key candidate. Though functionally redundant with the primary key here, this pattern confirms the ID is the stable, system-generated identifier for each adjustment record.

The most significant columns are:

Common Use Cases and Queries

The table is typically queried to report on discounts and price adjustments applied to orders, to audit automatic versus manual adjustments, and to reconcile order pricing against discount setup. A representative query joining the header and line context is:

  • SELECT spa.PRICE_ADJUSTMENT_ID, spa.HEADER_ID, spa.LINE_ID, spa.DISCOUNT_ID, spa.PERCENT, spa.AUTOMATIC_FLAG FROM OE.SO_PRICE_ADJUSTMENTS spa WHERE spa.HEADER_ID = :header_id;
  • Join to SO_LINES_ALL on spa.LINE_ID = sl.LINE_ID to report adjustments at line level.
  • Join to SO_DISCOUNTS on spa.DISCOUNT_ID = sd.DISCOUNT_ID to resolve the discount name and context.
  • Filter on AUTOMATIC_FLAG = 'N' to isolate manually entered adjustments for approval review.
  • Use REQUEST_ID and PROGRAM_ID to trace adjustments created by a specific concurrent request.

Related Objects

The FK relationships define the core object graph around this table:

  • SO_HEADERS_ALL — joined via SO_PRICE_ADJUSTMENTS.HEADER_ID; the order header parent.
  • SO_LINES_ALL — joined via SO_PRICE_ADJUSTMENTS.LINE_ID; the order line parent.
  • SO_DISCOUNTS — joined via SO_PRICE_ADJUSTMENTS.DISCOUNT_ID; the discount definition.
  • SO_DISCOUNT_LINES_115 — joined via SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID; the qualifying discount line.

Together these objects form the pricing picture for an order, with SO_PRICE_ADJUSTMENTS acting as the link that records which discount, at what percentage, was applied to which header and line.