Search Results arp_proc_receipts1




Overview
Explore in AI Chat

Overview

ARP_PROC_RECEIPTS1 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified in the E-Business Tables and Relations Model (ETRM) documentation as an "OTHER" API, meaning it is not a formally published public interface but an internal processing unit within the Receivables receipt application stack. Functionally, the package supports the posting and updating of cash receipts against the Oracle Receivables data model. It is a low-level component that participates in the receipt lifecycle, specifically handling revision tracking and the update of cash receipt records and their associated distributions, applications, and history rows. Its dependency footprint — references to AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_RECEIVABLE_APPLICATIONS, and AR_DISTRIBUTIONS — confirms its role in the receipt creation, application, and update process. The package is marked VALID in the ETRM metadata, confirming it is compiled and active in the reference environment.

Key Procedures and Functions

The documented metadata identifies exactly two callable units within ARP_PROC_RECEIPTS1:

  • REVISION — Supports revision processing for cash receipts. Its naming and proximity to the receipt history table indicate it is used to record or manage revisions to receipt records, consistent with the AR_CASH_RECEIPT_HISTORY audit table.
  • UPDATE_CASH_RECEIPT — Performs the update of cash receipt records. Given its dependencies on AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, and AR_DISTRIBUTIONS, this unit is the operational core of the package, writing changes to the receipt header and propagating related accounting and application data.

Parameter lists are not published in the ETRM metadata and are therefore not enumerated here. The two procedures constitute the package's entire documented surface.

Tables Accessed

The package references tables via APPS synonyms, as documented in ETRM 12.2.2:

  • AR_CASH_RECEIPTS — the receipt header, holding receipt number, amount, date, and status; primary target of UPDATE_CASH_RECEIPT.
  • AR_CASH_RECEIPT_HISTORY — receipt audit/history rows, consistent with the REVISION procedure.
  • AR_DISTRIBUTIONS — accounting distributions generated for receipts; maintained as part of the update flow.
  • AR_PAYMENT_SCHEDULES — installment and payment schedule data affected when receipts are applied or reversed.
  • AR_RECEIVABLE_APPLICATIONS — the linkage between receipts and transactions, updated when receipt applications change.
  • AR_TRX_SUMMARY_HIST — transaction summary history, supporting consistent reporting of receipt activity.
  • HZ_CUST_ACCOUNTS — customer account data, referenced for validation and context.
  • DUAL — used for single-row PL/SQL constructs.

Usage Notes

ARP_PROC_RECEIPTS1 is referenced by one other package, AR_RECEIPT_UPDATE_API_PUB, which is the published Receivables receipt update API. This confirms ARP_PROC_RECEIPTS1 is an internal helper invoked indirectly through the public API layer rather than called directly by customer code. It is typically triggered when receipts are updated through the Receipts form, AutoLockbox, or Receipt API processing that routes through AR_RECEIPT_UPDATE_API_PUB. Custom code should avoid direct invocation of ARP_PROC_RECEIPTS1 because its interface is not documented and may change across patches. Clients requiring receipt update behavior should call AR_RECEIPT_UPDATE_API_PUB or the supported Receivables public APIs instead. Because it touches core AR transaction, application, and distribution tables, any direct interaction risks data integrity issues in the Receivables subledger and should be avoided.