Search Results reversed_cash_receipt_id




Overview
Explore in AI Chat

Overview

The PSA_MF_PAYMENT_SCHEDULES_V view is a Public Sector Financials (PSA) reporting object in the APPS schema that consolidates multi-fund receivables payment schedule information. Its documented purpose is to expose "all multi-fund transactions except adjustments and miscellaneous cash receipts," making it a specialized projection of Oracle Receivables payment schedule data restricted to those transactions that participate in the PSA multi-fund accounting model. Because it joins AR payment schedules to PSA-specific balances, transaction distributions, and transaction type definitions, the view serves as a bridge between standard Receivables subledger data and the fund accounting structures maintained by the Public Sector Financials module.

The object is reported as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is defined against a combination of synonyms and PSA-owned views. The column REVERSED_CASH_RECEIPT_ID appears in this view and is directly relevant to users investigating reversed receipts and their linkage to multi-fund payment schedules.

Underlying Base Objects

The view is defined over the following documented base objects:

The join logic links the payment schedule to the PSA balance view by CUST_TRX_LINE_GL_DIST_ID, restricts CUST_TRX_TYPE_ID to values defined in PSA_TRX_TYPES_ALL, and correlates the transaction distribution and GL distribution tables through CUSTOMER_TRX_ID.

Key Columns

  • PAYMENT_SCHEDULE_ID — primary installment identifier from AR_PAYMENT_SCHEDULES_ALL.
  • CUST_TRX_LINE_GL_DIST_ID — links the schedule to the specific GL distribution line used in PSA balancing.
  • AMOUNT_DUE_ORIGINAL / AMOUNT_DUE_REMAINING / AMOUNT_CREDITED / AMOUNT_APPLIED / AMOUNT_ADJUSTED — PSA-sourced balance amounts for the installment.
  • AMOUNT_IN_DISPUTE / AMOUNT_ADJUSTED_PENDING — derived by multiplying the AR payment schedule value by the GL distribution PERCENT factor.
  • STATUS, CLASS, TRX_NUMBER, TRX_DATE, GL_DATE, DUE_DATE — installment and transaction context.
  • CASH_RECEIPT_ID / ASSOCIATED_CASH_RECEIPT_ID / REVERSED_CASH_RECEIPT_ID — receipt linkage columns. REVERSED_CASH_RECEIPT_ID identifies the cash receipt whose application was reversed, which is the attribute commonly searched when tracing reversals affecting multi-fund schedules.
  • ORG_ID — operating unit, essential for multi-org query filtering.
  • MF_RECEIVABLES_CCID — the multi-fund receivables accounting flexfield code combination.
  • ACCTD_AMOUNT_DUE_REMAINING — the remaining amount, aliased from the PSA balance amount due remaining.

Common Use Cases and Queries

Typical uses include reconciling multi-fund receivables balances, tracing receipts applied and reversed against fund-level schedules, and feeding downstream fund accounting or reporting extracts.

To locate payment schedules associated with a reversed cash receipt:

  • SELECT payment_schedule_id, trx_number, cash_receipt_id, reversed_cash_receipt_id, amount_due_remaining, org_id FROM psa_mf_payment_schedules_v WHERE reversed_cash_receipt_id IS NOT NULL AND org_id = :p_org_id;

To review open multi-fund installments by customer:

  • SELECT trx_number, due_date, amount_due_remaining, status, mf_receivables_ccid FROM psa_mf_payment_schedules_v WHERE customer_id = :p_customer_id AND amount_due_remaining > 0 ORDER BY due_date;

Because the view already filters to PSA-defined transaction types and excludes adjustments and miscellaneous cash receipts, it can be queried directly without reapplying those restrictions, though ORG_ID filtering remains advisable in a multi-org environment.