CTO Calculate Dependent Demand Fails With CTO_CALC.DEP_DEMAND_BY_BASE_MODEL ORA-00060: deadlock (Doc ID 2282071.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

Workflow Calculate Dependent Demand fails with errors like

ERROR
-----------------------
PARALLEL_MANAGER.JOB_THREAD Thread #10 error: ORA-00060: deadlock detected while waiting for resource
CTO_CALC.DEP_DEMAND_BY_BASE_MODEL ORA-00060: deadlock detected while waiting for resource (on range 3284 AND 3284)
CTO_CALC.DEP_DEMAND_BY_BASE_MODEL ORA-00060: deadlock detected while waiting for resource (on range 2220 AND 2220)
PARALLEL_MANAGER.JOB_THREAD Thread #4 error: ORA-00060: deadlock detected while waiting for resource
PARALLEL_MANAGER.JOB_THREAD Thread #13 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