Search Results ar_payments_interface




Overview
Explore in AI Chat

Overview

APPS.AR_CC_LOCKBOX is a private Oracle Receivables package body that supports the processing of credit card lockbox transactions and postbatch receipts. Its primary business function is to perform the currency conversion calculations required when receipts are applied across differing currencies — specifically, cross-currency receipts and lockbox/postbatch enhancements introduced beyond Release 11. The package derives the rate applied to an "Amount Applied" so that the resulting "Allocated Receipt Amount" reconciles correctly, and it validates the supporting accounting context (customer accounts, transaction types, currencies) required to build payment interface records. It is a supporting utility rather than a public API; the source header and comments cite internal bug fixes (for example, bug 2670619 and bug 44509019, the latter adding the NOCOPY hint to silence compiler warnings).

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • CALC_CROSS_RATE — Populates the "Rate" item used in cross-currency receipts. The rate is derived once both the Amount Applied and the Allocated Receipt Amount have been entered, computed as Allocated Receipt Amount divided by Amount Applied. It is the multiplier applied to the Amount Applied to reach the Allocated Receipt Amount. The procedure was largely copied from the corresponding GUI application form and expanded for cross-currency lockbox/postbatch processing. It uses a defaulting algorithm that seeks the smallest possible rate satisfying rounded(amount_applied * trans_to_receipt_rate) = rounded(allocated_receipt_amount).
  • CALC_AMT_APPLIED_FROM — Derives the Amount Applied From value from a formatted amount, using the currency code, the amount applied, and the transaction-to-receipt rate. It reads from AR_PAYMENTS_INTERFACE columns (amount_applied1, trans_to_receipt_rate1, amount_applied_from1) via the %TYPE anchored declarations.
  • CALC_AMT_APPLIED — The inverse conversion: derives the Amount Applied from the invoice currency code, the Amount Applied From, the transaction-to-receipt rate, and the formatted amount.
  • POPULATE_ADD_INV_DETAILS — Populates additional invoice detail information needed to complete the payment interface rows for lockbox and postbatch processing.
  • ARE_VALUES_VALID — Performs validity checking on the values supplied for the receipt/payment interface, ensuring the referenced accounts, currencies, and transaction types are consistent before the record is accepted.

Tables Accessed

The package operates against the following tables (referenced through APPS synonyms):

  • AR_PAYMENTS_INTERFACE — The primary staging table for receipt/payment records; the package reads and writes Amount Applied, Amount Applied From, and the transaction-to-receipt rate. The %TYPE anchors in the specification confirm this dependency.
  • AR_LOCKBOXES — Supplies lockbox configuration defining the transmission and formatting rules governing the batch.
  • AR_PAYMENT_SCHEDULES — Provides instalment/application context for the receipts being processed.
  • RA_CUST_TRX_TYPES — Validates the transaction type used when deriving invoice detail and applied amounts.
  • HZ_CUST_ACCOUNTS / HZ_CUST_ACCT_RELATE — Used to resolve and validate customer accounts and their relationships.
  • FND_CURRENCIES — Currency validation for cross-currency rate calculation and amount rounding.
  • DUAL — Utility queries, such as rounding or rate derivation helpers.

Usage Notes

AR_CC_LOCKBOX is an internal, non-public package (API classification OTHER) invoked by Oracle Receivables lockbox and postbatch processing logic rather than by customer code directly. It is referenced by one other package, which orchestrates the lockbox receipt load. The procedures execute during cross-currency receipt creation, where GUI-equivalent rate defaulting and amount conversion must be replicated in a batch context, and during validation of payment interface data prior to insertion into AR_PAYMENTS_INTERFACE. Because it is an internal package body, custom development should not call it directly; the supported entry points remain the documented Receivables APIs and concurrent lockbox programs in both EBS 12.1.1 and 12.2.2.