UsUser is getting error when try to update incomplete transactions
User is getting below error when try to update incomplete transaction in AR, Transaction->Transaction screen.
APP-AR-295111: Record Has Been Locked By Another User. Please requery, or try again later.
I was referring to Doc (1069130.1) and this issue is for particular user alone for one transaction. So how do we identify the locks on table for particular user session and kill the SID?
We have already asked our DBA's to kill all sessions for user under below script:
Noticed around 6 form sessions and got terminated, but still user is hitting the same eror.
select * from gv$session
where 1=1
and
client_identifier