Search Results arp_process_application




Overview
Explore in AI Chat

Overview

ARP_PROCESS_APPLICATION is a core PL/SQL package in the Oracle EBS Receivables (AR) module, owned by the APPS schema. It encapsulates the business logic that drives the application of receipts, credit memos, and on-account transactions against open receivables. In Oracle EBS 12.1.1 and 12.2.2, this package forms part of the transactional engine that determines how cash, adjustments, and credits are matched to transactions, how disputes and claims are raised, and how reversals are processed. Its classification is OTHER, indicating that it is not exposed as a formal public API but is instead an internal processing package called by higher-level public APIs and forms. The package derives its name from the central operation it performs—processing applications of funds or credits to open items in AR.

Key Procedures and Functions

The documented interface comprises eighteen procedures and functions. RECEIPT_APPLICATION and CM_APPLICATION handle the core matching of receipts and credit memos to transactions. CM_ACTIVITY_APPLICATION and ACTIVITY_APPLICATION apply activity against receivables, while ON_ACCOUNT_RECEIPTS and OTHER_ACCOUNT_APPLICATION manage unapplied and miscellaneous applications. REVERSE and REVISION support reversal and re-application scenarios. Dispute and claim handling is provided by CREATE_CLAIM, UPDATE_CLAIM, GET_CLAIM_STATUS, PUT_TRX_IN_DISPUTE, and UPDATE_DISPUTE_ON_TRX. Credit memo association logic is handled by UNASSOCIATE_REGULAR_CM, IS_REGULAR_CM, and UNASSOCIATE_DEPOSIT_FROM_CM. UPDATE_SELECTED_TRANSACTION updates transaction state during application, and FETCH_APP_CCID retrieves the accounting flexfield combination used for the application.

Tables Accessed

The package reads and writes several core AR tables via APPS synonyms. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY store receipt headers and their state history. AR_RECEIVABLE_APPLICATIONS records the actual application lines linking receipts or credits to transactions, while AR_PAYMENT_SCHEDULES and AR_ADJUSTMENTS/AR_ADJUSTMENTS_ALL maintain the resulting balances and adjustments. AR_DISTRIBUTIONS captures the accounting distributions generated. AR_RECEIPT_METHODS and AR_RECEIPT_METHOD_ACCOUNTS provide receipt method rules and default accounts, and CE_BANK_ACCT_USES_OU links bank accounts to operating units. Transaction and activity context is drawn from AR_RECEIVABLES_TRX, AR_ACTIVITY_DETAILS, AR_TRANSACTION_HISTORY, and AR_TRX_SUMMARY_HIST. AR_SYSTEM_PARAMETERS supplies system-level defaults that govern application behavior.

Usage Notes

ARP_PROCESS_APPLICATION is invoked primarily through Receivables public APIs and forms rather than directly by end users. It is referenced by thirteen other packages, including AR_RECEIPT_API_PUB, AR_CM_API_PUB, AR_CM_APPLICATION_PUB, AR_RECEIPT_VAL_PVT, ARP_REVERSE_RECEIPT, ARP_CHARGEBACK_COVER, and AR_IREC_APPLY_CREDITS, confirming its role as a shared application engine beneath the public API layer. Customizations should therefore call the supported public APIs wherever possible and avoid direct invocation of this package, since its interface is not documented as a stable public contract. Its procedures are exercised during receipt application, credit memo application, on-account and unapplied cash handling, reversals, and dispute/claim processing, all of which are central to daily cash management and collections activity in Oracle Receivables.