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

Last updated on JULY 31, 2017

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.

Symptoms

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"

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