Search Results oe_config_validation_pvt




Overview
Explore in AI Chat

Overview

OE_CONFIG_VALIDATION_PVT is a private PL/SQL package in the APPS schema that supports Oracle Order Management's configuration validation logic within Oracle E-Business Suite 12.1.1 and 12.2.2. The "PVT" suffix designates the package as a private API layer: it is not intended for direct invocation by external or customer-written code, but rather acts as an internal engine consumed by other Order Management packages. Its principal business role is to determine whether an order line that references a configured (or assemble-to-order) item has been assembled consistently with the underlying bill of materials — that is, to verify that the option classes and options selected on an order match the model structure defined in Oracle Bills of Material. This validation is a critical control in the order-entry cycle, because improperly configured lines would otherwise flow into fulfillment with invalid or incomplete configurations.

Key Procedures and Functions

The ETRM metadata documents one callable program unit within this package: BOM_BASED_CONFIG_VALIDATION. As the name implies, this routine performs configuration validation by comparing the order line's configuration against the bill of materials definition. It reads the exploded model structure and evaluates whether the selected items conform to the allowed model/option relationships. Parameter lists are not enumerated in the documented metadata and are therefore not reproduced here. In practice, this procedure is the working core of the package, and callers pass the order line context so that the routine can resolve the relevant BOM structure and return a validation result to the calling process. No other documented procedures or functions are recorded in the ETRM 12.2.2 metadata, indicating that the package's public surface is deliberately narrow.

Tables Accessed

The documented dependency list shows the following tables accessed through APPS synonyms:

  • BOM_EXPLOSIONS — the bill of materials explosion view, used to retrieve the model structure and the set of valid options and option classes associated with the configured item.
  • OE_ORDER_LINES and OE_ORDER_LINES_ALL — the Order Management order line tables, read to obtain the line attributes (inventory item, configuration details, and related columns) that identify the configuration being validated.
  • PLITBLM — a PL/SQL index-by table type; although listed among the dependencies, it represents a declarative table type used within the package for in-memory collections rather than a physical database table. It supports the interim storage of BOM explosion rows and order line records during processing.

Because the package is a validation utility, its access pattern is predominantly read-oriented; it inspects existing order line and BOM data rather than inserting or updating transactional records directly.

Usage Notes

OE_CONFIG_VALIDATION_PVT is an internal package and should not be called directly from custom code. It is invoked at runtime by other Order Management packages — the metadata confirms it is referenced by OE_PROCESS_OPTIONS_PVT — during order line processing, configuration checking, and related validation flows. In a standard EBS deployment, this logic is triggered when a user enters or modifies a configured item on the Order Organizer or Sales Orders form, and during processing routines that verify order lines before booking. Because the package type is classified as PVT, Oracle reserves the right to change its signature without notice; developers requiring configuration validation in extensions should instead use supported public APIs, such as the Order Management public validation APIs, or invoke the same checks through the standard form and concurrent program interfaces. The package is marked VALID in the ETRM data, indicating it compiled successfully and is active in both 12.1.1 and 12.2.2 environments.