Search Results arp_br_remit_function




Overview
Explore in AI Chat

Overview

ARP_BR_REMIT_FUNCTION is an Oracle Applications (APPS) schema PL/SQL package that supports the Brazilian localization of Oracle Receivables (AR). Its name reflects its role as a remittance-related function library within the AR Brazil (ARP_BR) module set. In Oracle EBS 12.1.1 and 12.2.2, Brazilian remittance processing addresses the country-specific requirements for bank collection documents (boletos), payment remittance files, and the associated receivable adjustments that must be reconciled against customer transactions and bank returns.

The package encapsulates reusable PL/SQL logic that the Brazilian remittance batch view and related components invoke to compute monetary values from receivable transactions. It is classified in the ETRM metadata as an OTHER API, meaning it is not a formally published public API but a supporting internal package. It holds a VALID status in the APPS schema and is documented with three callable program units and a defined set of dependent tables.

Key Procedures and Functions

The metadata documents three program units within the package:

  • GET_AMOUNT — Returns the transaction amount associated with a remittance or receivable record. It supplies the original (entered) monetary value used by Brazilian remittance processing, such as the face value of a boleto or the amount subject to collection.
  • GET_ACCTD_AMOUNT — Returns the accounted amount, that is, the functional-currency equivalent of a transaction after currency conversion. This distinction matters in Brazilian operations where transactions may be entered in a foreign currency but accounted in the ledger currency.
  • REVISION — Exposes a revision or version identifier for the package, supporting change tracking and dependency validation across releases and patches.

Parameter lists are not published in the ETRM excerpt and are intentionally omitted here; consumers should inspect the package specification in the database for exact signatures.

Tables Accessed

The documented dependency list and table references identify the principal data sources:

  • RA_CUSTOMER_TRX — The core Receivables transaction table, supplying invoice and debit memo headers used to derive transaction amounts and currency context.
  • RA_CUSTOMER_TRX lines and distribution data are accessed through AR_DISTRIBUTIONS, which holds the accounting distributions from which accounted amounts are derived.
  • AR_RECEIVABLE_APPLICATIONS — Records the application of receipts and credits against transactions, relevant when determining outstanding or adjusted balances for remittance.
  • AR_TRANSACTION_HISTORY — Captures transactional audit history, used to resolve the current state of a transaction across its lifecycle.

The package is therefore oriented toward reading transaction, distribution, application, and history data rather than maintaining configuration.

Usage Notes

ARP_BR_REMIT_FUNCTION is referenced by the view AR_BR_MAIN_REMIT_BATCH_V, indicating that its functions are called during the selection and presentation of Brazilian remittance batch data. Because a view cannot directly invoke PL/SQL functions in all contexts unless wrapped, the dependency suggests the package supplies calculation logic consumed by the remittance batch query or by the concurrent program that populates remittance output.

Typical invocation paths include the Brazilian remittance concurrent programs and any custom extensions that build bank remittance files. The package is not intended as a standalone end-user API; callers should treat it as an internal helper and verify signatures against the deployed package specification. When upgrading between 12.1.1 and 12.2.2, validate the package status as VALID and confirm that dependent objects such as AR_BR_MAIN_REMIT_BATCH_V recompile successfully.