Search Results get_adj_total

Overview

IEX_COLL_IND is an Oracle EBS Accounts Receivables collections indicator package owned by APPS. It supplies the quantitative metrics that drive the Collections dashboard and the credit and collections workbench, translating raw transaction, receipt, and adjustment data into the key performance indicators used by credit analysts and collectors. The package is classified as OTHER, indicating that it is not an Oracle-published public API but an internal computation library invoked by other product code. In the 12.1.1 and 12.2.2 releases the package body is loaded under a single source revision (iexvmtib.pls, version 120.10) and exposes thirty-two documented procedures and functions. The metadata registers three dependent packages, confirming that IEX_COLL_IND acts as a shared calculation layer rather than an entry point exposed to end users.

Key Procedures and Functions

The documented routines fall into several functional groups:

• Days-late and days-paid metrics: GET_AVG_DAYS_LATE, GET_WTD_DAYS_LATE, GET_WTD_DAYS_PAID, and GET_WTD_DAYS_TERMS compute average and weighted-average indicators of customer payment behavior. GET_AVG_DAYS_LATE, as shown in the source excerpt, sums the difference between the system date and payment schedule due dates over the trailing twelve months and divides by the count of qualifying schedules, optionally filtering by party, customer account, or site use.
• DSO metrics: GET_CEI, GET_TRUE_DSO, and GET_CONV_DSO derive collection effectiveness and days-sales-outstanding figures.
• Deduction and non-sufficient-funds metrics: GET_NSF_STOP_PMT_COUNT and GET_NSF_STOP_PMT_AMOUNT report counts and values of NSF and stopped payments; GET_DEDUCTION and GET_SALES summarize deduction and sales activity.
• Receipt composition: COMP_TOT_REC, COMP_REM_REC, and COMP_CURR_REC break total receipts into remaining and current components.
• Adjustment aggregates: GET_APPS_TOTAL, GET_ADJ_TOTAL, and GET_ADJ_FOR_TOT_REC aggregate application and adjustment amounts.
• Credit exposure: GET_CREDIT_LIMIT, GET_HIGH_CREDIT_YTD, and AMOUNT_DUE_ORG_OCM return credit limit, year-to-date high credit, and amounts due at the operating unit or organization level.

Tables Accessed

The package reads from a defined set of Accounts Receivables and Trading Community tables through APPS synonyms. AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL supply due dates, general ledger dates, transaction classes, and status used by the days-late and DSO routines. AR_CASH_RECEIPTS, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY, and AR_CASH_RECEIPT_HISTORY_ALL provide receipt and receipt-history data for the composition and NSF metrics. AR_RECEIVABLE_APPLICATIONS and AR_ADJUSTMENTS support application and adjustment aggregation. AR_TRX_SUMMARY and AR_TRX_BAL_SUMMARY contribute transaction-level balances, while AR_SYSTEM_PARAMETERS supplies operating parameters. Customer attributes such as party, profile, credit limit, and year-to-date high credit are drawn from HZ_CUST_ACCOUNTS, HZ_CUSTOMER_PROFILES, and HZ_CUST_PROFILE_AMTS. FND_CURRENCIES is referenced for currency attributes. The source excerpt shows the package performing read-only SELECT statements; no writes are evident in the documented metadata.

Usage Notes

IEX_COLL_IND is invoked internally by Oracle Collections and Credit Management components rather than called directly by end users. Its functions are typically executed when a collector opens the Collections workbench, refreshes a customer or site profile, or runs a collections-related concurrent program that needs days-late, DSO, or credit-exposure values. Because the package is documented as referenced by three other packages, customizations should prefer calling those dependent packages or the underlying public APIs rather than IEX_COLL_IND directly. Implementers extending the package should note the performance-oriented predicate added under Bug 4949609 restricting payment schedules to status 'OP', and the simplified numeric-to-character conversion introduced under Bug 5247669, both of which affect return formatting and query cost. Testing should account for the twelve-month general ledger date window applied by the average days-late calculation.