My Oracle Support Banner

Complex Deal Upload Batch (Reimcomplexdealupload) Fails With "ORA-00060: Deadlock Detected" Error (Doc ID 1559325.1)

Last updated on DECEMBER 07, 2020

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 to 13.2.9 [Release 13.2]
Oracle Retail Invoice Matching - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.


Reimcomplexdealupload batch fails with the following error when there is a large number of deals and the blocksize parameter value set is small:


Steps to Recreate:

1. Create up to 30 deals.
2. Make sure that the deals are populated in STAGE_COMPLEX_DEAL_HEAD and STAGE_COMPLEX_DEAL_DETAIL tables.
3. Run reimcomplexdealupload batch by passing blocksize parameter as 2.
4. Notice the following error:   "ORA-00060: deadlock detected while waiting for resource"




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

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