Search Results oe_config_util




Overview
Explore in AI Chat

Overview

OE_PROCESS_OPTIONS_PVT is a private (PVT) PL/SQL package in the APPS schema that supports process-options handling within the Oracle Order Management configuration and pricing engine. In EBS 12.1.1 and 12.2.2, its primary business role is to evaluate and resolve the processing options attached to configurable items and model/bill-of-material order lines, then translate those options into the order-line attributes that Order Management requires for correct configuration, cascading, and pricing. The package is not a public API; it is an internal collaborator invoked by the configuration utilities, principally OE_CONFIG_UTIL and OE_BULK_CONFIG_UTIL, and it relies on the shared API error-handling infrastructure provided by FND_API and the public order interface OE_ORDER_PUB. Because it is classified PVT, customers are expected to access this behavior indirectly through the configuration utilities rather than call the package directly.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

  • PROCESS_CONFIG_OPTIONS — the main coordination routine that drives processing of configuration options for a given order or configuration context.
  • USE_CONFIGURATOR — determines whether the configurator path applies to the configuration being processed, and steers behavior accordingly.
  • GET_OPTIONS_FROM_DB — retrieves the stored configuration/process options from the database for further evaluation.
  • FIND_MATCHING_COMP_INDEX — locates the matching component index within the configuration, used to align options to their owning component.
  • PREPARE_CASCADE_TABLES — prepares the cascade structures used when option selections propagate to dependent components or lines.
  • HANDLE_RET_STATUS — interprets return status values and raises or records errors consistently with the Order Management API conventions.
  • PRINT_TIME — a diagnostic utility for timing/performance tracing (debug output).

Tables Accessed

Access is performed through APPS synonyms and includes both read and write activity:

  • BOM_EXPLOSIONS — read to resolve the model/components structure underlying a configured item.
  • MTL_SYSTEM_ITEMS_KFV — used to resolve item attributes and descriptions for configured items and components.
  • OE_ORDER_LINES / OE_ORDER_LINES_S — the base and sequence views of order lines, where resolved option values and cascaded attributes are applied, and from which the current line context is read.
  • DUAL — for single-row evaluations and expression checks.
  • PLITBLM — PL/SQL internal table support used for array/bulk processing of option sets.

Usage Notes

OE_PROCESS_OPTIONS_PVT is invoked implicitly by OE_CONFIG_UTIL and OE_BULK_CONFIG_UTIL during configuration processing, including concurrent bulk-configuration runs, and may be called recursively from within its own package body for internal sub-processing. It is not typically invoked from a form trigger or a user-named concurrent program directly. Custom code requiring equivalent behavior should call the supported public entry points (OE_ORDER_PUB, OE_CONFIG_UTIL) rather than this private package, since the private API is subject to change without notice across releases and patches. When troubleshooting configuration, price, or cascading errors, the PRINT_TIME routine and the status handling in HANDLE_RET_STATUS are the usual first points of diagnostic reference.