Search Results ar_refunds_pvt




Overview
Explore in AI Chat

Overview

AR_REFUNDS_PVT is an internal private PL/SQL package in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema and classified as a PVT (private) API. It encapsulates the core business logic that governs customer refund processing, one of the mandatory credit management functions within the Order to Cash cycle. A refund in Receivables represents the return of customer funds that were previously received as an unapplied or on-account cash receipt, or that arise from overpayment against an invoice. The package provides the procedural foundation for creating a refund against an existing receipt and for cancelling a previously created refund when the business decision is reversed.

As a private package, AR_REFUNDS_PVT is not intended to be called directly by external integrations or custom code. It is invoked by the public Receivables APIs and by the refund-related forms and concurrent processes that present the user-facing transaction. The package status is VALID in the documented ETRM metadata for both 12.1.1 and 12.2.2, confirming it as an active component of the Receivables codebase.

Key Procedures and Functions

Two documented procedures constitute the public surface of this package:

  • CREATE_REFUND — Validates and processes the creation of a customer refund. It applies the requisite validation logic against the source cash receipt, determines the refundable amount, and writes the resulting refund transaction records, including the corresponding payable invoice interface records used to remit funds to the customer or payee.
  • CANCEL_REFUND — Reverses a previously created refund. It restores the status of the associated payment, reverses the accounting impact of the original refund transaction, and returns the source receipt to its prior applied or unapplied balance state.

The package is referenced by AR_REFUNDS_PVT itself (recursive internal calls), ARP_REVERSE_RECEIPT, AR_CM_APPLICATION_PUB, and AR_RECEIPT_API_PUB, meaning public receipt APIs and reversal logic delegate refund activity to this private layer rather than manipulating refund tables directly.

Tables Accessed

Documented table references (via APPS synonyms) reflect the cross-module nature of refund processing:

Usage Notes

AR_REFUNDS_PVT should never be called directly in custom code. It is normally entered through the Receipts workbench when a user creates a refund against an existing receipt, through the AR_RECEIPT_API_PUB public API for programmatic receipt and refund processing, and through AR_CM_APPLICATION_PUB and ARP_REVERSE_RECEIPT when receipts are reversed. Customizations requiring refund functionality should target the supported public APIs that internally invoke this package. Direct modification of the underlying refund and cash receipt tables is not supported and bypasses the validation and accounting logic centralised here.