Search Results per_organization_list




Overview
Explore in AI Chat

Overview

The PER_ORGANIZATION_LIST table is a core security object within the Oracle E-Business Suite Human Resources (PER) module. It functions as a detailed access control list, explicitly defining the set of organizations a user can access based on their assigned security profile. This table is fundamental to the implementation of data security in HRMS, enabling the restriction of user visibility and transactional capabilities to specific business units, departments, or other organizational entities as defined in the HR_ALL_ORGANIZATION_UNITS table. Its role is to store the granular mapping between security profiles, users, and the permitted organizations, thereby enforcing row-level security for HR data.

Key Information Stored

The table's structure is designed to store the essential components of this security mapping. The primary columns are SECURITY_PROFILE_ID, which references the security profile definition in PER_SECURITY_PROFILES; ORGANIZATION_ID, which references the specific organizational unit in HR_ALL_ORGANIZATION_UNITS; and USER_ID, which identifies the individual user. The presence of two unique keys highlights the table's dual-purpose design: the primary key (PER_ORGANIZATION_LIST_PK) enforces uniqueness on the profile-organization combination, likely for profile-level definitions, while the alternate key (PER_ORGANIZATION_LIST_UK1) includes the USER_ID, allowing for user-specific overrides or assignments within a given security profile.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting user access. System administrators frequently query this table to verify or report on which organizations are accessible to a particular user or security profile. A common query pattern involves joining to PER_SECURITY_PROFILES and HR_ALL_ORGANIZATION_UNITS to translate IDs into meaningful names. For example:

  • To list all organizations accessible to a specific user: SELECT hou.name FROM per_organization_list pol, hr_all_organization_units hou WHERE pol.organization_id = hou.organization_id AND pol.user_id = :user_id;
  • To identify all users with access to a specific organization: SELECT pol.user_id FROM per_organization_list pol WHERE pol.organization_id = :org_id;

This table is also critical for background security processing, as the HRMS security model dynamically filters queries based on its contents.

Related Objects

PER_ORGANIZATION_LIST has defined foreign key relationships with two key HRMS tables, forming the backbone of its security model:

  • PER_SECURITY_PROFILES: The table PER_ORGANIZATION_LIST references PER_SECURITY_PROFILES via the column SECURITY_PROFILE_ID. This links the organization list to a specific security profile definition.
  • HR_ALL_ORGANIZATION_UNITS: The table PER_ORGANIZATION_LIST references HR_ALL_ORGANIZATION_UNITS via the column ORGANIZATION_ID. This validates and provides descriptive context for the organizational units a user is permitted to access.

These relationships ensure referential integrity, guaranteeing that every entry in the access list corresponds to a valid security profile and a valid organization within the system.