Search Results refund_transfer_status

Overview

IGS_FI_REFUNDS_V is a reporting and integration view in the Oracle E-Business Suite Financials (IGS) product family, owned by the APPS schema and defined in the ETRM repository for releases 12.1.1 and 12.2.2. It presents refund transaction records generated within the Student System and Financials integration layer, combining refund header data with descriptive information drawn from person, calendar, invoice, account, and lookup sources. The view consolidates several normalized base tables into a single denormalized projection, which simplifies downstream reporting, concurrent program logic, and external integration extraction.

The view is closely associated with the transfer_status column and the corresponding lookup type REFUND_TRANSFER_STATUS. The join on rfnd.transfer_status = lkp1.lookup_code resolves the coded status into a user-facing meaning through the lkp1.meaning column. This is the field most commonly sought when users search for "refund_transfer_status," since the view is the principal documented exposure point for that attribute.

Underlying Base Objects

Although the ETRM metadata lists no documented base objects separately, the view text explicitly defines the sources it is built over. The principal table is IGS_FI_REFUNDS, aliased RFND, which supplies the refund transaction rows and the majority of columns, including identifiers, GL account codes, amounts, dates, and descriptive flexfield attribute segments one through twenty.

Supporting objects joined in the definition include:

• IGS_LOOKUP_VALUES (LKP1) — resolves transfer_status against lookup type REFUND_TRANSFER_STATUS.
• IGS_FI_PARTIES_V (PE) — supplies person_number and full_name for the pay person.
• IGS_CA_TYPE (CAT) — provides the calendar type description.
• IGS_CA_INST (CI) — provides calendar instance start and end dates.
• IGS_FI_INV_INT (INV) — an outer join supplying invoice_number.
• IGS_FI_ACC (ACC1, ACC2) — outer joins providing descriptions for the debit and credit account codes.

Key Columns

The view exposes refund_id as the primary identifier, alongside voucher_date, person_id, pay_person_id, person_number, and full_name. Accounting data includes dr_gl_ccid, cr_gl_ccid, dr_account_cd, cr_account_cd, and their associated descriptions. Amounts and classification are represented by refund_amount, fee_type, fee_cal_type, and fee_ci_sequence_number.

Status and workflow columns include transfer_status and its resolved lkp1.meaning, reversal_ind, reason, and the GL dates gl_date and reversal_gl_date. Payment details are captured through payment_number, payment_date, and payment_mode. A null literal is projected in the position following payment_mode in the select list. Standard EBS audit columns (created_by, creation_date, last_updated_by, last_update_date, request_id, and related fields) are also included for traceability and concurrent manager auditing.

Common Use Cases and Queries

The view is typically queried to report refund activity by status, person, or calendar period. A frequent requirement is retrieval of refunds filtered by transfer status, which explains the "refund_transfer_status" search term.

Refunds awaiting transfer:

SELECT refund_id, full_name, refund_amount, lkp1.meaning
FROM   apps.igs_fi_refunds_v
WHERE  transfer_status = 'PENDING';

Refund detail joined to person and invoice context:

SELECT refund_id, person_number, full_name, invoice_number,
       refund_amount, transfer_status, payment_mode
FROM   apps.igs_fi_refunds_v
WHERE  fee_cal_type = :p_cal_type
AND    voucher_date BETWEEN :p_from AND :p_to;

Reversal analysis:

SELECT refund_id, reversal_ind, reason, gl_date, reversal_gl_date
FROM   apps.igs_fi_refunds_v
WHERE  reversal_ind = 'Y';

Because the definition relies on inner joins for the lookup, calendar, and party joins, rows whose transfer_status has no matching lookup value will not appear — a consideration for reconciliation reporting.