Results for “igs_fi_fee_dsb_fm_ru”

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

Overview

The IGS_FI_FEE_DSB_FM_RU table belongs to the IGS – Student System product family within Oracle E-Business Suite (documented as Obsolete in the ETRM repository). It stores special contract-based fee assessment rates, functioning as a disbursement formula-to-rule mapping entity within the Student System fee calculation engine. In practical terms, the table associates a specific fee formula defined for a fee type and calendar instance with a rule it invokes during assessment processing, enabling institutions to apply contracted pricing logic that deviates from standard published fee schedules.

The ETRM metadata should be treated as historical rather than current operational documentation. The database implementation note states explicitly that the object is not implemented in this database, meaning it should be absent from active Oracle EBS 12.1.1 and 12.2.2 installations unless a legacy upgrade path or a specific patchset retained it. The record survives primarily as schema-reference material for legacy integration analysis and data migration scoping.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This reflects the table's role as an associative entity that resolves relationships between a disbursement formula definition and rule-call/rule definitions rather than capturing descriptive attributes of a single business concept.

Key Information Stored

The primary key, IGS_FI_FEE_DSB_FM_RU_PK, is a composite key composed of the following five columns, all of which are documented business-key candidates for this entity:

• FEE_TYPE — identifies the fee category to which the contract-based assessment rate applies; also a foreign key to IGS_FI_FEE_DSBR_FML.
• FEE_CAL_TYPE — the fee calendar type that scopes the assessment period; part of the foreign key to IGS_FI_FEE_DSBR_FML.
• FEE_CI_SEQUENCE_NUMBER — the calendar instance sequence number pinpointing the specific fee calendar occurrence; third component of the IGS_FI_FEE_DSBR_FML reference.
• FORMULA_NUMBER — the disbursement formula identifier within the referenced formula definition.
• S_RULE_CALL_CD — the rule call code; foreign key to IGS_RU_CALL, linking the formula to the invoked rule-call construct.
• RUL_SEQUENCE_NUMBER — while not listed as a primary-key component in the excerpt, it is documented as a foreign key to IGS_RU_RULE and identifies the underlying rule definition the fee assessment invokes.

Because the composite primary key comprises all identifying columns, no separate surrogate single-column key is documented. Secondary indexes, if any, are not enumerated in the available metadata.

Common Use Cases and Queries

Legacy reporting and reconciliation remain the principal use cases, since the object is obsolete. Typical scenarios include auditing which formulas referenced which rules for contract-based fee assessment, tracing the origin of a disbursement calculation back to its rule definition, and populating conversion workbooks when migrating historical fee data to a successor application.

SELECT fm.FEE_TYPE, fm.FEE_CAL_TYPE, fm.FORMULA_NUMBER,
       fm.S_RULE_CALL_CD, rc.RULE_CALL_CD, r.RUL_SEQUENCE_NUMBER
FROM   IGS_FI_FEE_DSB_FM_RU fm,
       IGS_FI_FEE_DSBR_FML  fml,
       IGS_RU_CALL          rc,
       IGS_RU_RULE          r
WHERE  fm.FEE_TYPE             = fml.FEE_TYPE
AND    fm.FEE_CAL_TYPE         = fml.FEE_CAL_TYPE
AND    fm.FEE_CI_SEQUENCE_NUMBER = fml.FEE_CI_SEQUENCE_NUMBER
AND    fm.FORMULA_NUMBER       = fml.FORMULA_NUMBER
AND    fm.S_RULE_CALL_CD       = rc.S_RULE_CALL_CD
AND    fm.RUL_SEQUENCE_NUMBER  = r.RUL_SEQUENCE_NUMBER;

A navigational hierarchy query joining to IGS_FI_FEE_DSBR_FML helps identify orphaned formula mappings prior to archiving. Because the table is marked not implemented, queries executed against a live 12.2.2 instance will typically return an ORA-00942 error, confirming the object's absence.

Related Objects

• IGS_FI_FEE_DSBR_FML — parent formula definition; joined on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER.
• IGS_RU_RULE — rule definition referenced through RUL_SEQUENCE_NUMBER.
• IGS_RU_CALL — rule-call construct referenced through S_RULE_CALL_CD.
• IGS_FI_FEE_DSBR_FML_PK / IGS_FI_FEE_DSB_FM_RU_PK — key definitions governing uniqueness and referential integrity.
• Standard IGS Student System fee APIs that previously consumed formula-rule mappings during assessment runs.