Search Results update_remit

Overview

ARP_BR_REMIT_BATCHES is an Oracle EBS Accounts Receivables package owned by the APPS schema. It supports the processing of bills receivable remittance batches, providing the internal logic that links remittance batch records to the underlying cash receipts and receipt history. In EBS 12.1.1 and 12.2.2, bills receivable remittance involves grouping negotiated or discounted bills receivable into remittance batches, then creating and maintaining the associated receipt entries as the batch progresses through its lifecycle. ARP_BR_REMIT_BATCHES encapsulates the create, update, lock, cancel, and delete operations performed against these remittance records, and is classified in the ETRM metadata as an OTHER API rather than a published public API. It is therefore primarily an internal package consumed by higher-level remittance processing and public API layers, though it is valid and callable from custom code with appropriate care.

Key Procedures and Functions

The documented package exposes seven procedures and functions. Their purposes are as follows:

• INSERT_REMIT — Creates a new bills receivable remittance record, establishing the association between the remittance batch and the related receipt data.
• UPDATE_REMIT — Modifies an existing remittance record to reflect changes in batch or receipt attributes.
• LOCK_REMIT — Acquires the necessary lock on a remittance record to prevent concurrent modification during processing.
• CANCEL_REMIT — Reverses or cancels a remittance record when the underlying remittance is no longer to be processed.
• UPDATE_BR_REMIT_BATCH_TO_CRH — Synchronizes remittance batch information to the cash receipt history, keeping receipt history aligned with the remittance batch state.
• DELETE_REMIT — Removes a remittance record that is no longer required.
• REVISION — Returns the package revision identifier, used for version identification and diagnostic purposes.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect only the documented procedure names and their evident roles.

Tables Accessed

The package interacts with a defined set of AR and CE tables through APPS synonyms, including AR_BATCHES, AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_BATCH_SOURCES, AR_PAYMENT_SCHEDULES, AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, AR_TRANSACTION_HISTORY, CE_BANK_ACCOUNTS, and AP_PAYMENT_PROGRAMS. The AR_BATCHES and AR_BATCH_SOURCES tables hold the batch definitions and their sources, while AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY store the receipt and receipt history records that the remittance batch generates or updates. AR_PAYMENT_SCHEDULES and AR_TRANSACTION_HISTORY provide the underlying bill and transaction detail. AR_RECEIPT_CLASSES and AR_RECEIPT_METHODS supply receipt classification and method validation. CE_BANK_ACCOUNTS and AP_PAYMENT_PROGRAMS supply banking and payment program context used during remittance processing. APPS.ARP_BR_REMIT_BATCHES also references FND_API and the STANDARD package.

Usage Notes

ARP_BR_REMIT_BATCHES is not intended for direct application use in the same manner as a public API such as AR_BR_REMIT_IMPORT_API_PUB. It is referenced by several other packages, including ARP_BR_HOUSEKEEPER_PKG, ARP_PROCESS_BR_REMIT, ARP_PROGRAM_BR_REMIT, AR_BILLS_MAINTAIN_LIB_PVT, and AR_BR_REMIT_IMPORT_API_PUB, which indicates that it is invoked during bill receivable remittance import, processing, and housekeeping routines, and typically in the context of concurrent programs and forms-based remittance workflows. Because it is classified as OTHER in the ETRM metadata, custom code that calls these procedures directly assumes responsibility for transaction control, validation, and correct ordering, and should generally prefer the public wrapper APIs where available. The REVISION function can be used to confirm the installed package version, which is useful when diagnosing behavior differences between EBS 12.1.1 and 12.2.2 environments.