WIP移動取引ワーカーと取引インターフェースの処理の間にORA-60 デッドロックが発生 (Doc ID 2352360.1)

*** MODULE NAME:(INCTCM) 2018-01-16 07:01:31.375
*** ACTION NAME:(Concurrent Request) 2018-01-16 07:01:31.375

DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

   :
----- Information for the OTHER waiting sessions -----
   :

   application name: WICTWS, hash value=XXXXXXXXXXXXX
   action name: Concurrent Request, hash value=XXXXXXXXXX
 current SQL:
 UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP SET COST_GROUP_ID = :B3 , TRANSFER_COST_GROUP_ID = NVL(TRANSFER_COST_GROUP_ID, :B2 ) WHERE TRANSACTION_TEMP_ID = :B1

----- End of information for the OTHER waiting sessions -----

Information for THIS session:

----- Current SQL Statement for this session (sql_id=xxxxxxxxxx) -----
update MTL_MATERIAL_TRANSACTIONS_TEMP MMTT  set TRANSACTION_HEADER_ID=:b0,LAST_UPDATE_DATE=SYSDATE,LAST_UPDATED_BY=:b1,LAST_UPDATE_LOGIN=:b2,PROGRAM_APPLICATION_ID=:b3,PROGRAM_ID=:b4,REQUEST_ID=:b5,PROGRAM_UPDATE_DATE=SYSDATE,LOCK_FLAG='Y',ERROR_CODE=null ,ERROR_EXPLANATION=null  where (((((PROCESS_FLAG='Y' and NVL(TRANSACTION_STATUS,1) in (1,3)) and NVL(LOCK_FLAG,'N')='N') and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 1  from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MMTT.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE,(SYSDATE+1))>SYSDATE)))