Search Results receipt_batch_name




Overview
Explore in AI Chat

Overview

APPS.AR_RX_OTHER_APPLICATIONS_V is a reporting view in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and registered under FND Design Data as AR.AR_RX_OTHER_APPLICATIONS_V. Its current status is VALID. The view is classified as "Internal" by Oracle, meaning that Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. Despite this restriction, the view is widely referenced in custom reporting, since it exposes a denormalized, read-only projection of receipt application activity in the Receivables subledger.

The view presents one row per receivable application against a customer receipt, together with the associated receipt, customer, bank, batch, and accounting context. Because it joins receipt header, application, payment schedule, customer, and bank data, it is particularly useful for reconciliation, cash application analysis, and subledger-to-GL reporting. The user search term "receipt_batch_name" maps directly to the RECEIPT_BATCH_NAME column exposed by this view, which returns the batch name for the receipt associated with the application.

Underlying Base Objects

The view is defined over a substantial set of base objects, as documented in the ETRM 12.2.2 metadata. Core Receivables tables and synonyms include AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_RECEIVABLE_APPLICATIONS, AR_PAYMENT_SCHEDULES, AR_RECEIPT_METHODS, AR_RECEIVABLES_TRX, AR_BATCHES, AR_BATCH_SOURCES, and AR_SYSTEM_PARAMETERS. Customer and party data is sourced from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, and HZ_PARTIES. Bank and branch information comes from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES, and CE_BANK_BRANCHES_V. Accounting flexfield and set of books data is derived from GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS. Additional supporting objects include FND_GLOBAL, FND_PROFILE, FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, FA_RX_FLEX_PKG, ARPT_SQL_FUNC_UTIL, ARP_PROCESS_WRITEOFF, and XTR_USER_ACCESS, which supply profile values, organizational access, flexfield resolution, multi-org security, and receipt-related utility logic.

Key Columns

The view exposes a broad set of columns spanning receipt, application, customer, bank, and accounting dimensions. Notable columns include:

Common Use Cases and Queries

Typical uses include cash application reporting, receipt-to-invoice reconciliation, batch-level analysis, and bank deposit reporting. The following example retrieves applications by receipt batch name:

  • SELECT receipt_number, receipt_batch_name, customer_name, application_type, amount_applied, apply_date FROM apps.ar_rx_other_applications_v WHERE receipt_batch_name = :batch_name;
  • SELECT batch_name, batch_source, COUNT(*), SUM(amount_applied) FROM apps.ar_rx_other_applications_v GROUP BY batch_name, batch_source;

Because the view is flagged internal, consumers should treat it as read-only and validate against Oracle-supported alternatives where possible.