Security List Maintanence Program Not Completing

(Doc ID 865603.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Human Resources - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
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