Deadlock Error In Package PAY_PPM_INS When Creating Personal Payment Method From API (Doc ID 2054787.1)

Last updated on MAY 03, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Core Payroll

Profile "Flexfields:Shared Table Lock" = Yes

pyppmrhi.pkb 120.3.12010000.5

When attempting to use API to load and update personal payment methods of 10+ employees, the following error occurs.

ERROR
-----------------------
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,


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the personal payment method for the employees.

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