Search Results update_receipt_related_columns

Overview

ARP_PS_UTIL is a utility package in the APPS schema of Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) module and operates on the payment schedule layer of the AR data model. Payment schedules are the installment records that link a transaction to its due dates, amounts, and open balances; they are central to collections, aging, credit exposure, and cash application.

The package consolidates maintenance logic that is shared by many Receivables programs. Its primary responsibility is to synchronize denormalized columns on payment schedule rows and on related transaction, adjustment, and receivable application rows whenever those source records change. By centralizing this logic, Receivables ensures that concurrent processes such as receipt application, adjustment creation, chargeback processing, and receipt reversal all update payment schedules consistently. The package is classified as a utility, meaning it is not a public API and is not intended to be called directly by external integrations.

Key Procedures and Functions

The documented interface exposes nine procedures and functions. The update-oriented routines perform targeted refreshes of payment schedule and related entity columns:

• UPDATE_REVERSE_ACTIONS — refreshes amounts and status flags affected when a receivables activity is reversed.
• UPDATE_RECEIPT_RELATED_COLUMNS — synchronizes payment schedule columns that are derived from cash receipts and their applications.
• UPDATE_INVOICE_RELATED_COLUMNS — refreshes payment schedule columns derived from invoice transactions.
• UPDATE_CM_RELATED_COLUMNS — updates payment schedule columns derived from credit memo transactions.
• UPDATE_ADJ_RELATED_COLUMNS — refreshes payment schedule columns derived from adjustment records.
• GET_CLOSED_DATES — returns the closed-date values applicable to a payment schedule, used to determine when an installment was fully settled.
• POPULATE_CLOSED_DATES — writes closed-date values onto payment schedule rows, supporting reconciliation and reporting of settled installments.

The metadata lists nine documented routines in total; these seven are explicitly named. The remaining entries should be treated as internal helpers invoked by the routines above.

Tables Accessed

The package reads and writes the core Receivables payment schedule and application tables through APPS synonyms:

• AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL — the primary targets of the update routines; denormalized amount and status columns are maintained here.
• AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL — applications of receipts, credit memos, and adjustments to transactions; these drive recalculation.
• AR_ADJUSTMENTS — adjustment records whose creation or reversal affects schedule balances.
• RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES — transaction headers and transaction types, used to classify the originating document.
• ARP_GLOBAL — a global settings table referenced for installation-level parameters.

Usage Notes

ARP_PS_UTIL is invoked from Receivables processing packages, not from Oracle Forms or standard concurrent programs. ETRM lists nine dependent packages that call into it, including ARP_PROCESS_APPLICATION, ARP_PROCESS_ADJUSTMENT, ARP_PROCESS_CHARGEBACK, ARP_PROC_RECEIPTS1, ARP_REVERSE_RECEIPT, ARP_CONFIRMATION, ARP_ETAX_UTIL, ARP_PROCESS_DET_PKG, and AR_BILLS_MAINTAIN_PUB. These are the receipt application, adjustment, and chargeback engines that modify open balances.

Because the package recursively references itself, some routines are called from within others to keep logic layered. Custom code should not call these procedures directly; extending or bypassing them risks invalidating payment schedule balances and breaking aging, collections, and reconciliation reports. Use supported Receivables APIs instead.