Deadlock Happens Between WIPDJMDF and Planning Manager(MRCRLF)when Updating Status of the Discjote Job to Complete - No Charges

(Doc ID 2365381.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Work in Process - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On WIPDJMDF, when attempting to Update Status from "Complete" to "Complete - No Charge"
The screen froze when saved.
The following error occurs on DB alert log.

ERROR

ORA-00060: Deadlock detected.

Planning Manager(PM):

SELECT JOBS.ROWID, JOBS.WIP_ENTITY_ID, JOBS.ORGANIZATION_ID FROM WIP_REQUIREMENT_OPERATIONS OPS, WIP_DISCRETE_JOBS JOBS, MRP_RELIEF_INTERFACE MRP WHERE OPS.WIP_ENTITY_ID (+) = JOBS.WIP_ENTITY_ID AND OPS.ORGANIZATION_ID (+) = JOBS.ORGANIZATION_ID AND MRP.DISPOSITION_TYPE = :B7 AND MRP.RELIEF_TYPE = :B6 AND MRP.REQUEST_ID = :B5 AND MRP.PROCESS_STATUS = :B4 AND MRP.ERROR_MESSAGE IS NULL AND MRP.INVENTORY_ITEM_ID = DECODE(:B3 ,:B2 , MRP.INVENTORY_ITEM_ID, :B3 ) AND MRP.ORGANIZATION_ID = DECODE(:B1 ,:B2 ,MRP.ORGANIZATION_ID, :B1 ) AND JOBS.PRIMARY_ITEM_ID = MRP.INVENTORY_ITEM_ID AND JOBS.ORGANIZATION_ID = MRP.ORGANIZATION_ID AND JOBS.WIP_ENTITY_ID = MRP.DISPOSITION_ID FOR UPDATE OF JOBS.MPS_NET_QUANTITY, OPS.MPS_REQUIRED_QUANTITY ORDER BY JOBS.ORGANIZATION_ID, JOBS.WIP_ENTITY_ID

WIPDJMDF(WIP from):

UPDATE WIP_REQUIREMENT_OPERATIONS SET QUANTITY_BACKORDERED = 0 WHERE WIP_ENTITY_ID = :B1


STEPS

The issue can be reproduced at will with the following steps:
1. Navi:Discrete - Discrete Jobs
2. Update Status from "Complete" to "Complete - No Charge"
3. The screen froze when saved

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