Search Results igs_ru_named_rule




Overview
Explore in AI Chat

Overview

The IGS_RU_NAMED_RULE table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed for the management of institutional rules. It serves as a central repository for "named rules," which are pre-defined, reusable rule definitions that can be applied across various student-related processes. Its primary role is to link a logical rule name and its configuration to the underlying rule logic and descriptive elements stored in related tables, thereby enabling the consistent enforcement of academic, administrative, and business policies. It is critical to note that the ETRM metadata explicitly marks the IGS product line as "Obsolete," indicating this table is part of a legacy codebase that may be deprecated in favor of newer solutions in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The central column is RUL_SEQUENCE_NUMBER, which serves as the table's primary key and uniquely identifies each named rule record. This column is also a foreign key referencing the IGS_RU_RULE table, linking the named rule to its core definition and executable logic. Other critical foreign key columns include RUD_SEQUENCE_NUMBER, which links to descriptive text in IGS_RU_DESCRIPTION, and RUG_SEQUENCE_NUMBER, which associates the rule with a logical grouping in IGS_RU_GROUP. An additional foreign key, MESSAGE_RULE, also references IGS_RU_RULE, potentially linking to a separate rule governing message generation.

Common Use Cases and Queries

This table is primarily accessed for system configuration and troubleshooting within the rule engine. A common administrative task is to query all named rules within a specific rule group for validation or audit purposes. A typical SQL pattern would join to the related description and group tables for a comprehensive view:

  • SELECT nr.RUL_SEQUENCE_NUMBER, rd.DESCRIPTION, rg.GROUP_NAME FROM IGS_RU_NAMED_RULE nr JOIN IGS_RU_DESCRIPTION rd ON nr.RUD_SEQUENCE_NUMBER = rd.RUD_SEQUENCE_NUMBER JOIN IGS_RU_GROUP rg ON nr.RUG_SEQUENCE_NUMBER = rg.RUG_SEQUENCE_NUMBER WHERE ...;

Another key use case is identifying all rule items or call rules that depend on a specific named rule, which is essential for impact analysis before modifying or deactivating a rule definition.

Related Objects

The IGS_RU_NAMED_RULE table maintains documented foreign key relationships with several other rule engine tables, as per the provided metadata:

  • IGS_RU_DESCRIPTION: Joined via IGS_RU_NAMED_RULE.RUD_SEQUENCE_NUMBER. Provides descriptive text for the named rule.
  • IGS_RU_GROUP: Joined via IGS_RU_NAMED_RULE.RUG_SEQUENCE_NUMBER. Categorizes the named rule into a functional grouping.
  • IGS_RU_RULE (Two Relationships): 1) Joined via IGS_RU_NAMED_RULE.RUL_SEQUENCE_NUMBER (primary rule logic). 2) Joined via IGS_RU_NAMED_RULE.MESSAGE_RULE (message rule logic).
  • IGS_RU_ITEM: References this table via its NAMED_RULE column. Represents specific rule elements that utilize this named rule.
  • IGS_RU_CALL_RULE: References this table via IGS_RU_CALL_RULE.NR_RUL_SEQUENCE_NUMBER. Represents procedural calls to execute this named rule.