Search Results igs_fi_fee_cat




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_CAT view is a secured, multi-organization reporting object within the Oracle E-Business Suite Student System (IGS) product family. It exposes fee category definitions — the master reference records used to classify student charges such as tuition, laboratory fees, application fees, and miscellaneous service charges. In the EBS 12.1.1 and 12.2.2 releases the view is owned by the APPS schema and is reported as VALID in the data dictionary.

From a reporting and integration standpoint, the view serves two purposes. First, it provides a flat, join-friendly projection of fee category attributes that can be embedded in concurrent programs, BI Publisher data templates, and Discoverer workbooks without exposing the underlying _ALL table's administrative columns. Second, it enforces row-level operating unit security at query time, so any report built on the view automatically returns only the fee categories belonging to the session's active organization. This makes it the preferred access path for custom extensions that must respect the same Multi-Org boundaries as the seeded Student Financials forms.

Underlying Base Objects

The view is defined over a single base table, IGS_FI_FEE_CAT_ALL. The definition selects the table's ROWID under the alias ROW_ID and then projects the descriptive and auditing columns.

The security predicate compares the ORG_ID of each row against the organization identifier stored in the CLIENT_INFO session context. The expression extracts the first ten bytes of USERENV('CLIENT_INFO'), suppresses the value when the leading character is a space, and converts the result to a number. Both sides of the comparison are wrapped in NVL(..., -99), so rows with a null ORG_ID are matched to sessions that likewise carry no organization context. Because the filter is expressed against the base table rather than through a database policy function, it is evaluated inline for every execution.

Key Columns

  • ROW_ID — the physical row identifier of the underlying IGS_FI_FEE_CAT_ALL record; useful for building updatable detail blocks or performing row-level reconciliation.
  • FEE_CAT — the fee category code, the primary business key used to link fee categories to fee calendars, fee types, and student account entries.
  • DESCRIPTION — the user-facing name of the fee category as displayed in inquiry and entry forms.
  • CURRENCY_CD — the currency in which amounts for this fee category are denominated. Because the searched term for this object is currency_cd, this column is the principal target for reporting and validation queries; it determines rounding behavior and is a common join key to currency and exchange-rate reference data.
  • CLOSED_IND — indicates whether the fee category has been retired and is no longer available for new transactions.
  • ORG_ID — the operating unit that owns the record; the column driven by the Multi-Org security predicate.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-columns retained for audit and change-tracking reports.

Common Use Cases and Queries

Typical scenarios include currency validation prior to fee assessment, listing of active fee categories available to a given operating unit, and audit reporting on records that have been closed or recently modified.

SELECT fee_cat, description, currency_cd, closed_ind
FROM   apps.igs_fi_fee_cat
WHERE  closed_ind = 'N'
ORDER BY fee_cat;

To identify all fee categories configured in a non-base currency:

SELECT fee_cat, description, currency_cd
FROM   apps.igs_fi_fee_cat
WHERE  currency_cd <> 'USD';

To trace recent maintenance activity within the session's operating unit:

SELECT fee_cat, currency_cd, last_updated_by, last_update_date
FROM   apps.igs_fi_fee_cat
WHERE  last_update_date >= SYSDATE - 30;

Because organization filtering is applied inside the view, these statements require no additional WHERE clause to restrict data to the active operating unit; callers that must query across organizations should access IGS_FI_FEE_CAT_ALL directly, subject to the appropriate privileges.