Search Results oe_actions_interface




Overview
Explore in AI Chat

Overview

APPS.OE_BULK_HEADER_UTIL is a utility PL/SQL package body in the Oracle E-Business Suite Order Management (OE) module. Its role is to support high-volume, set-based import of order header data from the Order Import interface tables into the base Order Management tables. Rather than processing a single order at a time through the standard Order Management APIs, this package provides bulk loading, insertion, and sales credit creation logic used by the Order Import concurrent process. The package is classified as a UTIL-type object, meaning it is a supporting internal utility rather than a public-facing API. It operates within the APPS schema and is directly referenced by OE_BULK_ORDER_PVT and OE_BULK_ORDER_IMPORT_PVT, the parent bulk-processing packages. It is not referenced by any other database object, confirming its position as a leaf-level helper.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package body:

  • LOAD_HEADERS — Drives the loading of order header records from the interface staging tables into the working bulk structures. It prepares header data for subsequent insertion into the permanent Order Management tables.
  • INSERT_HEADERS — Performs the actual insertion of staged header rows into OE_ORDER_HEADERS_ALL, translating interface records into the base table representation. It is the core write operation of the package.
  • CREATE_HEADER_SCREDITS — Generates sales credit records associated with the inserted headers, populating OE_SALES_CREDITS and its sequence-backed table OE_SALES_CREDITS_S.

These three procedures correspond to the classic load–insert–credit pipeline of bulk order import. No parameter lists are documented, and none are inferred here.

Tables Accessed

The package operates across the following documented tables (referenced through APPS synonyms):

  • OE_ACTIONS_INTERFACE — Source of action codes that determine how each imported order header is processed (for example, insert versus update semantics).
  • OE_HEADERS_IFACE_ALL — The primary Order Import interface table from which header rows are read.
  • OE_ORDER_HEADERS_ALL — The base Order Management header table populated by INSERT_HEADERS.
  • OE_SALES_CREDITS and OE_SALES_CREDITS_S — Target tables for sales credit rows created by CREATE_HEADER_SCREDITS.
  • PLITBLM — A generic PL/SQL index-by table type used internally for bulk collections.

In addition, the package depends on FND_API and FND_GLOBAL for the standard API framework and session context, OE_BULK_MSG_PUB for message handling, OE_DEBUG_PUB for diagnostics, and OE_WSH_BULK_GRP for warehouse/shipping bulk grouping. The documented dependency on OE_ACTIONS_INTERFACE is the direct answer to the search term "oe_actions_interface": this package is one of the objects that consumes that table rather than being referenced by it.

Usage Notes

OE_BULK_HEADER_UTIL is not intended for direct invocation by end users or custom code. It is invoked internally by the higher-level bulk packages OE_BULK_ORDER_PVT and OE_BULK_ORDER_IMPORT_PVT during the Order Import concurrent program execution. The typical flow begins with the user loading records into OE_HEADERS_IFACE_ALL, submitting Order Import, and allowing the bulk processing layers to call LOAD_HEADERS, INSERT_HEADERS, and CREATE_HEADER_SCREDITS in sequence. Because the package is not referenced by any other database object and is classified as UTIL, it should be treated as an internal implementation detail whose interface may change across patch levels. Customizations should target the documented Order Import APIs rather than this utility directly. The package is present and VALID in both Oracle EBS 12.1.1 and 12.2.2 environments.