Security List Maintanence Program Not Completing
Last updated on MARCH 27, 2018
Applies to:Oracle Human Resources - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.
On 11.5.10 in Production:
Find that the Security List Maintenance (SLM) Program is not completing.
Expect that the Security List Maintenance Program should complete within 1 to 1:30 Hrs.
The issue can be reproduced at will with the following steps:
1. Run the SLM manually or schedule it for all security profiles.
2. Tables PER_SECURITY_PROFILES and PER_PERSON_LIST get locked.
3. Process doesn't complete. It keep running for more than 10 Hours.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms