Crediting And Rollup Error SQLERRM : ORA-00060: deadlock detected while waiting for resource process_all_mode has failed (Doc ID 2255764.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

User starting to see error on Crediting and Rollup (as a single job).
This started happening this week.  This job has been working before.
Sample request_ids : 371191 (child 371252, 371263) and 371273 (child 371346)

ERROR
SQLERRM : ORA-00060: deadlock detected while waiting for resource



STEPS
Navigator > Credits and Earnings > Run Crediting and Rollup
  Parameters :
  Business Unit = BU2
  Start Date = 2016-01-01
  End Date = 2016-12-31
  Total Mode = ALL

Debug messages shows:

...
Start of generate_indirect_credits for logical batch : 71388 and physical batch : 31
Run Mode : ALL
Summarization Flag : N
Custom Summarization Flag : N
Update credit for which rollup phase is not needed: 2
Start of process_all_mode
Number of direct credits fetched = 10000
...
Done checking all the indirect credits with the old records
Start of revert_indirect_credits
Number of indirect credits : 0
End of revert_indirect_credits
CN_TP_TXNS_UTIL.revert_indirect_credits completed successfully
Start of insert_indirect_credits
Number of records to inserted in cn_tp_credits_all : 4194
Number of records actually inserted in cn_tp_credits_all : 0
End of insert_indirect_credits
insert_indirect_credits completed successfully
Unexpected exception in process_all_mode
SQLCODE : -60
SQLERRM : ORA-00060: deadlock detected while waiting for resource
process_all_mode has failed
CN_TP_INDIRECT_CREDITS.generate_indirect_credits.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception

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