Search Results get_true_dso

Overview

IEX_COLL_IND_PUB is a public PL/SQL package owned by APPS in Oracle EBS Releases 12.1.1 and 12.2.2. It belongs to the IEX product (Advanced Collections) and is classified as a PUB API, meaning it is intended for supported external invocation rather than private internal use. The package header uses AUTHID CURRENT_USER, so it executes with the privileges of the calling schema and relies on APPS synonyms for access to underlying dictionary and transaction tables.

Functionally, IEX_COLL_IND_PUB exposes a set of metric calculation routines for collections and credit analysis. The declared purpose of the package is to serve as a "Public API for Metric functions." These metrics summarize customer credit exposure, payment behavior, and receivables aging, and are consumed by Collections workbench logic, dashboards, and reporting components. The package is marked active and compatibility level S (supported), confirming it is a sanctioned integration point for releases 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes seven documented functions. Each returns a VARCHAR2 result. With the exception of GET_COMMON, the functions share a common parameter signature addressing the customer hierarchy: party ID, customer account ID, customer site use ID, and operating unit (org ID).

• GET_CREDIT_LIMIT — Retrieves the credit limit applicable to the specified party, customer account, and site use within the given operating unit.
• GET_WTD_DAYS_TERMS — Returns the weighted days terms metric, expressing payment terms in weighted-day form for the identified customer context.
• GET_WTD_DAYS_LATE — Returns the weighted days late metric, quantifying the average lateness of customer payments weighted by transaction amounts.
• GET_TRUE_DSO — Calculates the "real value" of Days Sales Outstanding, a true DSO measure rather than a simple arithmetic average, as stated in the package header comments.
• GET_SALES — Provides the sales metric for the customer context; this is the function the user searched for under the term "get_sales." It supplies the sales figure used as an input denominator in DSO and related collections calculations.
• COMP_TOT_REC — Computes total receivables, aggregating open receivable balances for the specified customer hierarchy and operating unit.
• GET_COMMON — A shared helper function supplying common metric logic used across the other computations.

Tables Accessed

The package reads data through APPS synonyms from the following documented tables:

• AR_PAYMENT_SCHEDULES — The primary receivables transaction and installment table, supplying open balances, due dates, and payment history for DSO, days late, and total receivables calculations.
• AR_CMGT_SETUP_OPTIONS — Collections setup options that govern how credit and collections metrics are configured and computed.
• AR_SYSTEM_PARAMETERS — Receivables system parameters, including operating unit context and currency/calendar defaults.
• HZ_CUST_ACCOUNTS — The customer account registry, used to resolve the party, account, and site use identifiers supplied as parameters.
• HZ_CUSTOMER_PROFILES — Customer profile definitions that drive credit and collections behavior.
• HZ_CUST_PROFILE_AMTS — Profile amount rows providing credit limit values and related monetary thresholds.
• FND_CURRENCIES — Currency definitions used for formatting and currency-aware metric output.

Usage Notes

IEX_COLL_IND_PUB is not referenced by any other documented package (referenced by 0 packages), indicating its role as a top-level API invoked by forms, concurrent programs, or custom extensions rather than by internal package chaining. Typical invocation patterns include Advanced Collections workbench forms that display credit limits, DSO, and days-late indicators; collections dashboards and custom reports that call GET_TRUE_DSO, GET_SALES, or COMP_TOT_REC; and customer-facing extensions that require weighted terms or late-payment statistics. GET_SALES is commonly called as a supporting metric for DSO calculations and for period sales reporting at a customer site.

Because all functions return VARCHAR2, callers must handle numeric conversion and locale/currency formatting in the calling layer. The AUTHID CURRENT_USER declaration means grants must be in place for the invoking schema on the underlying AR and HZ objects. As a supported public API, IEX_COLL_IND_PUB is the recommended integration point for these metrics in both 12.1.1 and 12.2.2, in preference to querying the underlying tables directly.