Search Results igs_sc_obj_att_vals

Overview

The IGS_SC_OBJ_ATT_VALS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) modules, including versions 12.1.1 and 12.2.2. It functions as a junction table within the application's security architecture, specifically designed to manage granular access control. Its primary role is to store the specific attribute values that are linked to security object attributes, thereby defining the permissible data scopes or conditions for secured objects. This table enables the implementation of row-level or attribute-based security rules, ensuring users can only access data pertinent to their assigned security profile within the Student System.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical foreign key columns. The OBJ_ATTRIB_ID column references a specific security object attribute defined in the IGS_SC_OBJ_ATTRIBS table, such as an "Organization ID" or "Person ID" attribute. The OBJECT_ID column references a secured application object registered in the FND_OBJECTS table. Together, a record in this table signifies that a particular value for a given attribute is associated with a specific secured object instance. While the provided metadata focuses on the key relationships, typical implementations would include a column (e.g., ATTRIBUTE_VALUE) to store the actual data value that defines the security rule, such as 'HR_DEPT' or a specific numeric identifier.

Common Use Cases and Queries

This table is central to security administration and troubleshooting access issues. A common use case involves auditing the security constraints applied to a specific object. For example, an administrator may need to list all attribute values restricting access to a particular student academic program (object). A typical query would join IGS_SC_OBJ_ATT_VALS with IGS_SC_OBJ_ATTRIBS to get the attribute name and FND_OBJECTS to get the object name. Another critical scenario is during the security validation process when the system checks if a user's profile attributes match any values stored in IGS_SC_OBJ_ATT_VALS for the object they are attempting to access. Sample reporting SQL often follows this pattern:

• SELECT obj.obj_name, attr.obj_attrib_name, val.attribute_value
• FROM igs_sc_obj_att_vals val,
• fnd_objects obj,
• igs_sc_obj_attribs attr
• WHERE val.object_id = obj.obj_id
• AND val.obj_attrib_id = attr.obj_attrib_id
• AND obj.obj_name = 'STUDENT_RECORD';

Related Objects

The IGS_SC_OBJ_ATT_VALS table is a dependent entity within a well-defined security object model. Its relationships are strictly documented through foreign key constraints. It directly depends on the FND_OBJECTS table (via OBJECT_ID), which is a central EBS repository for all application objects, and the IGS_SC_OBJ_ATTRIBS table (via OBJ_ATTRIB_ID), which defines the allowable security attributes for the Student System. As a junction table, it is typically the child in these relationships. It is commonly referenced by security profile assignment tables or views that aggregate these attribute values into a usable security rule set for a user or responsibility. The documented foreign key relationships are:

• References FND_OBJECTS on column: IGS_SC_OBJ_ATT_VALS.OBJECT_ID = FND_OBJECTS.OBJ_ID
• References IGS_SC_OBJ_ATTRIBS on column: IGS_SC_OBJ_ATT_VALS.OBJ_ATTRIB_ID = IGS_SC_OBJ_ATTRIBS.OBJ_ATTRIB_ID