Search Results ar_remitted_receipts_format_v




Overview
Explore in AI Chat

Overview

The AR_REMITTED_RECEIPTS_FORMAT_V view is an Oracle Receivables (AR) reporting object owned by the APPS schema. As its description states, it "holds general information of remitted receipts being formatted for reporting purpose." In practical terms, the view assembles the data elements required to render a remittance or deposit report — the receipt header, customer identity, receipt method, remittance bank, and batch information — into a single denormalized result set. It is a reporting convenience view rather than a transactional entity; it exposes no columns that are not already derivable from its base tables.

The view is relevant in both Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 the object remains VALID and is defined over the multi-org and subledger accounting infrastructure (MO_GLOBAL, XTR_USER_ACCESS, FND_GLOBAL), meaning its results are subject to the standard operating unit and security context established at runtime. Reports and concurrent programs that consume this view therefore rely on the caller's FND_GLOBAL session context being correctly initialized.

Underlying Base Objects

The view joins a substantial set of AR and shared Receivables/IBY objects. The principal base objects, as documented in ETRM 12.2.2, include:

Several columns (CUSTOMER_BANK_NAME, CUSTOMER_BANK_BRANCH_NAME, CUSTOMER_BANK_BRANCH_NUMBER, CUSTOMER_BANK_ACCOUNT_NAME, CUSTOMER_BANK_ACCOUNT_ID) are explicitly defined as NULL placeholders so that downstream report layouts can reference a consistent column structure.

Key Columns

Common Use Cases and Queries

Typical consumers are custom remittance reports, reconciliation extracts, and integration feeds requiring receipt-to-customer-to-bank relationships in one row. Because the view applies batch-level factor logic (REMIT_METHOD_CODE = 'FACTORING' drives the YES/NO lookup branch), it is suited to factoring and standard remittance reporting alike.

A simple filtered query:

  • SELECT RECEIPT_NUMBER, CURRENCY_CODE, AMOUNT, RECEIPT_DATE, REMIT_BANK_NAME, REMIT_BANK_ACCOUNT_NUMBER, BATCH_NAME, BATCH_DATE FROM AR_REMITTED_RECEIPTS_FORMAT_V WHERE RECEIPT_DATE BETWEEN :p_from AND :p_to;
  • SELECT CUST_ACCOUNT_ID, PARTY_NAME, ACCOUNT_NUMBER, SUM(AMOUNT) FROM AR_REMITTED_RECEIPTS_FORMAT_V GROUP BY CUST_ACCOUNT_ID, PARTY_NAME, ACCOUNT_NUMBER;
  • SELECT CASH_RECEIPT_ID, RECEIPT_NUMBER, BATCH_ID, PAYMENT_CHANNEL_CODE FROM AR_REMITTED_RECEIPTS_FORMAT_V WHERE BATCH_ID = :p_batch_id;

Reports should always initialize the operating unit context (via FND_GLOBAL / MO_GLOBAL) before querying, and should not assume the NULL placeholder customer bank columns carry data.