Search Results igs_sc_obj_attribs

Overview

The IGS_SC_OBJ_ATTRIBS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master repository for defining security object attributes. In the context of the Student System's security model, these attributes represent specific, granular properties or characteristics of a security object (e.g., a form, function, or data entity) against which access control rules, or grant conditions, can be evaluated. The table's primary role is to provide a centralized, normalized definition of all available security attributes, enabling the system to enforce complex, attribute-based security policies across the student administration functions.

Key Information Stored

The table's central identifier is the OBJ_ATTRIB_ID column, which serves as the primary key and uniquely defines each security attribute record. A critical relational column is OBJ_GROUP_ID, which links the attribute to a broader security object group, logically categorizing related attributes. While the exact descriptive column names are not detailed in the provided metadata, a table of this nature typically includes columns to store the attribute's internal name, a user-friendly description, its data type (e.g., character, number, date), and potentially validation rules. The existence of related tables for attribute methods (IGS_SC_OBJ_ATT_MTHS) and values (IGS_SC_OBJ_ATT_VALS) suggests this table stores the definition, while child tables manage the operational logic and allowed values for each attribute.

Common Use Cases and Queries

This table is primarily accessed during the configuration and administration of the Student System's security model. Common use cases include auditing the complete list of defined security attributes, troubleshooting grant condition failures by tracing back to attribute definitions, and setting up new security rules. A fundamental query retrieves all attributes within a specific object group for review:

• SELECT obj_attrib_id, <descriptive_columns> FROM igs.igs_sc_obj_attribs WHERE obj_group_id = <group_id>;

For integration or data migration scripts, it is often necessary to map internal attribute IDs to their business meanings. Furthermore, reporting on the security model's complexity or generating documentation for audit purposes would involve querying this table to list all available security dimensions.

Related Objects

The IGS_SC_OBJ_ATTRIBS table sits at the center of a key security subsystem, with several important foreign key relationships documented in the ETRM:

• IGS_SC_GRANT_CONDS: This table references IGS_SC_OBJ_ATTRIBS via the OBJ_ATTRIB_ID column. This is the most critical relationship, as it links the attribute definition to the actual security rules (grant conditions) that use it for evaluation.
• IGS_SC_OBJ_ATT_MTHS: References IGS_SC_OBJ_ATTRIBS.OBJ_ATTRIB_ID, likely storing methods or functions used to derive or validate the attribute's value at runtime.
• IGS_SC_OBJ_ATT_VALS: References IGS_SC_OBJ_ATTRIBS.OBJ_ATTRIB_ID, presumably storing the set of permissible values for attributes that have a fixed list of options.
• The table itself contains a foreign key, OBJ_GROUP_ID, which references another table (not named in the snippet, but likely IGS_SC_OBJ_GROUPS or similar) that defines groups of security objects.