Search Results order_import_conc_pgm

Overview

OE_BULK_ORDER_IMPORT_PVT is a private PL/SQL package in the APPS schema that forms the core import engine for Oracle E-Business Suite Order Management's Bulk Order Import functionality. Its role is to move sales order data from the open interface tables (OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, and the associated price, adjustment, and action interface tables) into the base Order Management tables (OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL). The package encapsulates the procedural logic that reads staged interface records and transforms them into valid order headers, lines, and attached entities.

The "PVT" suffix denotes an API classification of "Private." This indicates that the package is an internal implementation component rather than a public, supported API. It is not intended to be called directly by external applications or integrations. Instead, it is consumed by the higher-level bulk import utility packages that orchestrate the end-to-end import process.

Key Procedures and Functions

The documented ETRM metadata for release 12.2.2 lists a single procedure or function exposed by this package:

• ORDER_IMPORT_CONC_PGM — The concurrent program entry point for the bulk order import process. This routine drives the import of staged order data from the interface tables into the Order Management base tables. It is the procedure invoked when the Bulk Order Import concurrent program is submitted, and it coordinates the reading of headers, lines, price adjustments, credits, and actions from the interface and their insertion into the operational order tables.

No parameter lists are documented in the available metadata; parameter details are therefore not reproduced here. The single documented routine confirms that this package is tightly bound to the concurrent program execution path rather than to interactive form processing.

Tables Accessed

The package reads and writes a substantial set of Order Management interface and base tables. The interface tables supply the staged inbound data:

• OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL — staged order header and line records awaiting import.
• OE_PRICE_ADJS_IFACE_ALL and OE_PRICE_ATTS_IFACE_ALL — staged price adjustment and price attribute data attached to order lines.
• OE_CREDITS_IFACE_ALL — staged credit information associated with orders.
• OE_ACTIONS_IFACE_ALL — staged action records for the imported orders.

The base tables receive the imported results:

• OE_ORDER_HEADERS_S and OE_ORDER_LINES_S — sequences used to generate primary keys for the new order headers and lines.
• OE_BATCH_ID_S — sequence for generating batch identifiers.
• OE_ORDER_SOURCES — order source definitions used to validate and classify imported orders.
• OE_PROCESSING_MSGS — the message repository where import errors, warnings, and informational messages are recorded.

Legacy interface tables such as OE_HEADERS_INTERFACE, OE_LINES_INTERFACE, OE_ACTIONS_INTERFACE, and OE_PRICE_ADJS_INTERFACE are also referenced, reflecting backward compatibility with the older interface schema.

Usage Notes

OE_BULK_ORDER_IMPORT_PVT is invoked indirectly through the Bulk Order Import concurrent program. Users stage data into the interface tables (through integrations, data loaders, or the Order Import Open Interface), then submit the concurrent program; the program calls ORDER_IMPORT_CONC_PGM to perform the actual import.

The package is referenced by four other packages — OE_BULK_HEADER_UTIL, OE_BULK_LINE_UTIL, OE_BULK_VALIDATE, and OE_BULK_WF_UTIL — which together form the Bulk Order Import utility layer. Because the package is private, custom code should not call it directly; integrators should use the supported public import APIs or the documented concurrent program. Direct invocation risks bypassing validation logic and is not supported by Oracle Support.