Search Results oe_config_price_items_mls

Overview

APPS.OE_CONFIG_PRICE_UTIL is a utility package body in Oracle Order Management (OM) that supports pricing of configured items during the order capture cycle. It acts as the bridge between Oracle Configurator (CZ) and the Order Management pricing engine, resolving the selected configuration options into inventory items, creating order line records for newly selected options, and returning list and selling prices back to the Configurator's pricing structures. The package is classified as a UTIL object under the APPS schema and carries a header revision at 120.0.12010000.3 (January 2009), indicating it is present in both the 12.1.1 and 12.2.2 application code lines. Its scope is deliberately narrow: it does not itself perform pricing calculations, but orchestrates calls to the pricing APIs and persists the results so the Configurator UI and the OM order line tables remain consistent.

Key Procedures and Functions

• OE_CONFIG_PRICE_ITEMS — The primary worker procedure. It accepts the configuration session key (formatted as top_model_line_id#session_id), which the Configurator received when the configuration form was opened, and uses it to locate the top model line and the corresponding rows in CZ_PRICING_STRUCTURES. For each option returned, it parses the item_key — a concatenation of component_code, explosion_type, organization_id, and top_item_id separated by colons — to derive the inventory_item_id. It then creates order line records for new options, invokes the price_lines pricing API for those options, and writes the resulting list and selling prices back into CZ_PRICING_STRUCTURES. For restored configurations, unit_list_price and unit_selling_price are taken directly from the order management tables rather than re-priced. List price is always obtained on a per-unit basis; selling price is quantity-sensitive, so when an existing configuration's option quantity is modified the procedure deliberately avoids reusing stale pricing data from OE_ORDER_LINES and re-prices instead. Debug tracing is emitted through oe_debug_pub.
• OE_CONFIG_PRICE_ITEMS_MLS — A multi-lingual (MLS) companion entry point to OE_CONFIG_PRICE_ITEMS, provided so that configuration pricing can be driven consistently where language-dependent behavior or installation context requires the MLS variant. It shares the same business purpose of returning list and selling prices for selected configuration options.

Tables Accessed

• CZ_PRICING_STRUCTURES — The core Configurator pricing table. Options to be priced are read from here via the config_session_key, and the list and selling prices returned by the pricing API are written back to this table.
• MTL_SYSTEM_ITEMS — Used to resolve inventory_item_id values derived from the component code portion of the item_key.
• OE_ORDER_HEADERS_ALL — Read to establish order context for the configuration being priced.
• OE_ORDER_LINES / OE_ORDER_LINES_ALL — Read for restored configurations to obtain existing unit_list_price and unit_selling_price, and written when new option line records are created.
• PLITBLM — Accessed in support of the underlying pricing API invocation.

Usage Notes

The package is invoked indirectly from the Oracle Configurator form flow during order entry, immediately after options are selected or restored and the configuration session key is available. Because the Configurator supplies the session key and expects prices to be reflected back into CZ_PRICING_STRUCTURES, customizations should not call OE_CONFIG_PRICE_ITEMS in isolation without first ensuring the configuration session context exists. The item_key concatenation order is a hard-coded contract; any change to how Configurator composes that key will break item resolution and produce pricing errors. The package is referenced by zero other packages in the documented metadata, so dependencies run from the Configurator and OM forms inward rather than outward. It is not a substitute for the standard pricing engine and should be treated as an internal orchestration utility when diagnosing configuration pricing defects.