Search Results igsbv_party_refunds




Overview
Explore in AI Chat

Overview

IGSBV_PARTY_REFUNDS is a read-only reporting view in the Oracle E-Business Suite IGS (Student System) product family, which is documented as obsolete in release 12.1.1 and 12.2.2. The view consolidates refund transactions generated when a student account carries excess unapplied credits and a refund must be issued back to the party or payee. Its purpose is to denormalize the core refund ledger into a human-readable, reporting-friendly projection that joins refund detail to party, fee type, calendar instance, and invoice context. The view is not implemented in the ETRM reference database, so the definition below is derived from the documented view text and column metadata rather than a live instance.

The view carries particular relevance to the reversal_reason search term: the physical column RE.REASON in IGS_FI_REFUNDS is exposed through this view under the alias REVERSAL_REASON, alongside the companion REVERSAL_INDICATOR, REVERSAL_GL_DATE, and SOURCE_REFUND_IDENTIFIER columns. Together these allow report authors to distinguish original refunds from reversals and to attribute each reversal to a business reason without querying the base table directly.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the documented view text defines five source objects in its FROM clause, joined through equality predicates:

The view is declared WITH READ ONLY and therefore cannot be used as a DML target; it is intended solely for extraction and reporting.

Key Columns

Common Use Cases and Queries

Typical usage centres on reconciliation of refunds and their reversals, party-level refund reporting, and audit of unapplied-credit activity.

Refunds with reversal reasons for a given period:

SELECT party_number, party_name, refund_amount,
       voucher_date, reversal_indicator, reversal_reason
FROM   igsbv_party_refunds
WHERE  reversal_reason IS NOT NULL
AND    gl_date BETWEEN :from_date AND :to_date;

Refund-to-reversal lineage:

SELECT r.refund_voucher_identifier, r.source_refund_identifier,
       r.reversal_reason, r.reversal_gl_date
FROM   igsbv_party_refunds r
WHERE  r.source_refund_identifier IS NOT NULL;

Refund totals by fee type and transfer status:

SELECT fee_type, fee_type_description, transfer_status,
       SUM(refund_amount) total_refund
FROM   igsbv_party_refunds
GROUP BY fee_type, fee_type_description, transfer_status;

Because the view is read-only and IGS is obsolete, it should be used only where the Student System module remains installed; consumption patterns should be reviewed during any migration away from IGS.