Search Results obj_attrib_name




Overview
Explore in AI Chat

Overview

The IGS.IGS_SC_OBJ_ATTRIBS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Grants Accounting) product family. Its primary function is to store metadata defining security object attributes. These attributes are user-defined properties or characteristics that can be assigned to security objects, which are themselves grouped within object groups. This table plays a critical role in the configuration and management of a flexible, attribute-based security model, enabling granular control and classification of objects within the grants management framework.

Key Information Stored

The table's structure is designed to manage the lifecycle and definition of these security attributes. The most critical columns include:

  • OBJ_ATTRIB_ID: The primary key, a unique system-generated identifier for each attribute record.
  • OBJ_GROUP_ID: A foreign key linking the attribute to its parent object group, as defined in the IGS_SC_OBJ_GROUPS table. This relationship is enforced by the unique IGS_SC_OBJ_ATTRIBS_UK index on OBJ_GROUP_ID and OBJ_ATTRIB_NAME.
  • OBJ_ATTRIB_NAME: The user-defined name of the attribute (e.g., "Region," "Sensitivity Level"). The combination of this name and the OBJ_GROUP_ID must be unique.
  • ACTIVE_FLAG: A status indicator used to mark attributes that are no longer in use, facilitating soft deletion and historical reporting without removing the record.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): These audit columns track the creation and modification history of each attribute definition.

Common Use Cases and Queries

This table is central to administrative setup and security reporting. A common use case involves querying all active attributes for a specific object group to understand the security dimensions available for assignment. For instance, an administrator needing to audit the configuration might run a query to list attributes by group:

SELECT og.obj_group_name, oa.obj_attrib_name, oa.creation_date
FROM igs.igs_sc_obj_attribs oa,
igs.igs_sc_obj_groups og
WHERE oa.obj_group_id = og.obj_group_id
AND oa.active_flag = 'Y'
ORDER BY og.obj_group_name, oa.obj_attrib_name;

Another frequent operation is validating the uniqueness of an attribute name within a group before an insert or update. The table is typically accessed via the application's security administration forms, and direct SQL queries are used for data validation, migration scripts, and custom security reports.

Related Objects

The IGS_SC_OBJ_ATTRIBS table has a defined relationship with the IGS_SC_OBJ_GROUPS table via the OBJ_GROUP_ID column. This is a foreign key relationship where OBJ_GROUP_ID in IGS_SC_OBJ_ATTRIBS references the primary key of IGS_SC_OBJ_GROUPS. The table is also referenced by other objects within the APPS schema, as indicated in the dependencies. While the specific referencing objects are not listed, in a typical EBS security model, this table would be referenced by junction tables that assign specific attribute values to security objects or by views that consolidate security metadata for reporting.