Search Results s_fee_type




Overview
Explore in AI Chat

Overview

IGS_FI_FEE_TYPE_V is a reportable and queryable view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It presents the fee type definitions maintained by the Student Financials component of Oracle Student System (formerly Oracle iLearning/Student Records lineage under the IGS schema prefix). In Oracle EBS, "IGS" objects belong to the Student System product family, and the FI module addresses fee and financial item setup. The view exposes the master fee type records held in IGS_FI_FEE_TYPE together with a decoded fee class description, providing a denormalized, presentation-ready result set for forms, concurrent programs, reports, and integration extracts. Because it includes ORG_ID and standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the view is multi-org aware and can be constrained by operating unit in reporting. The view is read-only in practice: it is a join of a base entity table to the lookup values table and contains no DML of its own.

Underlying Base Objects

The view text is defined as a join between two objects:

  • IGS_FI_FEE_TYPE (aliased A) — the primary fee type entity table. All business columns of the view originate from this table.
  • IGS_LOOKUP_VALUES (aliased LKP) — the lookup values table, joined on LOOKUP_CODE = A.FEE_CLASS with LOOKUP_TYPE = 'FEE_CLASS'.

The join is written with the outer-join operator (+) on both predicates, so fee type rows are retained even when no matching FEE_CLASS lookup value exists. In that case FEE_CLASS_MEANING returns null while FEE_CLASS still carries the stored code. This is a significant design point: the view will not silently drop fee types whose class code has not been defined or has been end-dated in the lookup set. The view also selects A.ROWID as ROW_ID and a literal NULL column, neither of which carries business meaning; ROW_ID can be used for row identification in some Oracle Forms-based blocks. The view is not based on any additional documented tables, and no base-object metadata beyond the two tables above is recorded in the ETRM entry.

Key Columns

  • FEE_TYPE — the primary key identifier of the fee type record.
  • S_FEE_TYPE and S_FEE_TRIGGER_CAT — system-level (seed) fee type and trigger category indicators.
  • DESCRIPTION — the user-facing description of the fee type.
  • FEE_CLASS — the stored fee class code on the fee type; this is the column targeted by the user search term "fee_class".
  • FEE_CLASS_MEANING — the decoded meaning of FEE_CLASS from IGS_LOOKUP_VALUES where LOOKUP_TYPE = 'FEE_CLASS'.
  • OPTIONAL_PAYMENT_IND — indicates whether payment against the fee type is optional.
  • DESIGNATED_PAYMENT_FLAG — flag controlling designated payment behavior.
  • CLOSED_IND — indicates whether the fee type is closed to further use.
  • SUBACCOUNT_ID — subaccount association for accounting derivation.
  • COMMENTS, ORG_ID, and the five audit/ROW_ID columns — descriptive text, operating unit, and standard WHO audit information.

Common Use Cases and Queries

Typical uses include validating fee type setup, listing fee types by class for student financials reporting, and feeding downstream fee assessment or accounting extracts. The following query lists open fee types with their decoded class:

  • SELECT fee_type, description, fee_class, fee_class_meaning FROM apps.igs_fi_fee_type_v WHERE closed_ind = 'N' ORDER BY fee_class, fee_type;
  • SELECT fee_class, fee_class_meaning, COUNT(*) FROM apps.igs_fi_fee_type_v WHERE org_id = :p_org_id GROUP BY fee_class, fee_class_meaning;
  • SELECT fee_type, fee_class FROM apps.igs_fi_fee_type_v WHERE fee_class_meaning IS NULL; — locates fee types whose class code lacks a defined FEE_CLASS lookup value, exploiting the outer join described above.

Because the view carries no WHERE clause restricting ORG_ID or CLOSED_IND, consumers should always add the appropriate operating unit and status filters to avoid returning seed or obsolete records.