OM Record is currently being worked on by another user, Please try to update it later.

ERP版本：11.5.10

OM模組做訂單更新時出現如下提示：
Record is currently being worked on by another user,
Please try to update it later.

 

解决方案：

--Check Locking Event

SELECT sid,
       serial#,
       username,
       STATUS,
       state,
       event,
       blocking_session,
       seconds_in_wait,
       wait_time,
       action,
       logon_time
  FROM gv$session
WHERE     state IN ('WAITING')
       AND wait_class != 'Idle'
       AND event LIKE '%enq%'
       AND TYPE = 'USER';

 

ALTER SYSTEM DISCONNECT SESSION 'sid,serial#' IMMEDIATE;