Search Results oe_retrobill_pvt




Overview
Explore in AI Chat

Overview

OE_RETROBILL_PVT is a private PL/SQL package in the APPS schema that implements the retro-billing engine for Oracle Order Management. Retro-billing is the process by which pricing adjustments negotiated after an order has been booked—most commonly retrospective discounts, rebates, or volume-based price breaks—are applied back to already-shipped or already-invoiced order lines. Because the adjustments affect downstream Receivables invoices, the package must reconcile order pricing with billing data while preserving the audit trail of the original transaction.

The package is classified as a PVT (private) API, indicating that it is intended for internal use by other Order Management packages rather than as a public integration interface. It is a critical component of the pricing and adjustment subsystem, invoked by OE_ORDER_PUB, OE_INVOICE_PUB, OE_ORDER_PRICE_PVT, OE_LINE_ADJ_UTIL, OE_HEADER_ADJ_UTIL, OE_VALIDATE_HEADER, and OE_DEFAULT_LINE. In Oracle EBS 12.1.1 and 12.2.2, the package body is delivered as VALID in a standard installation, and its dependencies reference the standard SYS.STANDARD package.

The metadata documents twenty procedures and functions covering the complete retro-billing lifecycle: request creation, eligibility checking, adjustment calculation, line updating, RMA handling, purge, and concurrent program processing.

Key Procedures and Functions

Tables Accessed

The package reads and writes OE_RETROBILL_REQUESTS and OE_RETROBILL_REQUEST_S, which store the header and line detail of retro-billing requests. Order data is drawn from OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, and OE_ORDER_LINES_ALL, with pricing attributes in OE_ORDER_PRICE_ATTRIBS. Adjustment definitions and associations are read from OE_PRICE_ADJUSTMENTS, OE_PRICE_ADJUSTMENTS_S, OE_PRICE_ADJ_ASSOCS, and OE_PRICE_ADJ_ASSOCS_S. OE_TRANSACTION_TYPES_ALL determines whether a transaction type supports retro-billing, while FND_LANGUAGES and OE_PROCESSING_MSGS / OE_PROCESSING_MSGS_TL supply multilingual messages for errors and status. OE_CONC_REQUEST_IFACE is used when the concurrent program submits processing requests.

Usage Notes

OE_RETROBILL_PVT is invoked indirectly through order entry forms and the Order Management pricing engine whenever an adjustment with retro-billing behavior is defined and applied. Merchandising and Advanced Pricing setups that enable retro-billing drive the calls from OE_ORDER_PUB and OE_ORDER_PRICE_PVT during order or line save. The concurrent program entry point, OE_RETROBILL_CONC_PGM, should be scheduled from the Order Management responsibility to process outstanding OE_RETROBILL_REQUESTS in batch. Because this is a private package, customizations should not call it directly; supported extension points are the public OE_ORDER_PUB and OE_INVOICE_PUB APIs, which internally delegate to this package.