Search Results arp_receipts_main




Overview
Explore in AI Chat

Overview

ARP_RECEIPTS_MAIN is a core PL/SQL package in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema. In the Oracle EBS 12.1.1 and 12.2.2 releases, it serves as the primary internal engine for creating, validating, and accounting for cash receipts and the distribution lines that represent their accounting impact. The package is classified in the E-Business Suite Technical Reference Manual (ETRM) as an "OTHER" API, meaning it is an internal, Oracle-owned construct rather than a formally published public API such as those documented in the Oracle Receivables Reference Manual for Public APIs. Its responsibilities center on the transactional processing that occurs when a receipt is entered, applied, adjusted, or reversed, including the generation of accounting distributions into the AR_DISTRIBUTIONS table and the posting of receipt-related activity to the General Ledger interface.

Key Procedures and Functions

The ETRM documents two procedures/functions within ARP_RECEIPTS_MAIN:

  • EXECUTE — The principal procedure of the package. It drives receipt processing logic, orchestrating validation, application, and accounting distribution generation for cash receipts. It is invoked during receipt creation and modification to move a receipt through its accounting lifecycle.
  • DELETE_ACCT — A procedure responsible for removing or reversing accounting distribution records associated with a receipt, typically invoked when a receipt is reversed, deleted, or its accounting impact must be undone.

Parameter lists are not documented in the ETRM metadata and must not be assumed. Developers requiring signature detail should inspect the package specification directly in the database or consult Oracle Support documentation.

Tables Accessed

ARP_RECEIPTS_MAIN accesses a broad set of Receivables tables through APPS synonyms. The principal entries include AR_CASH_RECEIPTS (the receipt header) and AR_DISTRIBUTIONS (accounting distribution lines). Supporting tables include AR_ADJUSTMENTS, AR_MISC_CASH_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, AR_REC_TRX_LE_DETAILS, AR_RECEIPT_METHOD_ACCOUNTS, and AR_RECEIVABLES_TRX, which together govern how receipts are applied and how receipt methods map to accounting. Setup and control tables such as AR_SYSTEM_PARAMETERS, AR_VAT_TAX, and FND_CURRENCIES provide system options, tax treatment, and currency validation. Transaction-side tables RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and the global temporary table RA_CUSTOMER_TRX_LINES_GT are referenced for application and tax recalculation logic, together with AR_TRANSACTION_HISTORY for audit trail. Dependency metadata additionally confirms references to ARP_ACCT_MAIN, the standard accounting engine package.

Usage Notes

ARP_RECEIPTS_MAIN is not a supported public API and should not be called directly from custom code. It is invoked internally by Oracle Receivables forms (such as the Receipts workbench), by concurrent programs that process receipt accounting and post to the General Ledger, and by other internal packages. The dependency metadata shows that it is referenced by APPS.ARP_ACCT_MAIN and by itself (recursive invocation), while it in turn references ARP_ACCT_MAIN and the SYS.STANDARD package. In 12.1.1 and 12.2.2, customizations that must create or reverse receipts should use the documented public APIs (for example, AR_RECEIPT_API_PUB) rather than this internal package. Any direct dependency on ARP_RECEIPTS_MAIN carries upgrade risk, since internal signatures and logic may change between point releases without public notification.