Search Results igs_fi_app_rules




Overview
Explore in AI Chat

Overview

The IGS_FI_APP_RULES table is a core data structure within the now-obsolete Oracle E-Business Suite Student System (IGS). It defines the operational logic for applying student fee payments. Specifically, it stores the detailed rules that govern the order and priority in which different types of outstanding fees are satisfied when a payment is received. These rules are linked to an Application Hierarchy, which is a master framework for organizing fee application logic across the institution. The table's primary role is to ensure that payments are automatically allocated to fee charges according to a consistent, configurable sequence, which is critical for accurate accounting and student financial management.

Key Information Stored

The table's structure centers on defining the sequence and conditions for fee application. The primary identifier is the APPL_RULE_ID. The most critical functional columns establish the rule's context and order. The APPL_HIERARCHY_ID is a foreign key linking the rule to its parent Application Hierarchy. The FEE_TYPE column specifies the category of fee (e.g., tuition, lab fees, late penalties) to which the rule applies. The RULE_TYPE column, part of the unique key, likely further qualifies the application condition or type. Collectively, these columns allow administrators to define a ranked list (sequence) of fee types, dictating that payments are applied to the first eligible fee type in the hierarchy before moving to the next.

Common Use Cases and Queries

The primary use case is configuring and auditing the automated payment application engine. A system administrator would query this table to review or troubleshoot the payment allocation logic for a specific hierarchy. A common reporting need is to list all fee application rules in sequence for a given hierarchy. A sample SQL query for this would be:

  • SELECT fee_type, rule_type FROM igs_fi_app_rules WHERE appl_hierarchy_id = <ID> ORDER BY <sequence_column>;

Another critical scenario involves impact analysis before modifying a fee type; a query would identify all application hierarchies and rules that reference that fee type to assess the downstream effect of the change.

Related Objects

The table has a direct and documented foreign key relationship with the IGS_FI_A_HIERARCHIES table, which defines the master Application Hierarchies. The relationship is maintained via the APPL_HIERARCHY_ID column in IGS_FI_APP_RULES, which references the primary key of IGS_FI_A_HIERARCHIES. This means that every record in IGS_FI_APP_RULES must belong to a valid, pre-defined hierarchy in IGS_FI_A_HIERARCHIES. The rules are child details to the hierarchy header. Given the table's purpose, it would also have logical, though not necessarily foreign-key constrained, relationships with core fee tables like IGS_FI_FEE_TYPE and payment application engine packages within the IGS Financials module.

  • Table: IGS_FI_APP_RULES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_APP_RULES,  object_name:IGS_FI_APP_RULES,  status:VALID,  product: IGS - Student System ,  description: Contains information about each Application Rules associated to an Application Hierarchy that you define. The information captured here are Fee Types and sequence in which these Fee Types would be selected for application purposes. ,  implementation_dba_data: IGS.IGS_FI_APP_RULES , 

  • View: IGS_FI_ADL_APP_RUL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_ADL_APP_RUL_V,  object_name:IGS_FI_ADL_APP_RUL_V,  status:VALID,  product: IGS - Student System ,  description: This view selects those records from the application hierarchy rules table that are of Rule type 'ADDITION' ,  implementation_dba_data: APPS.IGS_FI_ADL_APP_RUL_V , 

  • View: IGS_FI_APP_RULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_APP_RULES_V,  object_name:IGS_FI_APP_RULES_V,  status:VALID,  product: IGS - Student System ,  description: This view selects those records from the Application Hierarchy Rules table that are of Rule type 'ALLOW' only ,  implementation_dba_data: APPS.IGS_FI_APP_RULES_V , 

  • Table: IGS_FI_A_HIERARCHIES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_A_HIERARCHIES,  object_name:IGS_FI_A_HIERARCHIES,  status:VALID,  product: IGS - Student System ,  description: Captures application hierarchies setup information from the Define Application Hierarchy form along with information about the credit type associated with this hierarchy. ,  implementation_dba_data: IGS.IGS_FI_A_HIERARCHIES ,