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:
- PRICE_ADJUSTMENT_ID — surrogate primary key uniquely identifying each adjustment row.
- HEADER_ID — foreign key to SO_HEADERS_ALL, linking the adjustment to the order header.
- LINE_ID — foreign key to SO_LINES_ALL, linking the adjustment to a specific order line.
- DISCOUNT_ID — foreign key to SO_DISCOUNTS, identifying the discount definition applied.
- DISCOUNT_LINE_ID — foreign key to SO_DISCOUNT_LINES_115, pinpointing the qualifying discount line.
- AUTOMATIC_FLAG — indicates whether the adjustment was applied automatically by the pricing engine or manually by a user.
- PERCENT — the percentage value of the adjustment.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.
- PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrent program and request attribution for the process that created or updated the row.
- CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive flexfield (DFF) columns for customer-defined extension data.
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_IDto report adjustments at line level. - Join to SO_DISCOUNTS on
spa.DISCOUNT_ID = sd.DISCOUNT_IDto resolve the discount name and context. - Filter on
AUTOMATIC_FLAG = 'N'to isolate manually entered adjustments for approval review. - Use
REQUEST_IDandPROGRAM_IDto 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.
-
Order and order line price adjustments
-
View: SO_PRICE_ADJUSTMENTS_V 12.1.1
APPS.SO_PRICE_ADJUSTMENTS_V·↳ FND_GLOBAL·↳ SO_DISCOUNTS·↳ SO_LOOKUPS·Explore OE module →
-
View: SO_PRICE_ADJUSTMENTS_V 12.2.2
APPS.SO_PRICE_ADJUSTMENTS_V·↳ FND_GLOBAL·↳ SO_DISCOUNTS·↳ SO_LOOKUPS·Explore OE module →
-
Imported price adjustments
-
Order and order line price adjustments
-
Imported price adjustments
-
View: OEBV_PRICE_ADJUSTMENTS 12.1.1
- Retrofitted
APPS.OEBV_PRICE_ADJUSTMENTS·↳ OE_PRICE_ADJUSTMENTS·Explore OE module →
-
View: OEBV_PRICE_ADJUSTMENTS 12.2.2
- Retrofitted
APPS.OEBV_PRICE_ADJUSTMENTS·↳ OE_PRICE_ADJUSTMENTS·Explore OE module →