Search Results insert_adjustments

Overview

APPS.OE_BULK_PRICE_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Order Management (OM) module. It supports the bulk order import and pricing process, allowing large batches of sales orders loaded from external sources to be priced and adjusted as part of a single processing run. The package header carries the revision marker $Header: OEBVPRCS.pls 120.0.12010000.2, with a change note dating to 2008 tied to the HVOP Tax project, indicating its role in taxable pricing calculations.

The package operates only in the private API layer, meaning it is not exposed as a public interface for external integration. It is referenced by two other packages, which invoke its procedures during the bulk pricing workflow. Its primary responsibilities are inserting manual price adjustments from interface staging tables and applying pricing logic across a batch of orders.

Because the package is classified as PVT, direct customer invocation is discouraged; it is intended to be called from within the standard OM bulk processing framework.

Key Procedures and Functions

• Insert_Adjustments — Inserts manual price adjustments for a bulk import batch, transferring records from the interface tables into the price adjustments base table. The procedure accepts a batch identifier and returns a status value. Per the embedded comments, it must be invoked before Price_Orders so that manual adjustments are applied during order pricing.
• Price_Orders — Performs pricing for all orders within a batch. It operates on an order header record passed in and out, accepts a tax processing flag defaulting to 'N', and returns a status value. This is the core pricing engine for the bulk batch.
• Update_Pricing_Attributes — Updates pricing attributes for a collection of order lines supplied through the OE_ORDER_PUB line table type. This supports propagation of attribute data required for correct pricing outcomes.

Tables Accessed

• OE_PRICE_ADJS_IFACE_ALL — the interface table read by Insert_Adjustments to identify manual adjustments awaiting insertion.
• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S — the base and sequence tables written to by Insert_Adjustments.
• OE_ORDER_HEADERS / OE_ORDER_HEADERS_ALL and OE_ORDER_LINES / OE_ORDER_LINES_ALL — order header and line data priced and updated by Price_Orders and Update_Pricing_Attributes.
• QP_LIST_HEADERS and QP_LIST_LINES — pricing and modifier list definitions consulted during adjustment application.
• ONT_DBI_CHANGE_LOG — change tracking for dependent business intelligence and order data.
• PLITBLM — a standard OM table used in list/line identifier processing.

Usage Notes

OE_BULK_PRICE_PVT is designed to be invoked by other packages in the bulk import flow rather than directly by end users or custom integrations. The documented invocation order is critical: Insert_Adjustments must run before Price_Orders to ensure manual adjustments are present when pricing executes. Because the package relies on NOCOPY OUT parameters and private PL/SQL record types defined in OE_BULK_ORDER_PVT, any custom code invoking it must comply with the standard OM API signatures and initialization requirements.

In EBS 12.1.1 and 12.2.2, the package plays a role within the Order Import and pricing concurrent processes. When troubleshooting pricing discrepancies in bulk-loaded orders, the Insert_Adjustments step is a common focus, since failures or misordered execution there cause manual adjustments to be omitted from the final priced order.