Search Results receipt_debit_memo_reversed




Overview
Explore in AI Chat

Overview

ARP_CASHBOOK is a core Oracle Receivables PL/SQL package in the APPS schema that encapsulates the business logic governing cash receipt lifecycle events within the cashbook. Its responsibilities span clearing and unclearing of receipts against transactions, risk elimination and its reversal, receipt reversal, debit memo reversal handling, and the maintenance of receipt-related accounting distributions. In effect, ARP_CASHBOOK acts as the procedural engine behind the activities a receivables clerk performs in the Receipts and Cashbook workbench, translating user actions into consistent updates across AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_PAYMENT_SCHEDULES and the supporting distribution and rate-adjustment tables.

The package is classified as an OTHER API within the ETRM 12.2.2 repository, indicating that it is an internal application-programming interface rather than a formally published public API. It is shipped as a VALID object in both the 12.1.1 and 12.2.2 releases and is heavily reused by other Oracle modules, most notably Cash Management, confirming its central role in receipt processing.

Key Procedures and Functions

The documented implementation exposes twelve procedures and functions. Their names and purposes are as follows:

  • CLEAR — Applies a receipt against one or more open transactions, updating payment schedules and generating the corresponding accounting distributions.
  • UNCLEAR — Reverses a prior clearing event, restoring the transaction to an open state and removing the associated distributions.
  • RISK_ELIMINATE — Removes the receipt from risk (unapplied or on-account balances) so that it no longer contributes to receivables risk exposure.
  • UNDO_RISK_ELIMINATE — Reverses a risk elimination previously performed on a receipt.
  • INS_MISC_TXN — Inserts a miscellaneous receipt transaction, used for non-invoice related receipt activity.
  • REVERSE — Performs a full reversal of a cash receipt, including reversal of applications and distributions.
  • DEBIT_MEMO_REVERSAL — Handles the reversal of debit memo activity associated with receipts.
  • LOCK_ROW — Acquires a row-level lock on the receipt record to serialise concurrent processing.
  • RECEIPT_DEBIT_MEMO_REVERSED — Records that a receipt-related debit memo has been reversed.
  • UPDATE_ACTUAL_VALUE_DATE — Maintains the actual value date on the receipt, supporting cash management and reconciliation.
  • REFRESH_RISK_VALUE — Recalculates and refreshes the risk value associated with a receipt.
  • REVISION — Supports revision processing of receipt data.

Tables Accessed

The package reads and writes the principal Receivables cash tables, including AR_CASH_RECEIPTS and its _ALL variant, AR_CASH_RECEIPT_HISTORY, AR_PAYMENT_SCHEDULES, AR_BATCHES, AR_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, AR_RECEIVABLES_TRX, AR_RATE_ADJUSTMENTS and AR_RECEIPT_METHOD_ACCOUNTS, together with RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST and RA_CUST_TRX_TYPES for transaction and distribution context. CE_BANK_ACCOUNTS is referenced to validate the remittance bank account, and AR_CONC_PROCESS_REQUESTS supports concurrent processing coordination.

Usage Notes

ARP_CASHBOOK is invoked primarily through the Receipts form and the Cashbook window, and indirectly by concurrent programs and by downstream packages. The dependency metadata shows it is referenced by seventeen objects, including ARP_AUTOMATIC_CLEARING_PKG, CE_AUTO_BANK_CLEAR, CE_AUTO_BANK_MATCH, CE_STATEMENT_RECONS_PKG and numerous CE_CP_DISC and CE_FC receipts views used for Cash Management reconciliation and forecasting. Custom code should treat it as an internal API: direct calls are possible but unsupported, and Oracle's own callers should be the primary integration path. Because operations such as CLEAR, REVERSE and RISK_ELIMINATE generate accounting entries, any direct invocation must respect the standard Receivables accounting and period-control rules.