Search Results get_adj_for_tot_rec

Overview

ARP_COLL_IND is a PL/SQL package body owned by APPS in the Oracle E-Business Suite Receivables (AR) module. Its name reflects its purpose as a collections indicator utility: it computes the aggregate metrics that populate Oracle Collections and the Receivables dashboard, including total receivables, remaining receivables, days sales outstanding (DSO), turnover ratios, weighted-average days and balances, and adjustment and transaction counts above or below configurable thresholds. The package is classified as OTHER rather than as a public API, indicating that it is intended primarily for internal use by Oracle's own collections and reporting components. The current source bears a header version of 115.16 dated 2003, confirming that the logic has been stable across the 11i and R12 releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

Eighteen documented procedures and functions constitute the package's public surface. They are described below by function only; parameter lists are not reproduced here.

• COMP_TOT_REC — computes total receivables for the selected operating unit or set of books.
• COMP_REM_REC — computes remaining (open) receivables.
• COMP_DSO — calculates days sales outstanding from Receivables data.
• COMP_DSO_GL — calculates DSO using General Ledger balances as the denominator.
• COMP_TURNOVER — computes receivables turnover from AR data.
• COMP_TURNOVER_GL — computes turnover using GL balances.
• GET_ADJ_FOR_TOT_REC — returns the adjustment amounts to be applied against total receivables, isolating adjustments from the receivables balance used in the ratio calculations.
• GET_ADJ_FOR_TOT_REC_GL — the GL-source variant of the same adjustment isolation, drawing the comparison figures from GL.
• GET_ADJ_TOTAL — returns total adjustments from the AR source.
• GET_ADJ_TOTAL_GL — returns total adjustments from the GL source.
• GET_APPS_TOTAL — returns the aggregate applications total from the AR source.
• GET_APPS_TOTAL_GL — returns the aggregate applications total from the GL source.
• COMP_WTD_DAYS — computes the weighted-average days outstanding.
• COMP_WTD_BAL — computes the weighted-average balance.
• COMP_ABOVE_AMOUNT — counts or totals receivables above a specified amount threshold.
• COMP_ABOVE_COUNT — counts receivables records above a specified count threshold.
• COMP_BELOW_AMOUNT — counts or totals receivables below a specified amount threshold.
• COMP_BELOW_COUNT — counts receivables records below a specified count threshold.

The source excerpt additionally documents a private helper, Get_Currency_Details, which resolves currency code, precision, and minimum accountable unit from either AR_SYSTEM_PARAMETERS or an explicitly supplied set of books identifier, branching on a call-from flag to distinguish AR from GL invocation.

Tables Accessed

The package reads AR_SYSTEM_PARAMETERS and FND_CURRENCIES to establish the base currency and its rounding characteristics; GL_SETS_OF_BOOKS supplies the set of books context. Transaction and balance data are drawn from AR_ADJUSTMENTS and AR_ADJUSTMENTS_ALL for adjustment amounts, AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL for open and remaining balances, AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL for cash application totals, and RA_CUSTOMER_TRX_ALL for transaction-level detail. FND_PRODUCT_INSTALLATIONS is referenced to determine installed product status, and FND_PROFILE is consulted through FND_PROFILE.value for the AFLOG_ENABLED debug setting.

Usage Notes

ARP_COLL_IND is invoked by the Oracle Collections forms and by concurrent programs that refresh collections metrics and dashboard indicators. Each computation is offered in paired AR and GL variants so that the caller can select the appropriate data source depending on whether balances originate from subledger activity or the general ledger. The package is not referenced by any other documented PL/SQL package, so it is effectively a leaf-level calculator rather than a reusable API. Custom code that requires receivable totals, DSO, turnover, or threshold counts may call these procedures directly, provided it supplies a valid set of books context and observes the debug profile option. Because the package is classified as OTHER and carries no documented external signature guarantees, customizations should re-validate behavior after any Receivables patch or upgrade to 12.2.x.