Search Results igs_fi_f_cat_fee_lbl




Overview
Explore in AI Chat

Overview

The view APPS.IGS_FI_F_CAT_FEE_LBL belongs to the Oracle Student System (IGS) product family, specifically the Financials sub-module responsible for fee assessment and liability processing. Its name derives from "IGS Financials – Fee Category Fee" with the "LBL" suffix indicating that it exposes a translated, label-bearing projection used for reporting and integration purposes. In Oracle EBS 12.1.1 and 12.2.2 the view is exposed in the APPS schema with a status of VALID.

This view presents a flattened, multi-organization-aware representation of fee category, calendar type, fee type, and liability configuration data. Its principal functional role is to supply fee setup metadata to downstream reporting, self-service pages, and integration interfaces that need to resolve the attributes governing how a particular fee is assessed, ranked in the payment hierarchy, and whether waivers are calculated for it. Because the view is secured through ORG_ID, callers only see rows belonging to the operating unit currently set in their session context.

Underlying Base Objects

The documented view text defines the view over a single base object: IGS_FI_F_CAT_FEE_LBL_ALL. No other base tables, synonyms, or joined views are referenced in the definition. All columns exposed by the view are projected directly from this _ALL table; the view performs no joins, aggregations, or calculations of its own.

Row visibility is controlled by a multi-organization (MO) security predicate embedded in the view definition. The predicate compares the current operating unit derived from USERENV('CLIENT_INFO') against the ORG_ID column, defaulting both sides to -99 when the client information is blank. This construction is characteristic of EBS multi-org secured views, and it means that the effective filtering of rows is driven entirely by the calling session's client information, not by application logic inside the view.

Key Columns

Common Use Cases and Queries

Typical usage centres on identifying which fee configurations are subject to waiver calculation, and on retrieving payment hierarchy and rule metadata for a given fee category or calendar.

To list fee setups that have waiver calculation enabled:

SELECT fee_cat, fee_cal_type, fee_type, payment_hierarchy_rank
FROM   apps.igs_fi_f_cat_fee_lbl
WHERE  waiver_calc_flag = 'Y';

To inspect the full configuration for a specific fee category and calendar type:

SELECT fee_cat, fee_cal_type, fee_ci_sequence_number, fee_type,
       fee_liability_status, payment_hierarchy_rank, waiver_calc_flag
FROM   apps.igs_fi_f_cat_fee_lbl
WHERE  fee_cat = 'TUITION'
AND    fee_cal_type = 'ACAD_YR';

To review audit history for recent configuration changes:

SELECT fee_cat, fee_type, last_updated_by, last_update_date
FROM   apps.igs_fi_f_cat_fee_lbl
WHERE  last_update_date >= SYSDATE - 30;

Because the view is MO-secured, callers should ensure that CLIENT_INFO is populated with the intended operating unit; otherwise the predicate resolves to -99 and may return no rows. For integration workloads, binding the target ORG_ID explicitly in the predicate provides deterministic results.