Search Results iex_coll_ind




Overview
Explore in AI Chat

Overview

IEX_COLL_IND is an Oracle EBS Advanced Collections (IEX) PL/SQL package that exposes a set of indicator and metric calculation routines used to quantify a customer's collection performance and credit exposure. The package is owned by APPS and is declared AUTHID CURRENT_USER, meaning its unqualified references to database objects resolve against the calling schema's privileges rather than the definer's. This design supports invocation from forms, concurrent programs, and other PL/SQL units that operate under a session whose security context already grants access to the underlying AR and HZ objects.

Functionally, the package computes collection indicators such as weighted days late, average days late, Days Sales Outstanding (DSO) variants, non-sufficient-funds and stop-payment statistics, sales and deduction totals, and aggregate receivables balances. These indicators feed collection scorecards, customer profile evaluations, and collector worksheets. The header comment notes that the system parameter record can be modified based on the information required, indicating the package is designed to adapt its currency and date-basis context at runtime. The package header is versioned 120.2 dated September 2011, placing it in the shared lineage used across EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface comprises 32 routines. The most prominent are the indicator functions, all of which share a consistent customer-context addressing scheme driven by the p_party_id, p_cust_account_id, and p_customer_site_use_id parameters:

The routines are declared in the package specification with p_party_id, p_cust_account_id, and p_customer_site_use_id as the standard parameter triad, and each returns VARCHAR2. The record type curr_rec_type and global g_curr_rec carry set of books, base currency, precision, minimum accountable unit, and past-year-from/to dates, providing the currency and period context for the calculations.

Tables Accessed

The package reads from AR system and transaction tables and from HZ customer tables through APPS synonyms:

Usage Notes

IEX_COLL_IND is referenced by three other packages, indicating it functions as a shared indicator library within the Advanced Collections dependency tree rather than as an entry-point API. It is typically invoked from Advanced Collections forms, collector worksheets, and scorecard logic, and may be called from concurrent programs and custom code that require standardized collection metrics for a given party, customer account, and site use context.

Because the addressing parameters are p_party_id, p_cust_account_id, and p_customer_site_use_id, callers searching on p_party_id should note that this parameter identifies the party (TCA party), while the customer account and site use identifiers refine the calculation scope. The functions return VARCHAR2 values and therefore require careful numeric conversion by the caller. Callers should supply a consistent customer context across the three parameters; passing null or mismatched values may yield context-spanning or partial results. The routines perform read-only aggregation against AR and HZ data.