EAR9.1: Parallel Payment Predictor Processes Fail At Step AR_PREDICT2.LOCKITEM.LOCKITEM (Action SQL) (Doc ID 2039112.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Statement of the issue:
----------------------------------
Customer runs three parallel Payment predictor job. And process AR_PP1 fails because of the deadlock.

Error Message:
--------------------
Process 1219708 ABENDED at Step AR_PREDICT2.LOCKITEM.LOCKITEM (Action SQL) -- RC = 60
ROLLBACK
/
-- 01.20.37 SQL Error: ORA-00060: deadlock detected while waiting for resource

Steps to Replicate:
---------------------------

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