Search Results arp_process_rcts




Overview
Explore in AI Chat

Overview

ARP_PROCESS_RCTS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the processing, maintenance, and lifecycle management of cash receipts in Oracle Receivables. The package name reflects its role as a receipt processing utility within the AR module, providing the underlying program logic invoked by Receivables forms, concurrent programs, and internal APIs to manipulate receipt records and their associated transaction extensions.

The package is classified as OTHER in the ETRM API registry, indicating that it is not part of Oracle's documented public API set. It is therefore an internal component whose procedures are consumed primarily by Oracle's own Receivables forms and business logic rather than by customer extensions. In EBS 12.1.1 and 12.2.2 the package carries a VALID status in the database, and its dependencies confirm tight coupling to Receivables data structures, the IBY (Payments) transaction extension view, and the FND_API error-handling framework.

Key Procedures and Functions

The documented interface exposes six procedures:

  • REVISION — Performs revision handling on a receipt record, supporting the Oracle Receivables revision mechanism that tracks changes to receipt data for audit and history purposes.
  • LOCK_CASH_RECEIPT — Acquires a lock on a cash receipt to prevent concurrent modification, ensuring serialized access when multiple sessions attempt to update the same receipt.
  • DELETE_CASH_RECEIPT — Removes a cash receipt record, applying the deletion logic and related validation required to keep receipt-dependent records consistent.
  • POST_QUERY_LOGIC — Executes post-query processing logic, typically invoked after a form query to derive or initialize display values based on the retrieved receipt row.
  • SET_POSTED_FLAG — Sets the posted indicator on a receipt, controlling whether the receipt is treated as accounted or posted within the Receivables posting cycle.
  • DELETE_TRANSACTION_EXTENSION — Deletes transaction extension records associated with a receipt, operating against the IBY transaction extension structure used by Oracle Payments.

Tables Accessed

The package operates across a broad set of Receivables and Payments tables. Core receipt data is held in AR_CASH_RECEIPTS and its history in AR_CASH_RECEIPT_HISTORY, which the package maintains alongside receipt processing. Distribution and accounting detail reside in AR_DISTRIBUTIONS and AR_TRX_SUMMARY_HIST. Application and adjustment activity is captured through AR_RECEIVABLE_APPLICATIONS and AR_ADJUSTMENTS, while AR_PAYMENT_SCHEDULES and RA_CUSTOMER_TRX link receipts to their originating transactions. System-level defaults come from AR_SYSTEM_PARAMETERS and batch grouping from AR_BATCHES. Payments integration is supported via CE_STATEMENT_HEADERS, CE_STATEMENT_LINES, and CE_STATEMENT_RECONCILS_OU, and by AP_CHECKS and AP_INVOICE_SELECTION_CRITERIA. Extension and API plumbing is provided by IBY_TRXN_EXTENSIONS_V and FND_API.

Usage Notes

ARP_PROCESS_RCTS is invoked indirectly through Oracle Receivables forms and internal routines rather than being called from user-facing APIs. Its procedures are exercised during receipt entry, modification, deletion, and posting flows, and during receipt-related concurrent processing where receipts must be locked or flagged. Because it is not a published API, customizations should not call it directly; developers requiring receipt manipulation should use supported public APIs and the Receivables Open Interfaces instead. The metadata indicates the package is referenced by no other packages, so its callers are confined to forms and internal Oracle code.