Results for “waiver_calc_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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

• ROW_ID – The physical ROWID of the underlying row, used by Oracle Forms and by integration layers for row identification and locking.
• FEE_CAT – The fee category, the primary setup grouping to which the fee record belongs.
• FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER – The fee calendar type and calendar instance sequence that qualify the fee record's effective period.
• FEE_TYPE – The specific fee type being configured.
• FEE_LIABILITY_STATUS – Indicates the liability status associated with the fee record.
• START_DT_ALIAS, START_DAI_SEQUENCE_NUMBER – The date alias and its sequence number defining the start date logic for the fee.
• S_CHG_METHOD_TYPE, RUL_SEQUENCE_NUMBER – The change method type and the rule sequence number that drive fee assessment rules.
• PAYMENT_HIERARCHY_RANK – The ordering rank that determines the priority in which this fee is applied within the payment hierarchy.
• ORG_ID – The operating unit identifier used for multi-org security filtering.
• WAIVER_CALC_FLAG – The flag controlling whether waiver calculation applies to this fee configuration; this is the column most relevant to the user's search term.
• Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE provide standard EBS audit and concurrent program context.

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.