Search Results user_attrib_value

Overview

The IGS.IGS_SC_PER_ATTR_VALS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Internet Global Services) product family. Its primary role is to store security attribute information at the individual person level. This table functions as a junction or assignment table, linking a person (PERSON_ID) to specific security attributes (USER_ATTRIB_ID) and their assigned values (USER_ATTRIB_VALUE). This structure is fundamental for implementing user-based security models, access controls, and personalized data segregation rules within the IGS modules.

Key Information Stored

The table's design centers on three mandatory key columns that form a unique composite primary key. The PERSON_ID column stores the unique identifier for a person, typically corresponding to a record in a person master table. The USER_ATTRIB_ID column holds a numeric identifier that references a specific security attribute definition, which would be stored in a separate setup or lookup table. The USER_ATTRIB_VALUE column, a VARCHAR2(260), stores the actual value assigned to that specific attribute for the specific person, such as a department code, location ID, or a custom security flag. The table is rounded out by the standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing all changes to these security assignments.

Common Use Cases and Queries

This table is central to security and data access reporting. A common use case is auditing which security attributes and values are assigned to a specific user or a set of users, often for compliance or troubleshooting access issues. Another key scenario involves generating a master list of all person-attribute assignments for analysis or migration. The following query patterns are typical:

• Retrieve all attributes for a specific person: SELECT * FROM igs.igs_sc_per_attr_vals WHERE person_id = <person_id>;
• Find all persons with a specific attribute value: SELECT person_id FROM igs.igs_sc_per_attr_vals WHERE user_attrib_id = <attrib_id> AND user_attrib_value = '<value>';
• Full data extract for reporting: The standard query provided in the metadata: SELECT person_id, user_attrib_id, user_attrib_value, creation_date, created_by, last_updated_by, last_update_date, last_update_login FROM igs.igs_sc_per_attr_vals;

Related Objects

Based on the provided dependency information, the IGS_SC_PER_ATTR_VALS table is a foundational object referenced by other components within the application. The metadata explicitly states it is referenced by an object named IGS_SC_PER_ATTR_VALS under the APPS schema, which is most likely a public synonym or a view that provides a non-schema-qualified access point for application code and standard reports. While the specific tables for PERSON (e.g., PER_ALL_PEOPLE_F) or the security attribute definitions (USER_ATTRIB_ID lookup) are not listed in the dependencies, they are logically related. The table's unique constraint, IGS_SC_PER_ATTR_VALS_PK, enforces data integrity on the core PERSON_ID, USER_ATTRIB_ID, and USER_ATTRIB_VALUE combination.