Search Results insert_lines

Overview

OE_BULK_LINE_UTIL is a PL/SQL utility package owned by the APPS schema that supports high-volume order line creation and maintenance within the Oracle Order Management module. It forms part of the bulk processing infrastructure that allows Oracle E-Business Suite to import and construct sales order lines programmatically, bypassing the standard Order Management window when large volumes of data must be processed. In the 12.1.1 and 12.2.2 releases, this package is classified as a UTIL library, meaning it provides reusable building blocks called by higher-level bulk processing packages rather than exposing a public interface intended for direct end-user invocation.

The package interoperates closely with OE_BULK_ORDER_PVT and OE_BULK_PROCESS_LINE, which orchestrate the overall bulk order import flow, and with OE_WSH_BULK_GRP for warehouse-related grouping data.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions within this package:

• LOAD_LINES — The primary entry point that populates the internal line structure with order line data, preparing lines for insertion into the Order Management interface and base tables.
• INSERT_LINES — Writes the prepared line records into the OE_LINES_IFACE_ALL interface table and, where applicable, into the base order line tables.
• CREATE_LINE_SCREDITS — Establishes sales credit records associated with the lines being created, populating the OE_SALES_CREDITS interface and base structures.
• APPEND_INCLUDED_ITEMS — Expands configurable or included items into their component lines, using bill of material explosion data so that included items are represented as distinct order lines.

Parameter lists are not published in the metadata and should be confirmed from the package specification at the deployed release level.

Tables Accessed

The package references several core Order Management and inventory tables through APPS synonyms:

• OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL — interface tables that stage order headers and lines prior to validation and import.
• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, and OE_ORDER_LINES_S — the base order and line tables, plus the line sequence/denormalized view used for line retrieval.
• OE_SALES_CREDITS and OE_SALES_CREDITS_S — storage for sales credit assignments linked to the created lines.
• MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV — item validation and descriptive key flexfield values.
• BOM_EXPLOSIONS — used by APPEND_INCLUDED_ITEMS to resolve included/configuration components.
• OE_CONFIG_DETAILS_TMP — temporary configuration detail staging.
• DUAL and PLITBLM — PL/SQL utility table used for character-to-token conversion during bulk processing.

Usage Notes

OE_BULK_LINE_UTIL is an internal utility package and is not intended for direct invocation by end users. It is referenced by OE_BULK_ORDER_PVT, OE_BULK_PROCESS_LINE, and recursively by itself, indicating it is called within the bulk order import processing path rather than through a standard concurrent program or form. Developers performing bulk sales order creation or extending the Order Management import framework should treat this package as a dependency layer that supports higher-level bulk loading routines; the documented procedures should be invoked only through the parent bulk processing packages that manage validation, sequencing, and error handling.