Search Results arp_rate_adj




Overview
Explore in AI Chat

Overview

ARP_RATE_ADJ is an Oracle Receivables (AR) PL/SQL package owned by the APPS schema that supports the creation and management of foreign-exchange rate adjustments applied against open receivables. In Oracle EBS 12.1.1 and 12.2.2, rate adjustments are used when a customer remits payment in a currency that differs from the invoice currency, or when the exchange rate used at receipt time differs from the rate originally applied to the transaction. The difference, whether a gain or loss, must be recorded as a rate adjustment so that the receivables balances and associated accounting entries remain accurate. ARP_RATE_ADJ encapsulates the business logic that builds, validates, and posts these adjustments, shielding callers from the underlying table-level manipulation of AR_RATE_ADJUSTMENTS and related cash receipt and distribution records.

Key Procedures and Functions

The ETRM documentation for this package lists a single public procedure, MAIN. Although the documented metadata does not enumerate parameter lists, the presence of a main entry point indicates that the package is designed to be invoked as a self-contained unit of work rather than through a broad set of individually called APIs. MAIN is the procedure that drives the rate adjustment process: it evaluates the input context supplied by the caller, determines whether an adjustment is required, constructs the adjustment records, and commits the resulting entries. Because ETRM classifies this package as OTHER rather than a formal public API, it is best regarded as an internal implementation package whose logic is reached indirectly through higher-level Receivables programs and forms rather than being called directly by integrators.

Tables Accessed

The package reads and writes a wide set of Receivables tables, reflecting its role at the intersection of cash receipts, receivable applications, and accounting distributions. It references AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, and AR_CASH_RECEIPT_HISTORY_ALL to obtain receipt and remittance information and to record status history. AR_PAYMENT_SCHEDULES and AR_RECEIVABLE_APPLICATIONS provide the open receivable balances and the applied amounts that determine whether a rate adjustment is needed. AR_RATE_ADJUSTMENTS is the primary write target, holding the generated adjustment records themselves. AR_DISTRIBUTIONS, AR_MISC_CASH_DISTRIBUTIONS, and AR_RECEIVABLES_TRX supply the accounting and transaction classification data necessary to create balanced distribution lines. Reference data is drawn from AR_RECEIPT_METHODS, AR_RECEIPT_METHOD_ACCOUNTS, AR_SYSTEM_PARAMETERS, HZ_CUST_ACCT_SITES, and RA_CUSTOMER_TRX to resolve receipt method accounting, system-level defaults, customer site information, and transaction details. The global temporary table AR_LINE_APP_DETAIL_GT is used for intermediate processing of application detail lines.

Usage Notes

ARP_RATE_ADJ is an internal dependency rather than a documented public API. The ETRM metadata records that it is referenced by two other packages, ARP_CASHBOOK and ARP_PROC_RCT_UTIL, both of which are central to Receivables cash processing. This dependency pattern indicates that rate adjustment logic is triggered automatically during standard Receivables cash receipt workflows, such as receipt application and remittance processing, rather than through direct invocation. The package also references itself, consistent with internal recursion or helper logic within the same package body. Because the ETRM classification is OTHER and the documented procedure surface is limited to MAIN, customizations and integrations should not call ARP_RATE_ADJ directly; instead, they should invoke the supported Receivables APIs (such as AR_RECEIPT_API_PUB) that in turn reach this package. Any direct dependency on ARP_RATE_ADJ risks breakage during patching or upgrade, since the package is not part of Oracle's published API contract.