Search Results igs_ps_usec_ru_u2

Overview

The IGS_PS_USEC_RU table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Oracle Student Management) product family. Its primary function is to store rule definitions associated with unit section versions. In the academic context of Oracle Student Management, a unit section (UOO_ID) represents a specific offering or instance of a course unit. This table enables the system to enforce business logic, prerequisites, co-requisites, or other academic policies by linking rule calls (S_RULE_CALL_CD) to these sections. The table's role is critical for maintaining academic integrity and automating compliance checks during student enrollment and progression.

Key Information Stored

The table's columns are designed to manage rule metadata and standard auditing information. The primary unique identifier is the USECRU_ID, a system-generated number. The UOO_ID column stores the foreign key to the specific unit section, while S_RULE_CALL_CD holds the code that identifies which system rule or validation routine to execute. The RUL_SEQUENCE_NUMBER dictates the order in which multiple rules for a single section should be processed. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide full auditability for all changes made to the rule assignments.

Common Use Cases and Queries

A primary use case is the validation of student enrollment requests. When a student attempts to enroll in a unit section, the system queries this table for any associated rules (via UOO_ID) and processes them in sequence to determine eligibility. Administrators use interfaces to maintain these rules, which are persisted in this table. Common reporting queries involve listing all rules for a section or identifying sections that use a specific rule call. A fundamental query pattern is:

• Retrieving all rule assignments for a specific unit section: SELECT * FROM IGS.IGS_PS_USEC_RU WHERE UOO_ID = <section_id> ORDER BY RUL_SEQUENCE_NUMBER;
• Identifying which sections utilize a particular rule: SELECT UOO_ID FROM IGS.IGS_PS_USEC_RU WHERE S_RULE_CALL_CD = '<RULE_CODE>';

Related Objects

Based on the provided metadata, the IGS_PS_USEC_RU table is referenced by the APPS synonym IGS_PS_USEC_RU, which is the standard access point for application code. The table itself has two unique indexes that define its key relationships. The IGS_PS_USEC_RU_U1 index on USECRU_ID enforces the primary key constraint. The IGS_PS_USEC_RU_U2 index, a composite unique constraint on (UOO_ID, S_RULE_CALL_CD), ensures that a specific rule call cannot be duplicated for the same unit section. While explicit foreign key dependencies are not listed in the excerpt, the UOO_ID column logically references a unit sections table (e.g., IGS_PS_UNIT_OFR_OPT), and S_RULE_CALL_CD would reference a code lookup table for system rules, forming the basis for critical joins in application logic.