Search Results igs_sc_obj_functns_uk

Overview

The IGS_SC_OBJ_FUNCTNS table is a core repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the IGS (Internet Global Services) schema. It functions as a master table for defining and storing Security Object Functions. These functions represent specific, user-defined actions or operations that can be performed on business objects. The table's primary role is to establish a controlled association between these executable functions and the broader security object groups defined within the system, thereby enabling granular, function-level security controls and permissions management for application features.

Key Information Stored

The table's structure is designed to uniquely identify each function and its security context. The key columns are:

• FUNCTION_ID: A unique numeric identifier for each security function, typically populated by a sequence generator.
• OBJ_GROUP_ID: A critical foreign key column that links the function to a specific security object group defined in the parent table, IGS_SC_OBJ_GROUPS. This relationship is the foundation for grouping related functions under a common security umbrella.
• FUNCTION_NAME: A user-defined name (up to 260 characters) that describes the specific function or action, such as 'CREATE', 'APPROVE', or 'VIEW_DETAILS'.
• Standard Who Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the creation and modification history of each record, adhering to Oracle EBS standards.

The presence of a unique constraint (IGS_SC_OBJ_FUNCTNS_UK) on the combination of OBJ_GROUP_ID and FUNCTION_NAME enforces business logic, preventing duplicate function definitions within the same object group.

Common Use Cases and Queries

This table is central to security configuration and auditing. Common use cases include analyzing the security functions available for a specific object group, troubleshooting permission issues, and generating master lists for security administration. A fundamental query to retrieve all functions for a known object group identifier would be:

SELECT FUNCTION_ID, FUNCTION_NAME, CREATION_DATE, CREATED_BY FROM IGS.IGS_SC_OBJ_FUNCTNS WHERE OBJ_GROUP_ID = <group_id> ORDER BY FUNCTION_NAME;

For comprehensive reporting, a join with the parent object groups table is typical to provide context:

SELECT og.OBJ_GROUP_NAME, ofunc.FUNCTION_NAME, ofunc.CREATED_BY, ofunc.CREATION_DATE FROM IGS.IGS_SC_OBJ_FUNCTNS ofunc, IGS.IGS_SC_OBJ_GROUPS og WHERE ofunc.OBJ_GROUP_ID = og.OBJ_GROUP_ID ORDER BY og.OBJ_GROUP_NAME, ofunc.FUNCTION_NAME;

Related Objects

The IGS_SC_OBJ_FUNCTNS table sits within a hierarchical security model. Its primary relationship is with the IGS_SC_OBJ_GROUPS table, from which it derives the OBJ_GROUP_ID. This table is also referenced by other security objects within the APPS and IGS schemas, as indicated by its dependency information. These referencing objects, which may include mapping tables, views, or security assignment entities, utilize the FUNCTION_ID as a foreign key to link security profiles and responsibilities to the specific functions defined in this master table, completing the security authorization framework.