Deadlock Error In Package PAY_PPM_INS When Creating Personal Payment Method From API
(Doc ID 2054787.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Core Payroll
Profile "Flexfields:Shared Table Lock" = Yes
When attempting to use API to load and update personal payment methods of 10+ employees, the following error occurs.
ORA-00060: deadlock detected while waiting for resource, N, SQLSTR, insert
into PAY_EXTERNAL_ACCOUNTS (EXTERNAL_ACCOUNT_ID, ID_FLEX_NUM, ENABLED_FLAG,
SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE,
LAST_UPDATED_BY, SEGMENT5, SEGMENT6,
The issue has the following business impact:
Due to this issue, users cannot complete the personal payment method for the employees.
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