Search Results oe_default_pvt




Overview
Explore in AI Chat

Overview

OE_DEFAULT_PVT is a private PL/SQL package in the APPS schema that supplies defaulting logic for Oracle Order Management in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name follows the EBS convention of a _PVT package, indicating that the package is intended for internal use by Oracle's own forms, APIs, and concurrent programs rather than as a public extension point. The package resolves and returns default values for order header and order line attributes—customer locations, receipt methods, tax attributes, credit card details, and accounting rule durations—so that the Order Management forms and Order Capture workflows can populate fields consistently whenever a new order or line is entered.

The dependency metadata shows OE_DEFAULT_PVT referencing only SYS.STANDARD, meaning the package relies on standard PL/SQL constructs and the underlying tables it queries directly. It is referenced by 22 other database objects, including the OE_OE_FORM_HEADER family of form-handler packages and a large set of ONT_D* defaulting rule packages (credit card number, expiration date, holder name, receipt method, sold-to and deliver-to attributes, tax code, tax exemption and accounting rule duration). This pattern confirms that OE_DEFAULT_PVT functions as a low-level utility layer invoked by the Order Management defaulting framework.

Key Procedures and Functions

The documented metadata lists 14 procedures and functions, all of which are getter-style routines that retrieve a defaulted value for a given order context:

Tables Accessed

OE_DEFAULT_PVT reads from several core Order Management and Receivables tables (accessed through APPS synonyms) to derive its default values:

Usage Notes

Because OE_DEFAULT_PVT is a _PVT package, Oracle does not document it as a supported public API, and direct invocation from custom code is not recommended; Oracle may change its signature without notice. In practice it is invoked indirectly whenever an order is created or modified through the Order Management forms (via the OE_OE_FORM_HEADER, OE_OE_FORM_HEADER_PAYMENT, and OE_OE_FORM_LINE_PAYMENT handlers) and through the Order Capture defaulting rule packages (the ONT_D* family), which call these getters to populate credit card, tax, location, and accounting rule attributes. Developers diagnosing defaulting behavior should treat OE_DEFAULT_PVT as the final implementation layer behind the seeded defaulting rules, and should perform any supported extension through the standard Order Management defaulting setup or public APIs rather than by calling this package directly.