Security List Maintenance Request Set- ORACLE error 60 in FDPSTP (Doc ID 1905554.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Human Resources - Version 12.0.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.5 version, Security Issues

Since upgrading from R11i to R12.1, when attempting to run their security list maintenance request set,
the following error occurs.
Running the 'Security List Maintenance' concurrent process alone (outside any request set) does not cause the error

ERROR
-----------------------
ORACLE error 60 in FDPSTP

Cause: FDPSTP failed due to ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "APPS.PAY_PYUCSLIS_PKG", line 1997
ORA-06512: at "APPS.PAY_PYUCSLIS_PKG", line 5933
ORA-06512: at "APPS.PAY_PYUCSLIS_PKG", line 54


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Security List Maintenance for this one profile



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