My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

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

Symptoms

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

Profile "Flexfields:Shared Table Lock" = Yes

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,



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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