Search Results config_totals

Overview

The APPS.OE_OE_TOTALS_SUMMARY package is a core Order Management calculation engine in Oracle E-Business Suite, responsible for deriving and exposing monetary and quantity totals for sales orders. It aggregates extended prices, price adjustments, charges, taxes, order subtotals, recurring charges, and order totals across the header, line, and service levels of an order. The package is classified by ETRM as an "OTHER" API object, meaning it is an internal implementation package rather than a formally published public API, although its functions are widely depended upon throughout the Order Management schema.

The package maintains a set of global (session-scoped) PL/SQL variables — including G_TAX_VALUE and G_TOTAL_EXTENDED_PRICE, along with recurring counterparts such as G_REC_TAX_VALUE and G_REC_TOTAL_EXTENDED_PRICE — that cache intermediate totals during a calculation pass. It also declares a PL/SQL record type, rec_charges_rec_type, with fields for charge periodicity code, description, meaning, recurring subtotal, recurring tax, recurring charges, and recurring total, and a corresponding associative array type rec_charges_tbl_type. These structures support recurring-charge rollups such as subscription or service billing periods.

Key Procedures and Functions

ETRM documents 33 procedures and functions. The principal documented members include:

• PRICE_ADJUSTMENTS — Returns the aggregate value of price adjustments applied to an order header.
• LINE_PRICE_ADJ_ORDER_MODIFIER and LINE_EXT_ADJ_ORDER_MODIFIER — Return order-level modifier amounts applicable to a given line, used to attribute header-level adjustments down to the line.
• LINE_PRICE_ADJUSTMENTS — Returns the price adjustment total for a specific line.
• CHARGES and LINE_CHARGES — Return charges at the header and line levels respectively.
• TAXES — Returns the tax total for an order header.
• ORDER_SUBTOTALS — Returns the order subtotal (extended price net of adjustments, before tax and charges).
• LINE_TOTAL and SERVICE_TOTAL — Return the total for a specific line or service line; the latter carries the marker comment "bug - 1480491," indicating a historical fix.
• GLOBAL_TOTALS — A procedure that computes and stores the order's global totals.
• PRT_ORDER_TOTAL — Returns a printable (formatted) order total, the object most commonly targeted by the search term "prt_order_total."
• Additional aggregators — CONFIG_TOTALS, TOTAL_ORDERED_QTY, ORDER_TOTALS, OUTBOUND_ORDER_TOTAL, OUTBOUND_ORDER_SUBTOTAL, GET_ORDER_AMOUNT, GET_DISCOUNT, and GLOBAL_REC_TOTALS, which handle configuration totals, quantities, outbound (shipping) totals, discount retrieval, and recurring global totals.

Tables Accessed

The package reads from several Order Management and inventory tables through APPS synonyms: OE_ORDER_LINES_ALL (line-level pricing data), OE_PRICE_ADJUSTMENTS (adjustment definitions and applied amounts), OE_PAYMENTS (payment and deposit information), MTL_SYSTEM_ITEMS (item attributes affecting pricing), and PLITBLM (a PL/SQL index-by table used internally for bulk computation). These accesses allow the package to reconstruct order totals from persisted transactional data at query time rather than relying solely on stored summary columns.

Usage Notes

OE_OE_TOTALS_SUMMARY is referenced by 24 other packages and is typically invoked from Order Management forms (such as the Sales Orders window) to display live totals, from order-entry and order-import business flows, and from custom code that requires authoritative order, line, or service totals. Because it is classified as an internal package, Oracle does not guarantee its signature across releases; implementers extending or calling it directly should validate behavior in both 12.1.1 and 12.2.2, where the source header shows a long-stable revision. Customizations should prefer wrapping the documented functions rather than modifying the package body.