Search Results per_person_list




Overview
Explore in AI Chat

Overview

The PER_PERSON_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 people (employees, applicants, contacts, etc.) that a specific user is authorized to view and process. This table is central to the implementation of data security profiles, which restrict user access to HR data based on criteria such as organization, position, or payroll. By storing a direct mapping between a user, a security profile, and individual person records, the table provides the granular data-level security required for compliance and operational integrity in multi-organization deployments.

Key Information Stored

The table's structure is designed to enforce a unique relationship between a security profile, a person, and the user granted access. Its primary columns are defined by its composite primary and unique keys. The SECURITY_PROFILE_ID column references a specific security profile definition from the PER_SECURITY_PROFILES table. The PERSON_ID column holds the unique identifier for an individual from the PER_ALL_PEOPLE_F table. The GRANTED_USER_ID column stores the identifier (from FND_USER) for the user who is permitted to access the specified person record under the given security profile. The presence of a row in this table signifies an explicit access grant.

Common Use Cases and Queries

This table is primarily used by the application's security engine during data retrieval and transaction processing. A common operational query is to determine all persons accessible to a current user for a report or form. For example, to list accessible employees for user 1234 under security profile 100, one might execute:

  • SELECT DISTINCT papf.person_id, papf.full_name FROM per_person_list ppl, per_all_people_f papf WHERE ppl.person_id = papf.person_id AND ppl.granted_user_id = 1234 AND ppl.security_profile_id = 100 AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date;

System administrators may query this table to audit security assignments or troubleshoot data visibility issues, often joining to FND_USER to see usernames and to PER_SECURITY_PROFILES for profile names.

Related Objects

PER_PERSON_LIST has a direct and critical foreign key relationship with the PER_SECURITY_PROFILES table on the SECURITY_PROFILE_ID column. This enforces that every entry in the access list is tied to a valid, defined security profile. While not explicitly listed in the provided metadata, the PERSON_ID column logically references the PER_ALL_PEOPLE_F table, and the GRANTED_USER_ID column references the FND_USER table. The table is a foundational component for security views and is heavily referenced by the HR data security APIs and packages that manage profile assignments and evaluate user access in real-time.