Search Results arp_util




Overview
Explore in AI Chat

Overview

ARP_UTIL is a foundational utility package in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema and documented as a UTIL-class API. Its principal purpose is to centralize the low-level calculations, validations, and formatting operations shared across the Receivables subledger. Rather than implementing a single business transaction such as invoice creation or receipt application, ARP_UTIL provides the reusable plumbing on which higher-level Receivables APIs depend. The package is deeply embedded in the application stack: it references 221 other database objects that depend on it, and it is itself referenced only by other code, not by any external consumer. This asymmetry confirms its role as an internal service layer. Its responsibilities span functional currency rounding, accounted amount derivation, foreign exchange conversion, General Ledger date validation and defaulting, descriptive flexfield validation, and standardized debugging output. The package also exposes helpers for resolving identifiers and querying server patch levels, which other Receivables programs use for diagnostic and version-aware logic.

Key Procedures and Functions

The documented interface comprises 34 procedures and functions. The debug family is represented by ENABLE_DEBUG, DISABLE_DEBUG, and DEBUG, with PRINT_FCN_LABEL and PRINT_FCN_LABEL2 supporting consistent, readable trace output. Currency and amount processing is handled by FUNCTIONAL_AMOUNT, FUNC_AMOUNT, CALC_DYNAMIC_AMOUNT, CURRROUND, CALC_ACCTD_AMOUNT, CALC_ACCOUNTED_AMOUNT, and CALC_ACCTD_AMOUNT_TEST. These routines compute and round amounts in functional currency and derive accounted amounts according to conversion rules. SET_BUCKETS organizes amounts into defined reporting or aging buckets. GL date handling is provided by VALIDATE_AND_DEFAULT_GL_DATE, IS_GL_DATE_VALID, and VALIDATE_GL_DATE, which verify that a date falls within an open accounting period and supply a default when none is given. VALIDATE_DESC_FLEXFIELD validates descriptive flexfield segments, typically delegating to FND_FLEX_DESCVAL. GET_ID resolves an identifier for downstream processing, while AR_SERVER_PATCH_LEVEL reports the applied patch level for version-aware logic and CLOSE_CURSOR manages cursor lifecycle cleanup. Collectively these routines standardize arithmetic, date, and validation behavior across Receivables code paths.

Tables Accessed

ARP_UTIL references a broad cross-section of Receivables and shared tables through APPS synonyms. AR_SYSTEM_PARAMETERS and AR_SYSTEM_PARAMETERS_ALL supply operating unit and system-level Receivables settings. FND_CURRENCIES provides currency definitions, while GL_DAILY_CONVERSION_TYPES supplies exchange rate types used in accounted amount derivation. Customer and party data are read from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_CUSTOMER_PROFILES. Banking and receipt-related information is drawn from AR_RECEIPT_METHODS, CE_BANK_ACCOUNTS, and IBY_EXT_BANK_ACCOUNTS. Transaction data is accessed through RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and the RA_INTERFACE_LINES_GT global temporary table used during interface processing. FND_DESCRIPTIVE_FLEXS supports flexfield metadata resolution, and FND_PRODUCT_INSTALLATIONS underpins patch-level and installation queries. These reads allow the utility routines to apply context-appropriate defaults and validations.

Usage Notes

ARP_UTIL is not exposed as an end-user feature. It is invoked programmatically by standard Receivables forms, concurrent programs, and other Receivables PL/SQL packages that require consistent currency rounding, GL date validation, or flexfield checking. Because it is referenced by more than 221 database objects, changes to its behavior can propagate widely; its procedures must therefore be treated as a shared contract. Customizations should avoid modifying ARP_UTIL directly and should instead call its documented routines, relying on the debug procedures for tracing and on AR_SERVER_PATCH_LEVEL where version-dependent behavior must be detected. The package is valid in both Oracle EBS 12.1.1 and 12.2.2.