DEADLOCK ERROR ORA-00060 WHEN TRYING TO MASS CLOSE WORK ORDERS (Doc ID 1509179.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 21-MAY-2015***

Symptoms

On : 12.1.3 version, Work Execution

When attempting to close work orders in batch mode using Maintenance Workbench, the following error occurs.
Single work order can be close from the Workbench. The issue only happens for a batch of work orders.

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Enterprise Asset Management
2. Navigation: Work Order Planning -> Maintenance Workbench
3. Select batch of work orders to be closed
4. Receive above error


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