Results for “balance_rule_id”

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

Overview

IGS_FI_BAL_EX_F_TYPS is a configuration table belonging to the IGS (Student System) product family within Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. The IGS module is marked obsolete in current documentation, meaning the product is no longer actively implemented in this database, yet the object remains relevant for historical reference, upgrade analysis, and data migration exercises. Its purpose is narrow and explicit: it captures the set of Fee Types that must be excluded, or ignored, when the Student System performs a balance calculation governed by a fee balance rule.

The table functions as an exclusion list that complements the balance rule engine. Where IGS_FI_BALANCE_RULES defines how balances are computed for a fee category, IGS_FI_BAL_EX_F_TYPS refines that logic by enumerating the specific fee types the rule must skip. The documented schema comprises nine columns, with two unique indexes acting as business-key candidates: IGS_FI_BAL_EX_F_TYPS_U1 on BAL_EXC_FEE_TYPE_ID and IGS_FI_BAL_EX_F_TYPS_U2 on the composite of BALANCE_RULE_ID and FEE_TYPE. The heuristic Data Vault classification mined from the foreign-key structure is link, suggesting a modeling approach in which the table resolves a many-to-many relationship between balance rules and fee types rather than serving as a standalone hub or descriptive satellite.

Key Information Stored

The most significant columns reflect this table's role as a junction-style exclusion register:

• BAL_EXC_FEE_TYPE_ID — the surrogate primary key and the target of unique index U1. It uniquely identifies each exclusion entry.
• BALANCE_RULE_ID — foreign key to IGS_FI_BALANCE_RULES, identifying the balance rule to which the exclusion applies. Combined with FEE_TYPE, it forms the business-key candidate U2.
• FEE_TYPE — foreign key to IGS_FI_FEE_TYPE_ALL, naming the fee type that the associated rule must ignore. Together with BALANCE_RULE_ID it guarantees a single exclusion record per rule-and-fee-type pairing.
• ENABLED_FLAG — a standard Oracle EBS active/inactive indicator controlling whether the exclusion is currently in effect.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture the standard "Who" columns for accountability, supporting both 12.1.1 and 12.2.2 audit conventions.

Common Use Cases and Queries

The dominant use case is diagnostic: determining why a particular fee type is excluded from a student's computed balance. A typical query joins this table to the balance rule and fee type definitions:

• List all exclusions for a given balance rule: SELECT fee_type FROM igs_fi_bal_ex_f_typs WHERE balance_rule_id = :rule AND enabled_flag = 'Y';
• Reverse lookup — find rules that exclude a specific fee type: SELECT balance_rule_id FROM igs_fi_bal_ex_f_typs WHERE fee_type = :fee_type;
• Configuration audit — report active versus inactive exclusions, exposing stale entries left behind after rule changes.
• Data migration validation — enumerate exclusions before and after an upgrade to confirm that balance behaviour remains consistent.

Because IGS is obsolete, these queries are primarily retrospective or archival in nature.

Related Objects

The foreign-key relationships define the table's immediate dependencies:

• IGS_FI_BALANCE_RULES — joined on BALANCE_RULE_ID; the parent defining balance computation logic.
• IGS_FI_FEE_TYPE_ALL — joined on FEE_TYPE; the master definition of fee types eligible for exclusion.
• IGS_FI_BAL_EX_F_TYPS_PK / _U1 / _U2 — the primary and unique constraints enforcing uniqueness of the surrogate key and the rule-fee-type pair.

These relationships position the table as a dependent configuration artifact within the IGS fee and balance subsystem.