Deadlock Error In Package PAY_PPM_INS When Creating Personal Payment Method From API
Last updated on MAY 03, 2017
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.
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