Search Results source_refund_identifier

Overview

IGSBV_PARTY_REFUNDS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data IGS.IGSBV_PARTY_REFUNDS. It is part of the Oracle Student System / Financials integration layer associated with the IGS (Student Systems) product family. The view exposes refund transactions generated when excess unapplied credits exist on a student or party account, providing a consolidated, denormalized picture of each refund event.

Because it is a BIS view rather than a transactional table, its primary role is read-only reporting and downstream integration. Operational users and integrators query it to review refund activity, trace voucher creation, confirm whether a refund has been reversed, and drive interfaces that transfer records into refund processing. The view surfaces descriptive context—party and payee names, calendar and fee type descriptions, and account code strings—alongside the underlying identifiers, which makes it suitable for ad hoc reporting without requiring joins to multiple base tables.

Underlying Base Objects

The ETRM metadata for this object does not document the referenced base tables. In practice, IGSBV_PARTY_REFUNDS is defined over the IGS refund processing structures that hold refund voucher records and their reversal entries, together with joined lookup tables that supply fee type, calendar, and party/payee attributes. Columns prefixed with the interface convention (for example, _LA:TRANSFER_STATUS) indicate that the view also derives values from interface-selection logic used by concurrent processes to identify records not yet transferred to the Refunds Interface.

The view is therefore best understood as a presentational layer: it aggregates the refund voucher header, its General Ledger distributions, the associated party and payee identity, and calendar-effectivity context into a single row per refund transaction. Because no base objects are documented, dependency analysis should be performed against the IGS schema in the target instance (for example, via ALL_DEPENDENCIES) before relying on any assumed lineage.

Key Columns

• REVERSAL_INDICATOR — VARCHAR2; flags that the refund transaction has been reversed. This is the column referenced in the sample query.
• REVERSAL_REASON / REVERSAL_GL_DATE — free-text reason for reversal (up to 2000 characters) and the GL date applied to the reversal voucher.
• REFUND_AMOUNT — the refund amount; documented as never zero.
• VOUCHER_DATE / GL_DATE — voucher creation date and the General Ledger date of the refund record.
• FEE_TYPE, FEE_CALENDAR_TYPE, FEE_TYPE_DESCRIPTION, CALENDAR_DESCRIPTION, CALENDAR_ALTERNATE_CODE — classification and descriptive attributes for the fee and calendar context.
• CAL_START_EFFECTIVE_DATE / CAL_END_EFFECTIVE_DATE — the effectivity window of the calendar instance.
• PARTY_NUMBER, PARTY_NAME, PAYEE_PARTY_NUMBER, PAYEE_PARTY_NAME — the refunded party and the actual payee, which may differ.
• DEBIT_ACCOUNT_CODE / CREDIT_ACCOUNT_CODE — account code strings, with corresponding DEBIT_GL_CODE_COMBINATION_ID and CREDIT_GL_CODE_COMBINATION_ID identifiers.
• CHARGE_NUMBER — invoice number of the charge created for the refund.
• _LA:TRANSFER_STATUS — interface status; default TODO when the record has not been transferred to the Refunds Interface.

Common Use Cases and Queries

Typical scenarios include reconciling refund vouchers against GL distributions, auditing reversals, monitoring the interface backlog, and extracting refund detail for student financials reporting.

Listing unreversed refunds for a party:

SELECT party_number, party_name, refund_amount, gl_date
FROM   apps.igsbv_party_refunds
WHERE  reversal_indicator IS NULL
AND    party_number = :party_number;

Auditing reversals and their reasons:

SELECT party_number, refund_amount, reversal_reason,
       reversal_gl_date, voucher_date
FROM   apps.igsbv_party_refunds
WHERE  reversal_indicator IS NOT NULL;

Monitoring records awaiting interface transfer:

SELECT charge_number, party_name, refund_amount
FROM   apps.igsbv_party_refunds
WHERE  "_LA:TRANSFER_STATUS" = 'TODO';

Queries against the _LA: prefixed column must quote the identifier exactly as defined. As with all APPS BIS views, access is governed by grants and row-level security; ensure the reporting responsibility or custom role holds the appropriate privileges.