Search Results called_rule_cd

Overview

The IGS_RU_CALL_RULE table is a system reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. Its primary role is to manage the mapping between rule call codes and their corresponding rule numbers. This table acts as a lookup or cross-reference mechanism, enabling the system to execute or reference specific business rules, such as those governing academic progression, enrollment eligibility, or fee calculations, by a logical code. Its design as a simple, two-column core table with standard WHO columns indicates it is a foundational object for the rule engine in the student system.

Key Information Stored

The table stores a minimal but critical set of columns for rule identification and auditing. The two primary business columns are CALLED_RULE_CD and NR_RUL_SEQUENCE_NUMBER. CALLED_RULE_CD is a mandatory, unique VARCHAR2(10) column that stores a short, logical code representing a rule call. NR_RUL_SEQUENCE_NUMBER is a mandatory NUMBER column that holds the numerical identifier for the called rule. This column is indexed (IGS_RU_CALL_RULE_N1) for performance in lookups and is also a foreign key to the IGS_RU_NAMED_RULE table, linking the call code to the full rule definition. The remaining columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are standard EBS WHO columns for tracking data origin and modifications.

Common Use Cases and Queries

This table is central to operations where a business process needs to invoke a rule by a predefined code. A common use case is within PL/SQL program units or form logic where a specific rule number must be dynamically retrieved using its call code to evaluate student records. For reporting and troubleshooting, queries often join this table to the main rule definition table. A fundamental query to retrieve all mappings is: SELECT called_rule_cd, nr_rul_sequence_number FROM igs.igs_ru_call_rule ORDER BY 1;. To investigate the full rule details associated with a call code, a typical join pattern is: SELECT cr.called_rule_cd, cr.nr_rul_sequence_number, nr.rule_name FROM igs.igs_ru_call_rule cr, igs.igs_ru_named_rule nr WHERE cr.nr_rul_sequence_number = nr.nr_rul_sequence_number;. Administrators may also query this table to audit or validate rule setup configurations.

Related Objects

The IGS_RU_CALL_RULE table has defined relationships with other key objects in the rule subsystem. Its primary key, IGS_RU_CALL_RULE_PK, is defined on the CALLED_RULE_CD column. Crucially, it has a foreign key relationship where the NR_RUL_SEQUENCE_NUMBER column references the IGS_RU_NAMED_RULE table. This relationship ensures that every call code maps to a valid, existing rule definition. The table is also referenced by an APPS synonym (IGS_RU_CALL_RULE), which is the standard access point for all EBS application code, ensuring a public interface is available. There are no documented dependencies where this table references other objects, confirming its role as a terminal reference point for rule codes.