Search Results calc_risk_receipts

Overview

ARP_CUSTOMER_AGING is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It encapsulates the core aging arithmetic used by Oracle Receivables to transform raw subledger transactional data into the aged balance figures presented on customer aging reports and inquiry screens. The package is declared with AUTHID CURRENT_USER, meaning that privilege resolution for its SQL statements is performed against the invoking schema rather than the definer, which is relevant when the package is called from custom code that has been granted restricted access to the underlying Receivables tables.

The package does not own transactional state. Instead, it reads open balances from the payment schedules, applies credits, receipts, adjustments, and disputed amounts, and distributes the residual into configurable aging buckets. It is a calculation utility: the caller supplies the customer, site use, as-of date, currency, and bucket configuration, and the package returns populated bucket titles and amounts through OUT NOCOPY parameters. In the ETRM classification it is recorded as API classification OTHER, reflecting that it is an internal computational module rather than a published, supported open interface.

Key Procedures and Functions

Six procedures are documented for this package:

• CALC_AGING_BUCKETS — The principal routine. It accepts customer, site use, as-of date, currency, credit option, invoice type range, and maximum ID filters, together with a bucket name and a set of seven bucket title/amount pairs. It returns the outstanding balance plus the populated aging bucket titles and amounts. This is the procedure that produces the familiar "Current / 1-30 / 31-60 / 61-90" style presentation.
• CALC_CREDITS — Computes the total credit amount applicable to a customer and site use as of a given date and currency. It returns a single credits figure through an OUT NOCOPY parameter and is used to reduce gross receivables when arriving at a net aged balance.
• CALC_RECEIPTS — The procedure corresponding to the user's search term. It determines the unapplied and on-account cash position for a customer and site use as of the specified date and currency, returning unapplied cash and on-account cash through separate OUT NOCOPY parameters. These figures are essential for reconciling open receivables against cash already received but not yet applied.
• CALC_RISK_RECEIPTS — Derives the receipts relevant to credit risk exposure, giving the collections and credit-management functions a view of cash that mitigates outstanding exposure.
• CALC_DISPUTE — Aggregates disputed amounts so that disputed items can be excluded from or reported separately within the aging analysis.
• CALC_PENDING_ADJ — Calculates adjustments that have been entered but not yet posted, allowing the aging report to reflect pending changes in the customer balance.

Tables Accessed

The package reads and writes against a defined set of Receivables tables through APPS synonyms. AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL supply the open installment balances that form the basis of every aging calculation. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY provide receipt and application history for CALC_RECEIPTS and CALC_RISK_RECEIPTS. AR_RECEIVABLE_APPLICATIONS and AR_ADJUSTMENTS supply applied amounts and adjustments, supporting CALC_PENDING_ADJ and the net balance logic. RA_CUST_TRX_LINE_GL_DIST and RA_CUST_TRX_TYPES resolve transaction amounts and transaction classifications. AR_AGING_BUCKETS and AR_AGING_BUCKET_LINES hold the bucket definitions and bucket line configuration that CALC_AGING_BUCKETS uses to label and populate each bucket.

Usage Notes

The package is invoked indirectly by the standard Receivables customer aging report and related aging inquiry forms, where the caller passes customer, site, date, and currency context. Custom concurrent programs and extensions that require aging figures consistent with the standard report should call these procedures rather than reimplementing the logic. Because the parameters use NOCOPY semantics and the procedures are not designed for set-based processing, callers should drive them per customer/site combination. No other documented package references ARP_CUSTOMER_AGING, so it functions as a leaf-level calculation module. Direct modification of the package is not supported; changes must be applied through Oracle patches.