Security List Maintanence Program Not Completing (Doc ID 865603.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Human Resources - Version: 11.5.10
This problem can occur on any platform.

Symptoms

On 11.5.10 in Production:
Find that the Security List Maintenance (SLM) Program is not completing.

EXPECTED BEHAVIOR
Expect that the Security List Maintenance Program should complete within 1 to 1:30 Hrs.

STEPS
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.




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms