My Oracle Support Banner

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

Last updated on OCTOBER 12, 2021

Applies to:

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


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

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.