Search Results igs_ru_named_rule_gr




Overview
Explore in AI Chat

Overview

The IGS_RU_NAMED_RULE_GR table is a core data structure within the Oracle E-Business Suite Student System (IGS). It functions as the master definition table for Named Rule Groups. In the context of the EBS rule engine, a Named Rule Group is a logical container that associates a specific rule or set of rules (defined elsewhere) with a unique, user-defined identifier. This object is critical for the modular and reusable configuration of complex business logic governing academic processes, such as progression, graduation eligibility, or prerequisite checking. Its status as VALID confirms its active role in both the 12.1.1 and 12.2.2 releases of the application.

Key Information Stored

The table's primary purpose is to define the key attributes of a Named Rule Group. The documented primary key, IGS_RU_NDG_PK, is a composite key consisting of the GROUP_CD and NAME_CD columns. This structure indicates that a rule group is uniquely identified by the combination of a group code and a name code. While the full column list is not detailed in the provided metadata, the foreign key relationships reveal other critical data points stored. These include a MESSAGE_GROUP for error handling, a RUG_SEQUENCE_NUMBER likely for ordering or versioning, a SELECT_GROUP for defining rule selection criteria, and an S_RETURN_TYPE (linked to IGS_RU_RET_TYPE) which dictates the data type or format of the result returned when the rule group is evaluated.

Common Use Cases and Queries

This table is primarily accessed for system configuration and rule auditing. Administrators query it to understand the landscape of defined rule groups and their relationships. A common reporting need is to list all Named Rule Groups along with their associated return types. A sample query for such a report would join IGS_RU_NAMED_RULE_GR with the IGS_RU_RET_TYPE table. Another typical use case involves troubleshooting; when a specific business rule fails, support personnel would trace the issue back to its Named Rule Group definition via the GROUP_CD and NAME_CD. The table is also central during the setup of new academic policies, where new rows are inserted to define the rule containers that will be executed by the application's rule processing engine.

Related Objects

The IGS_RU_NAMED_RULE_GR table is integral to the rule subsystem, with several documented foreign key relationships. The primary key (GROUP_CD, NAME_CD) is referenced by the IGS_RU_NRG_GROUP_CD foreign key, indicating child tables that depend on this specific definition. Crucially, it has multiple foreign key dependencies on the IGS_RU_GROUP table, linking through the MESSAGE_GROUP, RUG_SEQUENCE_NUMBER, and SELECT_GROUP columns. This suggests that IGS_RU_GROUP holds more granular rule or group component definitions. Furthermore, the S_RETURN_TYPE column is a foreign key to the IGS_RU_RET_TYPE table, which standardizes the possible return value types for rule evaluations. These relationships form a network where IGS_RU_NAMED_RULE_GR acts as a central hub connecting rule logic (IGS_RU_GROUP), return type metadata (IGS_RU_RET_TYPE), and subordinate rule details.