Complex Deal Upload Batch (Reimcomplexdealupload) Fails With "ORA-00060: Deadlock Detected" Error
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.
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms