Search Results oe_config_price_items

Overview

OE_CONFIG_PRICE_UTIL is a utility package in the Oracle E-Business Suite Order Management (OM) module, owned by the APPS schema and classified by Oracle's ETRM repository as a UTIL-type API. Its business purpose is to compute the price of configured items — that is, items whose characteristics are determined at order entry time through a configuration session rather than by a static item definition. When a user configures an assemble-to-order (ATO), pick-to-order (PTO), or hybrid model on an order line, the resulting configuration must be priced based on the selected options, option classes, and any associated pricing structures. This package encapsulates that pricing logic so it can be reused by the configuration engine and related order capture flows. The header comment indicates the package body source file is OEXUCFPS.pls, last shipped under version 120.0.12010000.1 (July 2008), consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The repository documents two procedures exposed by the package. The second, OE_CONFIG_PRICE_ITEMS_MLS, is the multi-lingual (MLS) variant used where translated item descriptions or language-dependent pricing attributes must be resolved.

• OE_CONFIG_PRICE_ITEMS — The primary pricing routine. Based on the documented signature, it accepts a configuration session key (p_config_session_key) that identifies the in-progress or completed configuration, and a price type indicator (p_price_type) whose values are described as "list" and "selling." It returns the computed total price through an OUT parameter (x_total_price). In operation it walks the configuration's option structure, determines the price of each selected component, and aggregates the result according to whether list or selling price is requested.
• OE_CONFIG_PRICE_ITEMS_MLS — The multi-lingual counterpart to the above. It performs the same configuration pricing role while accommodating language-specific item data, allowing the call to be made in environments where multiple installed languages affect item descriptions or pricing attributes.

Tables Accessed

The package reads and writes against the following objects through APPS synonyms:

• CZ_PRICING_STRUCTURES — Stores the pricing structure associated with configurable models and option classes; supplies the price list structure used to resolve component prices.
• MTL_SYSTEM_ITEMS — The item master, used to validate the configurable items and retrieve item-level attributes relevant to pricing.
• OE_ORDER_HEADERS_ALL — Provides order header context, including the price list, currency, and pricing attributes that govern the configuration's pricing.
• OE_ORDER_LINES / OE_ORDER_LINES_ALL — The order line tables where the configuration and its priced components are associated, and where computed prices may be reflected.
• PLITBLM — A PL/SQL index-by table used internally to stage and manipulate line/item collections during the pricing computation.

Usage Notes

OE_CONFIG_PRICE_UTIL is not a public integration API and carries no documented external callers (the repository reports zero packages referencing it). It is best understood as an internal utility invoked from within the configuration and order-pricing flow — for example, when the configuration form or the pricing engine needs to total a configured item at order entry. Customizations should not call it directly unless the calling context already maintains a valid configuration session key and the required order/line state; the safest approach for extensions is to leverage the supported Order Management public APIs, which internally reach this utility. Because it is a utility-class object, Oracle treats its interface as non-guaranteed across releases, so any direct dependency should be revalidated when upgrading between 12.1.1 and 12.2.2. The NOCOPY hint on the OUT parameter reflects a performance-conscious design consistent with high-volume order entry.