Search Results igs_fi_fee_type_v

Overview

IGS_FI_FEE_TYPE_V is a reporting and integration view owned by the APPS schema within the IGS — Student System product family of Oracle E-Business Suite. Its documented purpose is to fetch all fee types defined in the system, exposing fee type configuration together with the associated fee class and its decoded display meaning. The view carries a status of VALID and is available in the 12.1.1 and 12.2.2 releases of Oracle EBS as part of the Student System (often deployed alongside Oracle Student Financials / receivables-related fee processing).

Because it is a view rather than a base table, it shields consumers from having to reconstruct the join between the fee type entity and the lookup that resolves the FEE_CLASS code into a human-readable value. This makes it the preferred access point for operational reports, concurrent program extracts, and inbound/outbound integrations that need fee type reference data. When a user searches on fee_class, this object is directly relevant: the view both surfaces the raw FEE_CLASS column and resolves it via a lookup to produce FEE_CLASS_MEANING.

Underlying Base Objects

The view text is defined over two base objects, joined with an outer (Oracle (+)) join:

• IGS_FI_FEE_TYPE (aliased A) — the primary fee type entity holding the fee type definition, flags, comments, and the FEE_CLASS code.
• IGS_LOOKUP_VALUES (aliased LKP) — the lookup table, filtered to LOOKUP_TYPE = 'FEE_CLASS', matched on LOOKUP_CODE = A.FEE_CLASS.

The outer join is significant: fee types whose FEE_CLASS value has no matching active lookup entry are still returned, with FEE_CLASS_MEANING as NULL. This preserves the "fetch all fee types" contract while enriching the result where lookup data exists. No additional referenced base objects are documented in the ETRM metadata.

Key Columns

The view exposes the following columns, which mirror the structure documented in the ETRM metadata:

• ROW_ID — the row identifier derived from the base table ROWID, useful for direct-row addressing.
• FEE_TYPE and S_FEE_TYPE — the fee type code and its short/alternate form.
• S_FEE_TRIGGER_CAT — the triggering category that governs when the fee is raised.
• DESCRIPTION — the descriptive text for the fee type.
• OPTIONAL_PAYMENT_IND, DESIGNATED_PAYMENT_FLAG, CLOSED_IND — status and payment behaviour indicators.
• COMMENTS — free-form author notes.
• ORG_ID — the operating unit (multi-org) identifier; critical for secure, org-scoped queries.
• FEE_CLASS — the raw fee class code stored against the fee type. This is the column of interest when searching on fee_class.
• FEE_CLASS_MEANING — the decoded description of FEE_CLASS sourced from IGS_LOOKUP_VALUES.
• SUBACCOUNT_ID and SUBACCOUNT_NAME — the balancing sub-account linkage; SUBACCOUNT_NAME is exposed as a placeholder NULL in the view text.
• Standard WHO audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include listing all active fee types for a given fee class, populating LOVs in extensions, and validating fee class codes during conversion. The following query returns fee types grouped by their decoded class:

• SELECT fee_type, description, fee_class, fee_class_meaning FROM igs_fi_fee_type_v WHERE closed_ind = 'N' ORDER BY fee_class, fee_type;
• SELECT fee_type, fee_class_meaning FROM igs_fi_fee_type_v WHERE fee_class = 'TUITION' AND org_id = :p_org_id;
• SELECT fee_class, fee_class_meaning, COUNT(*) FROM igs_fi_fee_type_v GROUP BY fee_class, fee_class_meaning;

When filtering, note that FEE_CLASS_MEANING may be NULL for unmapped classes, so queries relying on it should be tolerant of that outer-join behaviour. Multi-org security should always be applied via ORG_ID or the client-side organization context.