Search Results pre_process_configurator

Overview

The APPS.OE_BULK_CONFIG_UTIL package is a utility PL/SQL module within the Oracle E-Business Suite Order Management (OE) schema. Its principal business function is to support the bulk processing of configured items within the order import and order entry flow. Configured items — kits, models, and pick-to-order configurations — require special handling because their optional and included components, and the associated configuration messages and validation results, must be resolved and staged before they can be committed as order lines.

The package carries a UTIL classification in the ETRM metadata, indicating it is not a public, customer-facing API but rather an internal helper invoked by higher-level bulk order packages. Within Oracle EBS 12.1.1 and 12.2.2, it sits between the bulk order processing logic and the underlying configuration, bill-of-materials, and interface table structures, performing pre-processing and housekeeping tasks that prepare configuration data for the main import routines.

Key Procedures and Functions

The ETRM documentation identifies five documented program units within the package.

• PRE_PROCESS — The main entry point that drives general pre-processing of bulk configuration data prior to order line import.
• PRE_PROCESS_CONFIGURATOR — Handles pre-processing specific to Oracle Configurator-driven models, preparing configuration details and messages for downstream consumption.
• PRE_PROCESS_BOM — Performs pre-processing of bill-of-materials explosion data, reading from BOM_EXPLOSIONS to resolve included components for configured items depending on the applicable BOM.
• DELETE_CONFIGURATIONS — Removes staged configuration records, typically after processing is complete or when clearing invalid or abandoned bulk configuration data from temporary structures.
• PRINT_LINE_REC — A diagnostic/logging utility that prints order line record information, used for debugging bulk import processing and tracing line-level results.

The metadata does not document explicit parameter lists; callers should reference the package specification in the target environment for exact signatures.

Tables Accessed

The package accesses the following tables via APPS synonyms in ETRM 12.2.2 documentation:

• BOM_EXPLOSIONS — Used to explode and resolve bill-of-materials components for configured assemblies.
• CZ_CONFIG_MESSAGES — Stores Configurator validation and runtime messages associated with configuration sessions.
• OE_CONFIG_DETAILS_TMP — A temporary staging table holding configuration details pending processing.
• OE_ACTIONS_INTERFACE, OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL — The Order Management interface tables into which staged header, line, and action records are prepared for import.
• OE_ORDER_LINES_S — The base order lines table, referenced for line data access.
• PLITBLM and UTL_HTTP — Internal PL/SQL table and HTTP utility references, consistent with diagnostic output and potentially external messaging support.
• V$TIMER — Utilized for timing and performance measurement during bulk processing.

Usage Notes

OE_BULK_CONFIG_UTIL is an internal utility package. It is referenced by only one other package — OE_BULK_ORDER_PVT — and it in turn depends on OE_BULK_ORDER_PVT and OE_WSH_BULK_GRP. This mutual dependency reflects its role as a subordinate helper within the bulk order processing stack rather than a standalone interface.

In practice, the package is invoked indirectly whenever bulk order import processes lines that involve configured items. It is normally not called directly from Oracle Forms or concurrent programs; instead, OE_BULK_ORDER_PVT drives it during the pre-processing and staging of configuration data into the OE interface tables. Operators indirectly trigger this logic by running bulk order import or order line import programs for configured orders. Custom code should not depend on these procedures, as they are not documented as a supported public API and their signatures may vary between 12.1.1 and 12.2.2 maintenance levels.