Search Results comp_wtd_bal

Overview

ARP_COLL_IND is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name and header comment (ARCOLINS.pls) indicate that it provides the computational engine behind collections and receivables indicators, supplying the numeric metrics that drive the Collections workbench and related receivables reporting. The package is declared with AUTHID CURRENT_USER, so all SQL statements execute under the privileges of the invoking schema rather than the definer.

The package exposes a suite of calculation functions rather than a transactional API. Each function accepts a date range and a set of books identifier, and optionally a customer or site identifier, and returns a single aggregated value. The ETRM classification for the package is OTHER, consistent with an internal calculation utility rather than a public interface. A private helper, Get_Curency_Details, populates a package-level record (curr_rec_type) holding the set of books identifier, base currency, currency precision, and minimum accountable unit from AR_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, and FND_CURRENCIES. This record is used to present monetary results in the base currency at the correct precision.

Key Procedures and Functions

The ETRM metadata documents eighteen callable routines. They divide naturally into four families.

• Receivables balance functions — COMP_TOT_REC computes total original receivables within a date range, while COMP_REM_REC computes the remaining receivables balance over the same range. Both are the routines most frequently referenced by Collections inquiries and by the saved searches that populate the Collections workbench.
• Adjustment functions — GET_ADJ_FOR_TOT_REC, GET_ADJ_FOR_TOT_REC_GL, GET_ADJ_TOTAL, and GET_ADJ_TOTAL_GL return adjustment amounts associated with receivables. The _GL variants derive their results from general ledger balances rather than from subledger transaction tables.
• Aggregate and activity functions — GET_APPS_TOTAL and GET_APPS_TOTAL_GL return applied receipts and cash application totals, again in subledger and GL variants. COMP_DSO, COMP_DSO_GL, COMP_TURNOVER, and COMP_TURNOVER_GL compute days sales outstanding and receivables turnover ratios for a given date range.
• Weighted and threshold functions — COMP_WTD_DAYS and COMP_WTD_BAL compute weighted days and weighted balances, while COMP_ABOVE_AMOUNT, COMP_ABOVE_COUNT, COMP_BELOW_AMOUNT, and COMP_BELOW_COUNT count or total transactions that fall above or below a specified amount threshold.

Tables Accessed

The package reads from the core Receivables and shared reference tables, all through APPS synonyms:

• AR_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS — source of the set of books identifier and base currency used to normalize results.
• FND_CURRENCIES — supplies precision and minimum accountable unit for currency formatting.
• RA_CUSTOMER_TRX_ALL — header-level transaction amounts used in total and remaining receivables calculations.
• AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL — installment-level amounts due, the basis for remaining balance, weighted balance, and DSO computations.
• AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL — cash application detail supporting receipts and turnover functions.
• AR_ADJUSTMENTS and AR_ADJUSTMENTS_ALL — adjustment amounts returned by the adjustment functions.
• FND_PRODUCT_INSTALLATIONS — used to confirm that Oracle Receivables is installed and to scope activity correctly.

Usage Notes

ARP_COLL_IND is a read-only calculation package and performs no inserts, updates, or deletes. It is typically invoked from Oracle Forms in the Collections and Receivables modules, from concurrent programs that populate collections metrics, and from customer-written reports or extensions that require receivables aging, DSO, or turnover figures. The presence of paired subledger and GL variants means callers must choose the correct flavor: the base functions read subledger tables for detailed, real-time figures, whereas the _GL functions use posted general ledger balances and are appropriate for reconciled or period-end reporting. All monetary functions are expected to be called after the currency context has been established so that results reflect base-currency precision. The package does not expose a public API for data maintenance, and ETRM records no other packages referencing it, so it should be treated as a self-contained utility with no dependency obligations.