Search Results called_rule_cd

Overview

The IGS_RU_CALL_RULE table is a system reference table within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to store reference codes that define relationships between rules, specifically documenting which named rules are invoked or "called" by other rules within the system's rule engine. This table acts as a critical junction for managing complex, hierarchical rule logic, enabling the modular construction and execution of business rules. It is important to note that the provided ETRM metadata explicitly states this object is "Not implemented in this database," indicating it may have been part of a design that was not fully deployed or has been superseded in the specified releases (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is centered on a minimal set of columns to establish rule-calling relationships. The primary data element is the CALLED_RULE_CD, which serves as the unique identifier for each callable rule reference and constitutes the table's primary key (IGS_RU_CALL_RULE_PK). The other documented column, NR_RUL_SEQUENCE_NUMBER, is a foreign key column. This field links the call reference to a specific, defined rule stored in the IGS_RU_NAMED_RULE table, thereby identifying the exact rule that is being invoked.

Common Use Cases and Queries

The primary use case for this table is the analysis and validation of rule dependencies within the Student System's rule framework. System administrators or functional analysts would query it to understand rule hierarchies, identify all rules that call a specific subroutine, or audit rule usage before modifications. A typical query would join IGS_RU_CALL_RULE to IGS_RU_NAMED_RULE to resolve the foreign key reference and retrieve the details of the named rule being called.

Sample Query Pattern:
SELECT cr.called_rule_cd, nr.rule_cd, nr.description
FROM igs_ru_call_rule cr,
igs_ru_named_rule nr
WHERE cr.nr_rul_sequence_number = nr.rul_sequence_number
AND nr.rule_cd = '&RULE_CODE';

Related Objects

This table has documented relationships with the following key objects in the obsolete IGS module:

• Primary Key: IGS_RU_CALL_RULE_PK on column CALLED_RULE_CD.
• Foreign Key (References): The table contains a foreign key where the column IGS_RU_CALL_RULE.NR_RUL_SEQUENCE_NUMBER references the IGS_RU_NAMED_RULE table. This establishes the essential link from a rule call reference to the master definition of the executable rule.