Search Results per_all_assignments_f_perf

The PER_SECURITY_PERF_TABLE lookup type in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component within the Oracle Human Resources (HRMS) module, specifically designed to manage security and performance-related access controls. This lookup type is part of Oracle's comprehensive security framework, which ensures that sensitive employee performance data is accessible only to authorized users based on predefined business rules. Below is a detailed analysis of its purpose, structure, and implementation in Oracle EBS.

Purpose and Functionality

The PER_SECURITY_PERF_TABLE lookup type serves as a configuration mechanism to define security rules governing access to performance-related tables in Oracle HRMS. It is primarily used in conjunction with Oracle's Performance Management and Talent Management modules to enforce row-level and column-level security. This ensures that managers, HR personnel, and other stakeholders can only view or modify performance data for employees within their authorized scope, such as their direct reports or specific organizational hierarchies.

Technical Implementation

In Oracle EBS 12.1.1 and 12.2.2, lookup types are stored in the FND_LOOKUP_TYPES and FND_LOOKUP_VALUES tables. The PER_SECURITY_PERF_TABLE lookup type contains predefined values that map to specific security rules or access levels. These values are referenced by Oracle's security engine to dynamically filter data access. For example, a lookup value might define whether a manager can view performance appraisals for employees in a specific business unit or job role.

Key Lookup Values

The lookup values associated with PER_SECURITY_PERF_TABLE typically include:

ACCESS_LEVEL: Defines hierarchical access (e.g., SELF, DIRECT_REPORTS, ALL_ORG).
PERFORMANCE_TABLE: Specifies the underlying HR table (e.g., PER_PERFORMANCE_REVIEWS) to which the security rule applies.
SECURITY_CONTEXT: Determines whether access is restricted by organization, position, or other criteria.

Integration with Oracle HRMS Security

This lookup type integrates with Oracle's Security Profiles and Data Groups to enforce granular access controls. When a user queries performance data, the system cross-references their assigned security profile with the rules defined in PER_SECURITY_PERF_TABLE to filter results. For instance, a manager with a security profile limited to their department will only see performance records for employees in that department.

Customization and Extensibility

Organizations can extend or modify the default lookup values to align with unique business requirements. Custom values can be added via the Oracle Application Developer responsibility (Application Developer > Application > Lookups). However, caution is advised to avoid conflicts with existing security rules.

Impact on Performance and Reporting

The proper configuration of PER_SECURITY_PERF_TABLE is crucial for optimizing query performance. Overly restrictive rules may increase query complexity, while overly permissive settings could compromise data security. Regular audits of lookup values are recommended to ensure alignment with organizational policies.

Conclusion

The PER_SECURITY_PERF_TABLE lookup type is a foundational element of Oracle EBS HRMS security, enabling precise control over performance data access. Its correct implementation ensures compliance, data integrity, and efficient performance management processes. Administrators should leverage Oracle's documentation and testing environments to validate configurations before deploying changes in production.

APPS.HR_SECURITY_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F_PERF 12.2.2
APPS.HR_SECURITY_INTERNAL dependencies on FND_FILE 12.2.2
APPS.HR_SECURITY_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F 12.2.2
APPS.HR_SECURITY_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F 12.2.2
VIEW: HR.PER_ALL_ASSIGNMENTS_F_PERF# 12.2.2
owner:HR, object_type:VIEW, object_name:PER_ALL_ASSIGNMENTS_F_PERF#, status:VALID,
VIEW: HR.PER_ALL_ASSIGNMENTS_F_PERF# 12.2.2
Lookup Type: PER_SECURITY_PERF_TABLE 12.2.2
product: PER - Human Resources , meaning: HRMS Security Performance Tables , description: HRMS Security Performance Tables ,
SYNONYM: APPS.PER_ALL_ASSIGNMENTS_F_PERF 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_ALL_ASSIGNMENTS_F_PERF, status:VALID,
TRIGGER: APPS.PER_ASG_PERF_TRG 12.2.2
Concurrent Program: PERSPERF 12.2.2
execution_filename: hr_security_internal.populate_asg_perf_table , product: PER - Human Resources , user_name: PERSPERF , description: Populate PER_ALL_ASSIGNMENTS_F_PERF with data from PER_ALL_ASSIGNMENTS_F , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
TABLE: HR.PER_ALL_ASSIGNMENTS_F_PERF 12.2.2
owner:HR, object_type:TABLE, object_name:PER_ALL_ASSIGNMENTS_F_PERF, status:VALID,
PACKAGE BODY: APPS.HR_SECURITY_INTERNAL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_SECURITY_INTERNAL, status:VALID,
TRIGGER: APPS.PER_ASG_PERF_TRG 12.2.2
owner:APPS, object_type:TRIGGER, object_name:PER_ASG_PERF_TRG, status:VALID,
APPS.HR_SECURITY_INTERNAL dependencies on HR_UTILITY 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.HR_SECURITY_INTERNAL SQL Statements 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.HR_SECURITY_INTERNAL dependencies on FND_PROFILE 12.2.2
PACKAGE: APPS.HR_SECURITY_INTERNAL 12.2.2
PACKAGE BODY: APPS.HR_SECURITY_INTERNAL 12.2.2
12.2.2 DBA Data 12.2.2