EAR9.2: Payment Predictor Fails at Step AR_PREDICT2.LOCKITEM.LOCKITEM Because of Deadlock When Parallel Processing is Enabled
(Doc ID 2023782.1)
Last updated on NOVEMBER 05, 2020
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to run Payment Predictor process, the following error occurs.
ORA-00060: deadlock detected while waiting for resource Failed SQL stmt: UPDATE PS_ITEM SET PROCESS_INSTANCE = 2690994 WHERE BUSINESS_UNIT = :1 AND CUST_ID = :2 AND ITEM = :3 AND ITEM_LINE = :4 AND PROCESS_INSTANCE = 0 AND ITEM_STATUS = 'O'
The issue can be reproduced at will with the following steps:
- Create items.
- Create deposit and payments for the items previously created.
- Run Payment Predictor process.
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