Search Results cr_gl_ccid




Overview
Explore in AI Chat

Overview

IGSFV_PARTY_REFUNDS is an Oracle E-Business Suite read-only view owned by the APPS schema, defined in the Oracle Student System (formerly Student Information System / IGS) product family. It presents refund transaction information in the context of the parties involved — the student (or payee) and the paying party — together with the general ledger accounting entries generated when the refund is transferred to Oracle General Ledger. The view is primarily intended for reporting, inquiry, and integration purposes, exposing both descriptive refund attributes and the accounting flexfield combinations (CCIDs) that identify where the debit and credit amounts are posted.

The view is defined WITH READ ONLY, confirming its role as a query surface rather than an updateable entity. It is particularly relevant when users need to trace a party refund from the Oracle Student System through to its GL accounting impact, which explains why searches such as the "dr_gl_ccid" query return this object.

Underlying Base Objects

The metadata lists no documented base objects, but the view text reveals a rich join across several IGS and shared tables:

Joins to HZ_PARTIES, IGS_FI_INV_INT_ALL, fe, and ci are inner joins, while ac1, ac2, gcc1, and gcc2 are outer joins, and the self-join to the source refund (re2) is an outer join.

Key Columns

The selected columns carry both transactional and accounting significance:

Common Use Cases and Queries

Typical usage centers on reconciling party refunds with GL accounting and on reporting refund activity by term, party, or fee type. A query to locate the GL classification for a specific refund's distribution lines would resemble:

  • SELECT rf.refund_id, rf.party_name, rf.dr_gl_ccid, rf.cr_gl_ccid, rf.refund_amount, rf.gl_date FROM apps.igsfv_party_refunds rf WHERE rf.dr_gl_ccid = :p_ccid; — retrieves refunds posting to a given GL code combination.
  • Filtering by party_number or party_name returns all refunds for a student, useful for student account statements.
  • Filtering by fee_cal_type and term dates isolates refunds within an academic period for term-level reconciliation.
  • Joining the view back to GL_CODE_COMBINATIONS on dr_gl_ccid or cr_gl_ccid enriches output with the concatenated accounting flexfield and account descriptions.

Because the accounting columns rely on outer joins, refunds not yet transferred to GL return null CCIDs; report authors should account for this when writing reconciliation logic.