Search Results update_cash_receipt

Overview

ARP_PROC_RECEIPTS1 is a private PL/SQL package body in the Oracle Receivables (AR) module of Oracle E-Business Suite. Its primary business function is to act as the entity handler responsible for updating cash transactions — most notably receipts — within the Receivables application. The package encapsulates the logic required to maintain the integrity of the receipt records across multiple related tables when a receipt is modified, including the recalculation of application dates, distribution entries, and payment schedule references.

This package is classified as a private scope package (SCOPE - PRIVATE), meaning it is not intended to be called directly by external interfaces or custom code. Instead, it is invoked internally by other Receivables processes — such as the AutoLockbox, receipt reversal, or receipt adjustment flows — and is referenced by at least one other package within the APPS schema. The package also declares global data types and a debug flag controlled through the AFLOG_ENABLED profile option, allowing runtime diagnostic logging.

Key Procedures and Functions

• REVISION — A standard version-reporting function that returns the current revision string of the package (e.g., '$Revision: 120.22.12010000.2 $'). This is used for patch tracking and diagnostic purposes, consistent with Oracle's coding standards for PL/SQL packages.
• UPDATE_CASH_RECEIPT — The core private procedure of this package. It serves as the entity handler that updates cash transactions. According to the documented modification history, it was designed to support changing the receipt amount even when applications already exist, to return receipt state and status information after the update, and to handle global flexfield parameters. It also determines a valid GL and Reversal GL date for receivable applications, using this date consistently for both the update and creation of application records. This ensures that receipt modifications respect the accounting calendar and do not generate invalid GL dates. The procedure was refined over multiple releases (1995–1997) to address bugs and add functionality.

Tables Accessed

The package operates against a well-defined set of Receivables and Trading Community tables via APPS synonyms. Each table is accessed for a specific business reason:

• AR_CASH_RECEIPTS — The primary receipt table; the package reads and updates the core receipt record, including amount, GL date, and status.
• AR_CASH_RECEIPT_HISTORY — Maintains the audit history of receipt state changes, ensuring that each status transition is recorded.
• AR_DISTRIBUTIONS — Records the accounting distributions associated with the receipt. The package updates these when the amount or GL date changes.
• AR_PAYMENT_SCHEDULES — Represents the payment schedule for transactions; the package may adjust schedule amounts or dates in response to receipt changes.
• AR_RECEIVABLE_APPLICATIONS — Contains the applications of receipts to invoices; the package updates application records with valid GL dates when the receipt is modified.
• AR_TRX_SUMMARY_HIST — Stores transaction summary history; accessed to maintain consistency of summary balances.
• HZ_CUST_ACCOUNTS — The customer account table (TCA); likely used to validate or derive customer-related information during the receipt update.
• DUAL — Used for single-row operations such as date retrieval or sequence-derived values.

Usage Notes

ARP_PROC_RECEIPTS1 is a private package and is not documented as a public API. It is invoked indirectly through Oracle Receivables forms and concurrent programs that update receipts, such as the Receipts form, AutoLockbox, and receipt maintenance processes. Custom code should not call this package directly; instead, developers should use the supported public APIs, such as AR_RECEIPT_API_PUB, which internally may invoke this package. Because the package relies on global flexfield parameters and profile options (AFLOG_ENABLED), any diagnostic tracing must account for these settings. The package's revision function confirms the patch level, which is useful when troubleshooting issues after an upgrade to 12.1.1 or 12.2.2.