Search Results arp_etax_util




Overview
Explore in AI Chat

Overview

ARP_ETAX_UTIL is a utility package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and classified as a UTIL-type API within ETRM documentation. Its primary business function is to centralize the shared logic required to calculate, validate, store, and post international and domestic transaction taxes on Receivables documents. It acts as the common tax engine used across a wide range of AR flows, including invoices, credit memos, adjustments, receipts, cashbooks, allocation, and autoinvoice processing.

Because tax rules vary by country, legal entity, tax classification, and customer site, the package encapsulates the reusable routines that determine tax applicability, compute tax amounts, and generate the corresponding tax distribution lines. By isolating this logic, ARP_ETAX_UTIL allows dozens of calling packages to invoke a single, consistent tax calculation path. The package is dependent on ARP_ACCT_MAIN and standard SYS constructs, and it is referenced by at least 21 other AR packages, confirming its role as a foundational dependency in the Receivables tax architecture.

Key Procedures and Functions

The documented interface exposes 21 procedures and functions that fall into several functional groupings.

Tables Accessed

ARP_ETAX_UTIL reads and writes several core AR tables. Transaction tax lines and adjustments are maintained through AR_ADJUSTMENTS, AR_LINE_DIST_INTERFACE_GT, and AR_RECEIVABLE_APPLICATIONS (with its AR_RECEIVABLE_APPLICATIONS_S sequence-based counterpart). Payment and receipt context is drawn from AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, AR_RECEIPT_METHOD_ACCOUNTS, and AR_RECEIVABLES_TRX. Customer and site information comes from HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_SITES, while legal entity and organization context is obtained from HR_ALL_ORGANIZATION_UNITS. System configuration, currency, accounting, and sequencing data are supplied by AR_SYSTEM_PARAMETERS, FND_CURRENCIES, GL_CODE_COMBINATIONS, and FND_DOCUMENT_SEQUENCES.

Usage Notes

This package is not typically invoked directly by end users. Instead, it is called internally by AR transaction, adjustment, receipt, and autoinvoice processing packages, such as ARP_PROCESS_HEADER, ARP_PROCESS_ADJUSTMENT, ARP_RECEIPTS_MAIN, and the ARP_ETAX_* family. Forms and concurrent programs that create or modify Receivables transactions trigger these callers indirectly. Custom extensions that require consistent EBS tax behavior should also call ARP_ETAX_UTIL rather than reimplementing tax logic. Given its broad dependency footprint, changes to this package carry wide impact across Receivables and should be regression tested against invoicing, adjustments, and receipt processing.