Search Results description_number

Overview

The IGS_RU_GROUP_ITEM table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as a junction or mapping table that defines the composition of rule groups. Its primary role is to associate individual rule elements—which can be either single rules (RUD) or nested rule groups (RUG)—with a parent rule group. This hierarchical structuring is essential for building complex, reusable business logic and validation rules within the student lifecycle management modules, such as admissions, enrollment, and academic progression.

Key Information Stored

The table stores the associative relationships between rule groups and their constituent items. Key columns include:

• RUG_SEQUENCE_NUMBER (NUMBER): The primary identifier for the parent rule group. This is the key field referenced in user searches and is part of the table's unique constraint.
• DESCRIPTION_NUMBER (NUMBER): The identifier for the child item being associated with the group.
• DESCRIPTION_TYPE (VARCHAR2(10)): A code specifying the type of the child item, typically 'Rud' for a rule or 'Rug' for another rule group, enabling nested structures.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the creation and modification history of each record.

The unique index IGS_RU_GROUP_ITEM_U1 on (DESCRIPTION_NUMBER, DESCRIPTION_TYPE, RUG_SEQUENCE_NUMBER) ensures that a specific rule or group is not duplicated within a parent rule group.

Common Use Cases and Queries

This table is central to querying and reporting on the definition of business rules. A common use case is analyzing the complete composition of a specific rule group to understand its logic or for impact analysis before a change. Administrators may also query it to find all parent groups that contain a particular rule. A fundamental query to retrieve all items for a given rule group would be:

SELECT DESCRIPTION_NUMBER, DESCRIPTION_TYPE
FROM IGS.IGS_RU_GROUP_ITEM
WHERE RUG_SEQUENCE_NUMBER = <group_number>
ORDER BY DESCRIPTION_NUMBER;

For a more comprehensive audit report, including creation details, the provided ETRM query can be filtered on RUG_SEQUENCE_NUMBER. Troubleshooting often involves joining this table to rule definition tables (likely named IGS_RU_RULE or similar) based on DESCRIPTION_NUMBER and DESCRIPTION_TYPE to get the descriptive text of the rules within a group.

Related Objects

Based on the provided dependency information, the IGS_RU_GROUP_ITEM table is a foundational object referenced by the APPS schema synonym named IGS_RU_GROUP_ITEM. This synonym allows other EBS application modules to access this table seamlessly. While the excerpt shows it does not reference other objects, it is logically and functionally dependent on the master tables for rules (RUD) and rule groups (RUG), which would store the detailed definitions referenced by DESCRIPTION_NUMBER and DESCRIPTION_TYPE. The table's design suggests it is a child table to a parent rule group header table, which would store the primary details for each RUG_SEQUENCE_NUMBER.