Search Results oe_default_contract




Overview
Explore in AI Chat

Overview

OE_DEFAULT_CONTRACT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It supports the Order Management module by providing the logic required to establish and default contract attributes associated with pricing contracts. Within Oracle Order Management, a pricing contract records negotiated pricing arrangements with a customer for specific items or item categories over a defined period. When an order or quote is entered, the application must determine which pricing contract applies and default the relevant contract reference onto the transaction line so that agreed pricing is honored.

The package is classified as OTHER in the ETRM API registry, indicating that it is an internal utility package rather than a public, documented application programming interface. Its dependency list confirms its role in the pricing flow: it references OE_PRICING_CONT_PUB, the public pricing contract API, and FND_API, the Oracle Application Object Library error-handling and API framework package. This dependency structure demonstrates that OE_DEFAULT_CONTRACT acts as a supporting layer that works in conjunction with the published pricing contract API rather than replacing it.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package: ATTRIBUTES. The ATTRIBUTES program is concerned with the resolution and defaulting of contract-related attributes for an order or pricing context. In Oracle Order Management's defaulting framework, an attributes-style routine evaluates the input context and returns the applicable contract reference and its associated qualifiers, which are then applied to the transaction during order entry. Because the package is intentionally internal, ATTRIBUTES is invoked programmatically by the pricing defaulting flow rather than being called directly by end users or external integrations. No parameter list is asserted here, as the metadata does not expose one; consumers should treat the signature as internal and subject to change across releases.

Tables Accessed

The package accesses two tables through APPS synonyms:

  • OE_PRICING_CONTRACTS_S — the base table holding pricing contract headers. The package reads this table to identify the active contract or contracts that satisfy the defaulting criteria for the current transaction context.
  • DUAL — the standard Oracle single-row utility table, typically used for lightweight evaluations, constant assignments, or existence checks within the PL/SQL logic.

Together, these accesses confirm the package's narrow, read-oriented purpose: selecting the appropriate pricing contract record and returning its identifier and attributes to the calling defaulting logic. No transactional or write activity against other Order Management tables is documented.

Usage Notes

OE_DEFAULT_CONTRACT is invoked indirectly during Order Management transaction entry, when the pricing and defaulting engine must attach a pricing contract to an order line or header. Oracle Forms-based order entry screens and the relevant public APIs route through the defaulting framework, which in turn calls this package. Because the package is not part of the published API surface, customizations should not call it directly; instead, integrators should use OE_PRICING_CONT_PUB, which this package itself references. The ETRM metadata records zero packages referencing OE_DEFAULT_CONTRACT, reinforcing its position as an internal dependency of the standard defaulting mechanism rather than an integration point. Customers upgrading between 12.1.1 and 12.2.2 should validate any customizations that intercept the defaulting flow, since internal packages such as this one may change without notice.