Search Results add_or_rm_br_to_remit

Overview

ARP_PROCESS_BR_REMIT is a public PL/SQL package in the Oracle Receivables (AR) module of Oracle E-Business Suite, delivered under the APPS schema. It supports the Bills Receivable remittance process, which is the mechanism by which accepted bills receivable are grouped into a remittance batch and submitted to a bank for collection or discounting. The package header comment identifies it as the component invoked during the Create Bills Receivable Remittance process, where it automatically creates a remittance batch and associates eligible bills receivable with that batch. The package is classified as OTHER in the ETRM repository, meaning it is not a fully public, externally supported API in the manner of the AR Transaction APIs, but it is nonetheless referenced by one other package and is callable from concurrent processing and custom extension code.

Key Procedures and Functions

The package exposes eleven documented procedures and functions. The core remittance workflow is handled by the following:

• CREATE_REMIT_BATCH — Creates a remittance batch record, accepting batch date, GL date, currency, comments, and descriptive flexfield attribute values for the new batch.
• SELECT_AND_ASSIGN_BR_TO_REMIT — Identifies bills receivable matching remittance selection criteria and assigns them to the remittance batch in a single operation.
• ASSIGN_BR_TO_REMIT — Assigns specified bills receivable to an existing remittance batch.
• ADD_OR_RM_BR_TO_REMIT — Adds or removes bills receivable from a remittance batch. This is the procedure most commonly located by the search term "add_or_rm_br_to_remit" and represents the incremental maintenance entry point for batch membership.
• CONSTRUCT_SELECT_BR_FOR_REMIT — Builds the selection logic used to determine which bills receivable are eligible for remittance.
• VALIDATE_BR_SEARCH_CRITERIA — Validates the search criteria supplied for bill receivable selection before processing.

The remaining procedures support batch lifecycle and operational handling: CREATE_REMIT_BATCH_CONC_REQ and MAINTAIN_REMIT_BATCH_CONC_REQ submit and maintain concurrent requests for remittance processing; UPDATE_BATCH_STATUS advances the batch through its status transitions; TEST_ROLLBACK provides rollback testing support; and REVISION returns the package version string.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• AR_BATCHES — Stores the remittance batch header, including batch date, GL date, currency, comments, and flexfield attributes.
• AR_PAYMENT_SCHEDULES — Holds bill receivable and payment schedule rows selected and assigned to the remittance batch.
• HZ_CUST_ACCOUNTS — Supplies customer information used when validating and selecting bills receivable.
• RA_CUST_TRX_TYPES — Identifies the bill receivable transaction type used in selection criteria.
• AR_SYSTEM_PARAMETERS — Provides Receivables system setup values that govern remittance processing behavior.
• AR_TRANSACTION_HISTORY — Records transaction history entries generated as bills receivable move through the remittance process.

Usage Notes

ARP_PROCESS_BR_REMIT is invoked primarily from the Bills Receivable remittance workflow in Oracle Receivables, both from the Receivables forms interface and from concurrent programs such as Create Bills Receivable Remittance. Custom code that programmatically builds or modifies remittance batches should call CREATE_REMIT_BATCH to establish the batch and then ADD_OR_RM_BR_TO_REMIT to add or remove individual bills receivable, relying on the package's validation logic rather than direct DML against AR_BATCHES and AR_PAYMENT_SCHEDULES. Because the package is classified as OTHER, implementations should treat its signatures as subject to change across patch levels and revalidate custom calls after upgrades between 12.1.1 and 12.2.2. The presence of the PG_DEBUG profile check indicates the package honors the AFLOG_ENABLED profile for diagnostic logging.