Search Results arp_process_misc_receipts2




Overview
Explore in AI Chat

Overview

ARP_PROCESS_MISC_RECEIPTS2 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. It supports the processing of miscellaneous receipts — cash receipts that are not tied to a specific customer invoice or transaction but instead post directly to a general ledger account. This package is the second of the related miscellaneous receipt processing units and is responsible for the lower-level maintenance operations performed against an existing miscellaneous receipt: locking it for update, reversing it, and deleting it. It is classified as an OTHER API, meaning it is not published as a formal open interface but is nonetheless an integral part of the Receivables cash receipt processing infrastructure.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its object metadata is identical across the two releases. It depends only on the SYS.STANDARD package, and no other APPS packages are recorded as referencing it directly, which indicates that it is invoked internally by the Receivables receipt processing stack rather than exposed broadly to external callers.

Key Procedures and Functions

The ETRM documentation records three callable program units within this package:

  • LOCK_MISC_RECEIPT — Acquires a lock on a miscellaneous receipt record so that concurrent processing cannot modify the same receipt simultaneously. This supports the Receivables locking convention used to serialize updates to cash receipts.
  • REVISION — Implements the revision or reversal logic applied to a miscellaneous receipt, updating the receipt and its related accounting records to reflect the changed state. The presence of this routine explains the package's direct access to reversal-related tables such as AR_CASH_RECEIPT_HISTORY.
  • DELETE_MISC_RECEIPT — Removes a miscellaneous receipt along with its associated distributions and payment schedule rows, ensuring that no orphaned accounting entries remain.

Parameter lists and exact signatures are not published in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package references the following tables through APPS synonyms:

  • AR_CASH_RECEIPTS — the header table for the miscellaneous receipt itself; read during locking and updated or deleted during revision and deletion.
  • AR_CASH_RECEIPT_HISTORY — records the status and activity history of the receipt, updated when the receipt is reversed or removed.
  • AR_DISTRIBUTIONS — general ledger distributions generated by the receipt; removed when the receipt is deleted.
  • AR_MISC_CASH_DISTRIBUTIONS — the specific distribution rows created for miscellaneous cash receipts that post directly to a GL account rather than to a customer balance.
  • AR_PAYMENT_SCHEDULES — the payment schedule rows linked to the receipt, which must be maintained consistently with the header.
  • AR_SYSTEM_PARAMETERS — used to read Receivables setup options that govern receipt processing behavior.
  • DUAL — a standard single-row utility table used for simple scalar queries and assignments.

Usage Notes

ARP_PROCESS_MISC_RECEIPTS2 is invoked indirectly through the Receivables miscellaneous receipt processing flow rather than being called by end users. Typical invocation points include the Receivables cash receipts workbench, the Miscellaneous Receipts form, and any custom code that must reverse or delete a miscellaneous receipt using supported Receivables behavior. Because it is not an open interface, customizations should call it only after confirming the calling conventions in a non-production environment.

In 12.1.1 and 12.2.2 the package retains the same object structure and dependency profile. When diagnosing locked or unremovable miscellaneous receipts, DBAs and developers commonly examine this package to understand the locking and deletion sequence applied to the AR_CASH_RECEIPTS and AR_MISC_CASH_DISTRIBUTIONS records.