Search Results ar_ra_selected_trx_v




Overview
Explore in AI Chat

Overview

AR_RA_SELECTED_TRX_V is an APPS-owned database view in the Oracle E-Business Suite Receivables (AR) module. Per the ETRM record, its documented description is marked "(Release 11.5 Only)," and the view text carries the embedded purpose comment that it "IS USED IN THE APPLICATIONS WINDOW IN RECEIPT WORKBENCH." In practice, the view denormalizes the relationship between a cash receipt (or receipt application) and the transaction, payment schedule, customer, and lookup information needed to render applied-transaction detail in the Receipts Workbench form. It is a reporting and form-support construct rather than a transactional table: it exposes receipt application facts joined to receivable transaction attributes, including amounts applied, discount amounts, and remaining balances.

Although the metadata indicates a Release 11.5 origin, installations on 12.1.1 and 12.2.2 may still retain an object of this name, while the current Receivables UI generally relies on alternate or successor views. Consult the actual object definition in the target instance before depending on it. The column DISCOUNTS_UNEARNED — the term in the user's search — is present directly in the view text, which is why this object is returned for that query.

Underlying Base Objects

The documented referenced objects for the 12.2.2 ETRM record are:

The view is therefore a multi-table join centered on AR_RECEIVABLE_APPLICATIONS and AR_PAYMENT_SCHEDULES, enriched with receipt, transaction, customer, and lookup attributes.

Key Columns

Note that the view exposes both an application-level discount figure (DISCOUNT, combining earned and unearned taken) and the schedule-level DISCOUNTS_UNEARNED column, so the two should not be treated as interchangeable when reconciling discount balances.

Common Use Cases and Queries

Typical uses include receipt workbench–style reporting, applied-transaction detail extracts, and reconciliation of discount taken (earned versus unearned).

  • Applied receipt detail: 
    SELECT receipt_number, trx_number, installment,
       amount_applied, discounts_earned, discounts_unearned,
       amount_due_remaining, apply_date, gl_date
  FROM apps.ar_ra_selected_trx_v
 WHERE cash_receipt_id = :p_receipt_id;
  • Unearned discount by customer: 
    SELECT customer_number, customer_name, trx_number,
       discounts_earned, discounts_unearned
  FROM apps.ar_ra_selected_trx_v
 WHERE discounts_unearned > 0
   AND customer_id = :p_customer_id;
  • Days late on applied transactions: 
    SELECT trx_number, due_date, apply_date, days_late, amount_applied
  FROM apps.ar_ra_selected_trx_v
 WHERE days_late > 0
 ORDER BY days_late DESC;

Because the object may be Release 11.5–era in origin, verify its status in each 12.1.1 / 12.2.2 instance and confirm whether the Receivables UI now sources the same data from an alternative view before building dependent reports.