Search Results insert_headers




Overview
Explore in AI Chat

Overview

APPS.OE_BULK_HEADER_UTIL is a utility package within the Oracle Order Management module of Oracle E-Business Suite. Its principal business function is to support high-volume, bulk processing of order headers during the order import cycle. The package bridges the interface tables and the base Order Management transaction tables, moving staging data into live sales order records one batch at a time.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking schema rather than the definer. It is classified as a UTIL package in the ETRM 12.2.2 metadata, confirming its role as an internal helper rather than a public, user-callable API. The header comment indicates the package was last revised in the 12.1.1 development stream (the OEBUHDRS.pls revision 120.0.12010000.1), and it remains present in 12.2.2. The package exposes three documented procedures and manipulates header-level data, including sales credits, while relying on the shared record structures defined in OE_BULK_ORDER_PVT.

Key Procedures and Functions

The package defines three documented procedures:

  • Load_Headers — Loads order headers in the batch from the interface tables into the record structure p_header_rec. It accepts a batch identifier and an IN OUT NOCOPY header record, meaning the caller passes in a record that is populated in place with the header data for the batch. This procedure reads the staging data and prepares it for insertion.
  • Insert_Headers — Performs a bulk insert of order headers into the OM base tables from the populated p_header_rec record, using the batch identifier supplied by the caller. This is the procedure directly associated with the search term insert_headers, and it is the component that commits the header information assembled by Load_Headers into the transactional tables.
  • Create_Header_Scredits — Performs a bulk insert of header-level sales credits into the OM tables from a p_header_scredit_rec record based on the shared sales credit record type. This handles the credit assignment associated with the headers being imported.

The package relies on the HEADER_REC_TYPE and SCREDIT_REC_TYPE structures defined in OE_BULK_ORDER_PVT, which supply the record layouts consumed by these procedures.

Tables Accessed

The package reads and writes the following documented tables, all addressed through APPS synonyms:

  • OE_HEADERS_IFACE_ALL and OE_ACTIONS_INTERFACE — the interface staging tables from which header and action data are read during the bulk load.
  • OE_ORDER_HEADERS_ALL — the base Order Management header table into which records are bulk inserted by Insert_Headers.
  • OE_SALES_CREDITS and OE_SALES_CREDITS_S — the sales credit tables and their corresponding sequence (or shadow) table, populated by Create_Header_Scredits.
  • PLITBLM — an internal PL/SQL table used in the bulk collection processing that underpins the high-volume insert logic.

Usage Notes

OE_BULK_HEADER_UTIL is an internal utility rather than a published public API; the three procedures are not intended for direct invocation by end users. In practice it is invoked from within the Order Management order import framework, where the bulk import process calls Load_Headers to populate a header record from the interface tables, Insert_Headers to write it into OE_ORDER_HEADERS_ALL, and Create_Header_Scredits to write the associated sales credits. It is not exposed through Oracle Forms or a standalone concurrent program of its own; rather, it operates beneath the concurrent order import programs that drive bulk processing.

Because the package is referenced by one other package and depends on OE_BULK_ORDER_PVT record types, customizations should not call these procedures directly. Any extension or troubleshooting effort should instead work through the supported import interfaces, since the bulk insert logic and its PLITBLM-based collection handling are specific to the internal batch mechanism and are closely coupled to the surrounding Order Management import code.