My Oracle Support Banner

FA:SCM:SCP Error ORA-00060: Deadlock Detected While Waiting For Resource (Doc ID 2958039.1)

Last updated on AUGUST 28, 2023

Applies to:

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


When attempting to run data collections and plan run in same time window, the following error occurs.

ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 5059
ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 5078
ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 5059

The issue can be reproduced at will with the following steps:
1. Go to Supply Planning
2. Run Collection Job Set
3. Run plan at the same time.


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.