Results for “top_organization”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PER_SECURITY_PROFILES_V is a Human Resources (PER) view shipped in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose in ETRM is simply "used to support user interface," meaning it exists primarily to denormalize the underlying security profile configuration data into a user-friendly, display-ready form for the Oracle Forms security profile definition screens and related setup pages. Rather than exposing raw foreign key identifiers, the view resolves those IDs into readable names such as business group, top position, top organization, position hierarchy, and organization hierarchy. It also joins to PER_ALL_PEOPLE_F to resolve the NAMED_PERSON_ID — the person identified in the security profile's named-person restriction — into a formatted full name via PER.FULL_NAME. Because it is a view rather than a table, it stores no data itself; it is a query layer over the base security profile record and its associated structure and business group definitions.

Underlying Base Objects

The view is defined over the following documented objects in the APPS schema:

• PER_SECURITY_PROFILES (synonym) — the driving table; each row is one security profile. All PSP.* columns including SECURITY_PROFILE_ID, NAMED_PERSON_ID, and the various VIEW_ALL_* flags originate here.
• PER_ALL_PEOPLE_F (synonym) — joined to resolve NAMED_PERSON_ID into PER.FULL_NAME.
• PER_BUSINESS_GROUPS_PERF (view) — supplies BUSINESS_GROUP_NAME.
• PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_VERSIONS (synonyms) — supply the organization hierarchy name and current structure version ID.
• PER_POSITION_STRUCTURES and PER_POS_STRUCTURE_VERSIONS (synonyms) — supply the position hierarchy name and version ID.
• HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL (synonyms) — resolve the top organization's translated name.
• HR_GENERAL (package) — the DECODE_POSITION_LATEST_NAME function resolves the top position's name.

The join to PER_BUSINESS_GROUPS_PERF is an outer join (+), so profiles without a resolvable business group name are still returned.

Key Columns

• SECURITY_PROFILE_ID / SECURITY_PROFILE_NAME — primary identifier and descriptive name of the profile.
• BUSINESS_GROUP_ID / BUSINESS_GROUP_NAME — owning business group.
• NAMED_PERSON_ID and PER.FULL_NAME — the named person when the profile restricts access to a specific individual; this is the column most relevant to a "named_person" search.
• POSITION_ID, TOP_POSITION, POSITION_STRUCTURE_ID, POSITION_HIERARCHY, TOP_POSITION_METHOD — top-of-hierarchy position and its structure.
• ORGANIZATION_ID, TOP_ORGANIZATION, ORGANIZATION_STRUCTURE_ID, ORGANIZATION_HIERARCHY, TOP_ORGANIZATION_METHOD — organization hierarchy scope.
• VIEW_ALL_* flags (VIEW_ALL_APPLICANTS_FLAG, VIEW_ALL_EMPLOYEES_FLAG, VIEW_ALL_CWK_FLAG, VIEW_ALL_CONTACTS_FLAG, VIEW_ALL_CANDIDATES_FLAG, VIEW_ALL_ORGANIZATIONS_FLAG, VIEW_ALL_PAYROLLS_FLAG, VIEW_ALL_POSITIONS_FLAG, VIEW_ALL_FLAG) — access scope indicators.
• INCLUDE_TOP_ORGANIZATION_FLAG, INCLUDE_TOP_POSITION_FLAG, INCLUDE_EXCLUDE_PAYROLL_FLAG, EXCLUDE_PERSON_FLAG, EXCLUDE_SECONDARY_ASGS_FLAG, RESTRICT_BY_SUPERVISOR_FLAG, SUPERVISOR_LEVELS, EXCLUDE_BUSINESS_GROUPS_FLAG — restriction controls.
• ORG_SECURITY_MODE, RESTRICT_ON_INDIVIDUAL_ASG, CUSTOM_RESTRICTION_FLAG, RESTRICTION_TEXT, ALLOW_GRANTED_USERS_FLAG, REPORTING_ORACLE_USERNAME — additional security semantics.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and ROW_ID.

Common Use Cases and Queries

Typical use is reporting on or validating security profile configuration, especially locating profiles tied to a named person.

List all profiles and their named person:

SELECT security_profile_id, security_profile_name, named_person_id, full_name
FROM apps.per_security_profiles_v;

Find profiles referencing a specific named person:

SELECT security_profile_name, business_group_name, named_person_id, full_name
FROM apps.per_security_profiles_v
WHERE named_person_id = :p_person_id;

Review hierarchy scope for a business group:

SELECT security_profile_name, top_position, position_hierarchy,
       top_organization, organization_hierarchy
FROM apps.per_security_profiles_v
WHERE business_group_id = :p_bg_id;

Because the view performs outer joins and function calls, queries filtering on NAMED_PERSON_ID or SECURITY_PROFILE_ID return most efficiently; ad hoc reports should avoid unrestricted full scans in high-volume environments.