Search Results oe_default_header




Overview
Explore in AI Chat

Overview

The APPS.OE_DEFAULT_HEADER package is an Oracle E-Business Suite Order Management (OM) database object classified under the OTHER API classification, meaning it is neither a formally published open interface nor a standalone public API, but rather a supporting internal PL/SQL construct used to establish default column values for order header records. Its business function is to encapsulate the logic required to derive and populate meaningful default attribute values for an order header before that record is validated and inserted by the Order Management transaction engine. This defaulting mechanism underpins the consistent capture of header-level data — such as customer, site, carrier, and pricing context — that downstream processes rely upon.

The object resides in the APPS schema and holds a status of VALID. The ETRM dependency listing shows OE_DEFAULT_HEADER references OE_ORDER_PUB, which is the principal published Order Management API, and is in turn referenced by OE_ORDER_PVT and by itself. This dependency pattern confirms its role as a subordinate helper invoked within the Order Management order-capture and order-processing flow.

Key Procedures and Functions

The ETRM metadata records a total of one documented procedure or function, named ATTRIBUTES. As the name implies, its purpose is to resolve and return the set of default header attribute values that apply to an order header under the prevailing defaulting rules. Rather than serving a transactional write function, it supplies the attribute defaults consumed by the calling Order Management logic. Because the package is classified under OTHER, the ATTRIBUTES routine is intended for internal invocation by Oracle's own Order Management code rather than for direct calls by customer-written integrations. The published ETRM record does not expose a parameter list, and the routine's contract should be treated as internal and subject to change across releases.

Tables Accessed

The package reads from a defined set of tables through APPS synonyms, spanning several functional areas:

Usage Notes

OE_DEFAULT_HEADER is invoked internally during Order Management order entry and order import processing, most commonly through the OE_ORDER_PUB / OE_ORDER_PVT call stack when a header record is being prepared, defaulted, and validated. The Oracle Order Management entry forms and the Order Import concurrent program (and its associated processing logic) reach this package indirectly rather than by direct call. Because the package is documented under the OTHER classification, it carries no supported public API guarantee: customizations, extensions, and third-party integrations should not call OE_DEFAULT_HEADER directly. Where custom defaulting is required, the supported approach is to configure Oracle's defaulting rules using the standard Order Management setup, or to invoke the supported OE_ORDER_PUB API, allowing Oracle's internal defaulting logic — including this package — to execute as designed. The behavioral differences between EBS 12.1.1 and 12.2.2 for this package are not differentiated in the documented metadata; both releases share the same object structure and dependency profile.