Search Results last_promise_due_date




Overview
Explore in AI Chat

Overview

APPS.ARFV_AR_PAYMENT_SCHEDULES is an Oracle E-Business Suite view in the Receivables (AR) module that presents payment schedule information in a reporting- and integration-friendly format. It is defined over AR_PAYMENT_SCHEDULES and a set of related master and transactional tables, and it resolves foreign key identifiers into descriptive values while decoding lookup-coded columns into their human-readable meanings. In the context of EBS 12.1.1 and 12.2.2, the view serves as the primary source for reporting on amounts due, due dates, discounts, disputes, dunning, collections, and the linkage between invoices, receipts, customers, parties, currencies, terms, collectors, and operating units.

The view is particularly relevant to searches involving "reserve," "payment," and "attribute" terminology, because AR_PAYMENT_SCHEDULES is the table that stores the reserve amounts, due-date schedules, and status attributes of each transaction line. ARFV_AR_PAYMENT_SCHEDULES exposes those attributes alongside their decoded meanings, making it suitable for both ad hoc queries and downstream integrations.

Underlying Base Objects

According to the ETRM metadata, the view is defined over the following documented objects: AR_PAYMENT_SCHEDULES, AR_CASH_RECEIPTS, AR_COLLECTORS, AR_CONS_INV, FND_CURRENCIES_VL, HR_ALL_ORGANIZATION_UNITS, HZ_CUST_ACCOUNTS, HZ_PARTIES, RA_CUSTOMER_TRX, and RA_TERMS. Most of these are accessed through public synonyms in the APPS schema, while FND_CURRENCIES_VL is a view providing currency descriptions.

The driving table is AR_PAYMENT_SCHEDULES (aliased PS), which holds one row per payment schedule installment for a transaction. It is outer-joined to AR_CONS_INV (consolidated billing), AR_COLLECTORS, and other supporting entities, and inner-joined where a required reference exists, such as INVOICE_CURRENCY_CODE to FND_CURRENCIES_VL. RA_CUSTOMER_TRX supplies the transaction number, RA_TERMS the payment terms name, HZ_PARTIES the party name, and HR_ALL_ORGANIZATION_UNITS the operating unit. AR_CASH_RECEIPTS supplies the receipt number when a schedule has been settled by a receipt, and HZ_CUST_ACCOUNTS links the customer account.

Key Columns

Common Use Cases and Queries

Typical scenarios include open receivables aging, due-date analysis, dispute reporting, collections follow-up, and reconciliation of scheduled amounts to receipts and invoices. A representative query retrieves open schedules with decoded statuses and party names:

  • SELECT payment_schedule_id, trx_number, due_date, status, amount_due_remaining, party_name, receipt_number FROM ap_fv_ar_payment_schedules WHERE amount_due_remaining > 0 ORDER BY due_date;

For reserve and attribute analysis, filter by CLASS and STATUS to isolate invoice versus credit memo schedules and to identify rows excluded from dunning. Because the view exposes both coded values and their meanings, it can be used directly in BI Publisher reports, OBIEE models, and ETL mappings without additional lookup joins.