Search Results qp_bulk_preq_grp




Overview
Explore in AI Chat

Overview

QP_BULK_PREQ_GRP is a group-type PL/SQL package in the APPS schema that supports high-volume pricing and adjustment processing for Oracle Order Management. The package name reflects its role: it performs bulk pricing (the "QP" prefix denotes the Oracle Pricing/Advanced Pricing module) on the pre-requested ("PREQ") data of sales orders that are being staged through the Order Management open interface. Its principal design goal is set-based, bulk operations — that is, processing many order lines and price adjustments in a single pass rather than looping through them one at a time.

In the 12.1.1 and 12.2.2 releases the package is classified as a GRP (group) API, indicating that it groups related procedures that are intended to be invoked together as part of interface processing. It sits between the Order Management bulk order handling layer and the Advanced Pricing engine, orchestrating how pricing results are written into the open-interface (IFACE) tables. As the dependency information confirms, it references OE_BULK_ORDER_PVT, OE_WSH_BULK_GRP and QP_PREQ_GRP, and is in turn referenced by OE_BULK_PRICEORDER_PVT, QP_SOURCING_API_PUB and QP_UTIL_PUB.

Key Procedures and Functions

The documented metadata lists two procedures for this package:

  • BULK_INSERT_LINES — Inserts order line records into the Order Management interface tables in bulk. It is used when a batch of lines must be staged for pricing and subsequent import into the order tables.
  • BULK_INSERT_ADJ — Inserts price adjustment (modifier and discount/surcharge) records in bulk, writing them to the price adjustments interface table so that the calculated pricing adjustments are persisted for the order lines being processed.

Both procedures are bulk-oriented by design; consistent with the GRP classification, they are intended to be called in sequence during interface pricing. The metadata does not document their formal parameter lists, so this summary deliberately avoids asserting signatures. Functionally, the pair form the write side of the bulk pricing interface: lines are staged, and the resulting adjustments are staged alongside them.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • OE_HEADERS_IFACE_ALL — the Order Management header interface table, providing the order context for the lines being inserted or priced.
  • OE_LINES_IFACE_ALL — the Order Management line interface table, the target of BULK_INSERT_LINES and the source of lines requiring pricing.
  • OE_PRICE_ADJS_IFACE_ALL — the price adjustments interface table, the target of BULK_INSERT_ADJ, where modifiers, discounts and surcharges are written.
  • QP_LIST_HEADERS_B and QP_LIST_LINES — the Advanced Pricing list header and line tables, read to obtain qualifier and pricing rule definitions.
  • PLITBLM — an Oracle-supplied SQL table used for parsing delimited character strings, typically applied when handling multi-element rule values or list references.

Usage Notes

QP_BULK_PREQ_GRP is not a user-facing API; it is an internal component of the Order Management open-interface pricing flow. It is normally invoked indirectly through OE_BULK_PRICEORDER_PVT when an order is priced during bulk import, and it is also reachable through pricing entry points exposed by QP_SOURCING_API_PUB and QP_UTIL_PUB. In practice, sites encounter the package when troubleshooting bulk order import concurrent programs, when pricing results fail to populate OE_PRICE_ADJS_IFACE_ALL, or when diagnosing order interface errors.

Because the package is classified as a group API and its procedures are documented only by name, custom callers should avoid direct invocation and instead use the supported order and pricing interfaces. Any change in behavior between 12.1.1 and 12.2.2 should be verified through the delivered dependency chain rather than by inspecting the package body, which is Oracle proprietary. All metadata here is drawn from ETRM documentation for release 12.2.2.