Search Results oe_default_header_adj




Overview
Explore in AI Chat

Overview

OE_DEFAULT_HEADER_ADJ is an Oracle Application Object Library (APPS) PL/SQL package that supports the Order Management (OM) module of Oracle E-Business Suite. Its name reflects its core business function: defaulting header-level price adjustment context on sales orders and order lines. Within the Oracle Order Management pricing and adjustment framework, header adjustments (such as freight, order-level discounts, surcharges, or promotional lump-sum charges) must be associated with a value or record that identifies the source and applicability of the adjustment. The package provides the programmatic logic that the Order Management order-entry stack uses to derive or populate the default header adjustment reference when an order is created, copied, or repriced.

The package is classified as OTHER in the ETRM metadata and is documented as VALID under the APPS schema in both EBS 12.1.1 and 12.2.2. It sits within the pricing sublayer of Order Management rather than the core order-capture layer, which is evidenced by its dependency on OE_ORDER_PUB and its use of the OE_PRICE_ADJUSTMENTS_S table.

Key Procedures and Functions

The ETRM documentation records a single documented procedure or function for this package:

  • ATTRIBUTES — The sole documented program unit. In the context of Oracle's adjustment-defaulting utilities, an ATTRIBUTES routine is used to resolve and return the attribute or context values that govern how a header-level price adjustment is defaulted for an order. It centralizes the attribute lookup logic so that calling programs do not need to re-implement the derivation rules.

The documented metadata does not expose parameter lists for this unit, and the specification and body are listed without further detail. The package exposes a single public unit in the reference documentation, with the remainder of its logic contained in the package body.

Tables Accessed

The package references two tables (or views) through APPS synonyms:

  • OE_PRICE_ADJUSTMENTS_S — The core Order Management price adjustments table. This is the primary data source for the package: it stores the adjustment definitions, including header-level adjustments, and the ATTRIBUTES unit reads it to determine applicable adjustment records and their associated attributes for the current order context.
  • DUAL — Used for scalar evaluation, typically to compute or return a single derived value within the attribute resolution logic.

The package does not appear to write to any documented application table directly. It operates in a read/derive capacity, and its dependency on APPS.OE_ORDER_PUB indicates it also calls the standard Order Management public API rather than performing direct DML on order tables itself.

Usage Notes

OE_DEFAULT_HEADER_ADJ is an internal helper rather than a published, customer-facing API. It is referenced by OE_ORDER_ADJ_PVT, the Order Management adjustment private package that implements adjustment handling for the order-entry flow, and by itself (internal recursion or overloaded calls). Because OE_ORDER_ADJ_PVT is invoked from the Order Management forms, order import, and repricing paths, OE_DEFAULT_HEADER_ADJ is typically executed indirectly whenever header-level adjustments are defaulted during order entry, order copy, or pricing recalculation.

Customizations should not call this package directly. Oracle does not document it as an extension point, and its signature and behavior may change between releases. Custom code that needs to default or manipulate header adjustments should use the supported public APIs in OE_ORDER_PUB or the relevant adjustment public packages, ensuring upgrade-safe behavior across 12.1.1 and 12.2.2. The dependency on STANDARD in SYS confirms it relies on Oracle's standard library routines and is intended for internal, schema-owned execution only.