Search Results test_rollback




Overview
Explore in AI Chat

Overview

The APPS.ARP_PROCESS_BR_REMIT package is a valid, Oracle-owned PL/SQL package in the Oracle E-Business Suite Receivables (AR) module. It supports the "BR Remit" (Bank Risk Remittance) processing flow, which handles the association and disposition of bank risk records against remittance batches. In practice, this package is the programmatic engine behind the concurrent program ARP_PROGRAM_BR_REMIT, which drives the automatic creation and maintenance of remittance batches in Receivables.

The package is classified as an "OTHER" API, meaning it is a supporting internal processing package rather than a public open interface. It is referenced by only one other package in the dependency graph (itself, via the body and the driver program), indicating a tightly scoped, purpose-built utility. All executable logic resides in the package specification and body owned by APPS; the object is not invalid.

Key Procedures and Functions

ETRM documents 11 named program units. Their intended roles are:

  • CREATE_REMIT_BATCH – Creates a new remittance batch record, establishing the batch header used to group bank risk items for remittance processing.
  • SELECT_AND_ASSIGN_BR_TO_REMIT – Performs a combined selection and assignment operation, identifying eligible bank risk records and applying them to the remittance batch.
  • ASSIGN_BR_TO_REMIT – Assigns a specific bank risk record to an existing remittance batch.
  • ADD_OR_RM_BR_TO_REMIT – Adds or removes a bank risk record from a remittance batch, supporting both directions of the assignment relationship.
  • CONSTRUCT_SELECT_BR_FOR_REMIT – Constructs the selection criteria (query logic) used to identify which bank risk records qualify for remittance.
  • VALIDATE_BR_SEARCH_CRITERIA – Validates user- or program-supplied search criteria before selection executes, preventing invalid input from reaching the query stage.
  • CREATE_REMIT_BATCH_CONC_REQ – Concurrent-request entry point for creating remittance batches in batch mode.
  • MAINTAIN_REMIT_BATCH_CONC_REQ – Concurrent-request entry point for maintaining existing remittance batches.
  • UPDATE_BATCH_STATUS – Updates the status of a remittance batch as processing progresses.
  • TEST_ROLLBACK – A diagnostic/test utility that rolls back changes, used for validation without persisting data.
  • REVISION – Returns the package revision/version identifier for support and patching purposes.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • AR_BATCHES – The core batch table; records the remittance batch header and drives UPDATE_BATCH_STATUS.
  • AR_PAYMENT_SCHEDULES – Provides the transaction and installment detail for bank risk items being remitted.
  • HZ_CUST_ACCOUNTS – Supplies customer/party information associated with the remitted items.
  • RA_CUST_TRX_TYPES – Identifies transaction types relevant to the selection criteria.
  • AR_SYSTEM_PARAMETERS – Supplies system-level defaults and settings used during batch creation.
  • AR_TRANSACTION_HISTORY – Records transaction history events generated by remittance processing.
  • CE_BANK_BRANCHES_V – The bank branch view used to resolve branch-level remittance data.

Usage Notes

ARP_PROCESS_BR_REMIT is not normally called directly by end users. It is invoked by the seeded concurrent program ARP_PROGRAM_BR_REMIT and, in customizations, by PL/SQL routines that need to create or maintain remittance batches. Standard forms-based flows trigger it indirectly through the concurrent request entry points CREATE_REMIT_BATCH_CONC_REQ and MAINTAIN_REMIT_BATCH_CONC_REQ. Because it is classified as an "OTHER" API, customers and integrators should treat it as an internal package: calling individual procedures outside the supported concurrent program framework may bypass validation and status controls. It is available and valid on both 12.1.1 and 12.2.2, with no documented behavioral difference between the two releases in the ETRM metadata.