Search Results import_order

Overview

OE_ORDER_IMPORT_PVT is an internal, private PL/SQL package in the APPS schema that performs the core record-level processing for Oracle Order Management's Order Import engine. Order Import is the mechanism by which externally staged orders are validated, defaulted, priced, and converted into live order headers, lines, and related entities in Oracle E-Business Suite. This package is the operational heart of that flow: it consumes rows already written to the open interface tables and applies the business logic required to transform interface data into actual order transactions.

In Oracle EBS 12.1.1 and 12.2.2, the Order Import architecture is layered. Public entry points such as OE_ORDER_IMPORT_MAIN_PVT and the Order Import concurrent program orchestrate the process, while private packages such as OE_ORDER_IMPORT_PVT carry out the detailed validation and persistence work. The "PVT" suffix marks the package as a private API layer, meaning it is not intended as a supported public interface for external callers but is instead invoked internally by the Order Import stack.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

• IMPORT_ORDER — The primary routine that imports an order from the interface tables into the application tables. It applies the validation, defaulting, and processing logic necessary to move staged records forward through the Order Import pipeline. Only its name and purpose are documented; no public parameter list is published, consistent with its private API classification.

Additional internal procedures and functions may exist within the package body, but they are not part of the documented surface and should not be treated as callable APIs.

Tables Accessed

The package operates across the full set of Order Import interface tables and their corresponding application tables. Documented interface tables include OE_HEADERS_IFACE_ALL and OE_HEADERS_INTERFACE (order headers), OE_LINES_IFACE_ALL and OE_LINES_INTERFACE (order lines), OE_ACTIONS_IFACE_ALL (line actions such as add, cancel, or update), OE_CREDITS_IFACE_ALL and OE_CREDITS_INTERFACE, OE_PAYMENTS_IFACE_ALL and OE_PAYMENTS_INTERFACE, OE_LOTSERIALS_IFACE_ALL (lot and serial assignments), OE_PRICE_ADJS_IFACE_ALL and OE_PRICE_ADJS_INTERFACE (price adjustments), and OE_PRICE_ATTS_IFACE_ALL and OE_PRICE_ATTS_INTERFACE (price attributes). These are the staging structures into which external systems or legacy imports deposit order data.

On the application side, the package references OE_ORDER_LINES_ALL, the base table holding persisted order line records. In typical Order Import execution, the package reads staged rows from the interface tables, validates and enriches them, and writes the resulting order entities into the application tables, with corresponding updates to interface row status.

Usage Notes

OE_ORDER_IMPORT_PVT is invoked indirectly rather than directly. The dependency metadata confirms that it is referenced by OE_ORDER_IMPORT_MAIN_PVT and by OE_CNCL_ORDER_IMPORT_PVT, and it also references itself through the documented dependency listing. OE_CNCL_ORDER_IMPORT_PVT indicates a related path used for order cancellation through the import framework.

Typical invocation occurs when the Order Import concurrent program is submitted following population of the interface tables by an external source, or when a custom program populates the interface tables and then calls the import APIs to process them. Because the package relies on FND_API and STANDARD for its error-handling and control structures, it participates in the standard API error stack and returns status through the caller. The package is marked VALID in the ETRM dictionary, confirming it is compiled and available in the target environment. Customizations should call the supported public Order Import entry points rather than this private package, since its signature and behavior are subject to change across releases and are not governed by Oracle's public API compatibility policy.