Search Results fnd_security_groups

Overview

The FND_SECURITY_GROUPS table is a core data security repository within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It defines and stores the distinct security groups that enable a service bureau or multi-organization data partitioning model. Its primary role is to act as a master reference for segregating application data, allowing a single EBS installation to securely host data for multiple, independent entities. This segregation is fundamental to implementing data security policies at the responsibility and data level, ensuring users from one entity cannot access the data of another.

Key Information Stored

The table's structure is centered on uniquely identifying each security group. The primary key is the SECURITY_GROUP_ID, a numeric system-generated identifier used for internal joins and foreign key relationships. The SECURITY_GROUP_KEY serves as a unique, user-facing identifier or code for the security group, often used in setup and configuration. While the provided ETRM excerpt does not list all columns, typical implementations may include columns for the security group name, description, and status. The table's design ensures that each data partition is represented by a single, discrete record.

Common Use Cases and Queries

The primary use case is administering and reporting on the defined data partitions within an EBS instance. System administrators use this table to verify existing security group setups or to troubleshoot data visibility issues. Common queries include listing all configured security groups and identifying which security groups are assigned to specific application entities, such as lookup types. A fundamental reporting query is:

• SELECT security_group_id, security_group_key FROM apps.fnd_security_groups ORDER BY security_group_key;

Another critical use case involves joining with related tables, like FND_LOOKUP_TYPES, to understand which lookups are partitioned by which security group, ensuring data isolation policies are correctly implemented.

Related Objects

As indicated by the foreign key relationships in the metadata, FND_SECURITY_GROUPS is a parent table to several key application objects. The FND_LOOKUP_TYPES table references it, partitioning seeded and user-defined lookups by security group. The AP_WEB_PROXY_ASSIGNMENTS and GL_DEFAS_RESP_ASSIGN tables also reference it, linking security groups to specific proxy assignments and responsibility assignments for deferred approval workflows in General Ledger, respectively. These relationships demonstrate how the security group concept permeates various EBS modules to enforce consistent data security.