My Oracle Support Banner

Deadlock Detected Between Planning Manager(MRCRLF) and WIP Mass Load(WICMLP) (Doc ID 2712071.1)

Last updated on MARCH 05, 2021

Applies to:

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

Symptoms

Problem Statement
Planning Manager(MRCRLF) and WIP Mass Load(WICMLP) completed with warning.
According to DB Alert log, below deadlock message was shown.

Error
Global Enqueue Services Deadlock detected. More info in file
 /trace-file-path/specific-trace-file-name.trc

To check SQL Trace file(Above trace-file-path/specific-trace-file-name.trc)
------------------------------------------------------------------------------------------
    application name: e:MRP:cp:mrp/MRCRLF, hash value=#########
    action name: MRP/SUPPLY_CHAIN_PLANNER, hash value=#########
  current SQL:
  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
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK


    application name: e:WIP:cp:wip/WICMLP, hash value=#########
    action name: WIP/WIP_BATCH, hash value=#########
  current SQL:
  UPDATE WIP_DISCRETE_JOBS WDJ SET (LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
LAST_UPDATE_DATE, FIRM_PLANNED_FLAG, LOT_NUMBER, START_QUANTITY,
NET_QUANTITY, STATUS_TYPE, DATE_RELEASED, DATE_COMPLETED,
SCHEDULED_START_DATE, SCHEDULED_COMPLETION_DATE, SCHEDULE_GROUP_ID,
BUILD_SEQUENCE, LINE_ID, PROJECT_ID, TASK_ID, COMPLETION_SUBINVENTORY,
COMPLETION_LOCATOR_ID, DESCRIPTION, SOURCE_CODE, SOURCE_LINE_ID,
OVERCOMPLETION_TOLERANCE_TYPE, OVERCOMPLETION_TOLERANCE_VALUE,
END_ITEM_UNIT_NUMBER, PRIORITY, DUE_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1,
ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13,
ATTRIBUTE14, ATTRIBUTE15, ROUTING_REVISION_DATE,
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK

Steps to Reproduce

  1. Planning Manager(MRCRLF) is run every 1 second.
  2. WIP Mass Load(WICMLP) is run when new job create by open interface

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.