Search Results automatically_applied




Overview
Explore in AI Chat

Overview

APPS.OEBV_PRICE_ADJUSTMENTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite. It is registered under FND Design Data as both OE.OEBV_PRICE_ADJUSTMENTS and ONT.OEBV_PRICE_ADJUSTMENTS, reflecting its shared ownership between the Oracle Order Management (OE) and Oracle Order Management/Shipping Execution (ONT) product families. The view exposes a record of the percent off list price granted by a discount each time that discount is applied to an order, stored as a price adjustment. In practical terms, it provides a denormalized, read-only reporting surface over the price adjustment records generated when order discounts are evaluated and applied against order headers and lines. Because the object is a view rather than a base table, it carries no independent storage and is intended solely for query, reporting, and integration consumption. Its status is documented as VALID in ETRM 12.2.2, and the object is not referenced by any other database object, confirming its role as a terminal reporting endpoint.

Underlying Base Objects

The view is defined over the base object OE_PRICE_ADJUSTMENTS, exposed through an APPS synonym. OE_PRICE_ADJUSTMENTS is the transactional table that persists each price adjustment applied to an order line or header, including discount, surcharge, and list price modifications. The view inherits its column set directly from this table, projecting the adjustment identity, the automatic-application flag, the percentage value, the originating discount context, and the parent order header and line references. No other base table is documented as contributing to the view definition, so a one-to-one correspondence exists between rows in the view and qualifying rows in OE_PRICE_ADJUSTMENTS. Because the view performs no joins in its exposed query text, consumers can expect the same cardinality as the underlying adjustment records, subject to any row-level security or synonym resolution applied by the APPS schema.

Key Columns

  • PRICE_ADJUSTMENT_ID — Primary identifier for the adjustment record; the unique key for each applied discount or price modification.
  • AUTOMATICALLY_APPLIED — VARCHAR2 flag indicating whether the adjustment was applied automatically by the pricing engine (for example, a system-triggered discount) rather than entered manually. This is the column most directly associated with the search term "automatically_applied."
  • PERCENT — The percent off the list price applied by the discount.
  • DISCOUNT_ID — Identifier of the discount or modifier definition that produced the adjustment.
  • DISCOUNT_LINE_ID — Identifier of the specific discount line within the originating discount definition.
  • HEADER_ID — Reference to the order header to which the adjustment belongs.
  • LINE_ID — Reference to the order line to which the adjustment belongs.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard audit columns supporting change tracking and accountability.

Common Use Cases and Queries

Typical uses include auditing which discounts were applied automatically versus manually, quantifying discount percentages across orders, and reconciling adjustments back to order headers and lines. Because the view is read-only and query-only, it is well suited to ad hoc reporting and extract transformations.

  • Retrieving all automatically applied adjustments for a given order: SELECT PRICE_ADJUSTMENT_ID, PERCENT, DISCOUNT_ID FROM APPS.OEBV_PRICE_ADJUSTMENTS WHERE HEADER_ID = :header_id AND AUTOMATICALLY_APPLIED = 'Y';
  • Summarizing automatic versus manual application counts: SELECT AUTOMATICALLY_APPLIED, COUNT(*) FROM APPS.OEBV_PRICE_ADJUSTMENTS GROUP BY AUTOMATICALLY_APPLIED;
  • Joining to order lines to attribute applied percentages: SELECT a.LINE_ID, a.PERCENT FROM APPS.OEBV_PRICE_ADJUSTMENTS a WHERE a.LINE_ID = :line_id;

Consumers should filter on HEADER_ID or LINE_ID to bound result sets, given the transactional volume of the underlying adjustment table.