Search Results igs_fi_refund_int_all




Overview
Explore in AI Chat

Overview

The IGS_FI_REFUND_INT_ALL table is a core interface (staging) table within the Oracle E-Business Suite IGS — Student System product. Its documented description states that it serves as the "interface table for transfer of refund data to a payables system." In practice, this means the table acts as the intermediary holding area through which refund transactions originating in the Student System (fees, charges, and related financial activity) are staged before being handed off to Oracle Payables for the creation of invoices and payments. The table is owned by the IGS schema and carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2.

From a modeling perspective, the provided metadata classifies this object heuristically as a link table. This classification is mined from the foreign-key structure, which shows PAY_PERSON_ID and PERSON_ID both referencing HZ_PARTIES. As a modeling suggestion, this link role indicates the table associates parties (refund recipients) with refund transactions, rather than functioning as a pure reference hub or a descriptive satellite.

Key Information Stored

The table is documented with 50 physical columns under the 12.1.1 schema. The most significant columns fall into three functional groupings:

Common Use Cases and Queries

Typical scenarios include monitoring unprocessed refunds awaiting transfer to Payables, reconciling refund amounts against GL distributions, and auditing refunds by party or fee type. Representative query patterns:

  • List refunds pending interface: SELECT refund_id, person_id, refund_amount, voucher_date FROM igs_fi_refund_int_all WHERE gl_date IS NULL;
  • Aggregate refunds by payment mode: SELECT payment_mode, SUM(refund_amount) FROM igs_fi_refund_int_all GROUP BY payment_mode;
  • Join to parties for recipient detail: SELECT r.refund_id, p.party_name, r.refund_amount FROM igs_fi_refund_int_all r, hz_parties p WHERE r.pay_person_id = p.party_id;

Related Objects

  • HZ_PARTIES — referenced twice: IGS_FI_REFUND_INT_ALL.PAY_PERSON_ID → HZ_PARTIES and IGS_FI_REFUND_INT_ALL.PERSON_ID → HZ_PARTIES.
  • IGS_FI_REFUND_INT_PK — primary-key constraint on REFUND_ID.
  • IGS_FI_REFUND_INT_ALL_PK — unique index supporting the business key.
  • Downstream Oracle Payables interface objects receive the staged data via the Student System's refund transfer concurrent program.
  • GL_CODE_COMBINATIONS — implicitly referenced by DR_GL_CCID and CR_GL_CCID.