Search Results igs_fi_fee_dsb_fm_ru

Overview

The table IGS_FI_FEE_DSB_FM_RU is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It specifically models the relationship between special contract-based fee assessment rules and the underlying system rules engine. Its primary role is to link a fee discount or special assessment formula (a "disbursement formula") to a specific executable rule. This linkage allows the system to dynamically calculate non-standard fees based on contractual agreements or institutional policies. The table's existence is critical for configuring complex, rule-driven fee structures within the student financials subsystem. Importantly, the provided metadata explicitly states this table was "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in certain instances of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure centers on identifying a unique fee assessment context and its associated rule. The primary key is a composite of columns that pinpoint a specific fee formula within a fee calendar period: FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER. These columns collectively reference a specific fee disbursement formula. The final primary key column, S_RULE_CALL_CD, identifies the type of rule call. A critical foreign key column is RUL_SEQUENCE_NUMBER, which stores the unique identifier linking to the actual rule definition in the central rules engine (IGS_RU_RULE). This column is the operational link that determines which logic is executed for the fee calculation.

Common Use Cases and Queries

This table is primarily accessed for configuration and audit purposes within the fee assessment engine. A common administrative use case would be to identify all the active rules governing special fee calculations for a particular fee type and academic period. A typical query would join this table to the rule definition and formula tables to present a comprehensive view of the fee assessment logic. For troubleshooting, one might query this table to verify the rule attached to a formula is valid and active.

• Sample Query: Retrieving the rule details for a specific fee formula.
  SELECT r.rule_cd, r.version_number, r.rule_status
FROM igs_fi_fee_dsb_fm_ru ru,
igs_ru_rule r
WHERE ru.rul_sequence_number = r.rul_sequence_number
AND ru.fee_type = 'TUITION';

Related Objects

IGS_FI_FEE_DSB_FM_RU sits at the intersection of the fee assessment and rules subsystems. Its primary relationships, as defined by its foreign keys, are fundamental to its purpose.

• IGS_FI_FEE_DSBR_FML: This is the parent "Fee Disbursement Formula" table. The foreign key on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER establishes that a rule is attached to a specific pre-defined formula.
• IGS_RU_RULE: The central rules table. The RUL_SEQUENCE_NUMBER column references this table to determine the exact business logic (rule) executed during the fee assessment process.
• IGS_RU_CALL: The rule call lookup table. The S_RULE_CALL_CD column references this table to classify the type or context of the rule call being made (e.g., a validation rule vs. a calculation rule).