Search Results arp_bal_util




Overview
Explore in AI Chat

Overview

ARP_BAL_UTIL is a PL/SQL utility package in the APPS schema of Oracle E-Business Suite Receivables. Its documented classification is UTIL, reflecting its role as a reusable calculation engine rather than a public business API. The package provides the balance computation logic that underpins transaction-level and line-level inquiry in Receivables: it derives open balances for transactions and transaction lines, applies credits and commitments, and rolls usage up to summary levels. Because balances in Receivables are not stored as simple columns but must be derived from payment schedules, adjustments, receivable applications, and distribution rows, ARP_BAL_UTIL centralizes that derivation so that multiple callers produce consistent results. The object is documented as VALID in 12.2.2 and, with 19 dependent packages, is a foundational utility whose removal or modification would cascade broadly across the Receivables module.

Key Procedures and Functions

The ETRM metadata documents eleven callable units. The balance routines form the core:

No parameter lists are documented in the metadata; the descriptions above reflect purpose only.

Tables Accessed

The package operates over the principal Receivables transaction tables through APPS synonyms. RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES, and RA_INTERFACE_LINES supply transaction headers, lines, types, and interface rows; AR_PAYMENT_SCHEDULES supplies the installment-level amounts from which open balances are derived; AR_ADJUSTMENTS and AR_RECEIVABLE_APPLICATIONS record credits, adjustments, and cash applications that reduce balances; AR_DISTRIBUTIONS and RA_CUST_TRX_LINE_GL_DIST hold accounting distributions used when line-level amounts are required; AR_TRANSACTION_HISTORY and AR_ACTIVITY_DETAILS provide the audit trail for LINE_LEVEL_ACTIVITY; HZ_CUST_ACCOUNTS identifies customers; FND_CURRENCIES and GL_SETS_OF_BOOKS support currency and ledger context. DUAL is used for single-row selection.

Usage Notes

ARP_BAL_UTIL is not referenced by any database object, confirming it is a leaf-level utility invoked directly by application code rather than through triggers or views. It is typically called from Receivables forms (such as transaction and account inquiry), from concurrent programs that report balances and aging, and from other PL/SQL packages—19 are documented as dependent. Customizations should call the public units rather than replicating balance logic, because the computation depends on the documented table interactions above. Because it is a utility rather than a business API, it carries no formal API versioning guarantee, and callers should be validated after patching or upgrade. Implementations should also account for differences between 12.1.1 and 12.2.2 in dependent objects and table structures.