Receivables - EBS (MOSC)

MOSC Banner

UsUser is getting error when try to update incomplete transactions

edited Jun 15, 2016 11:18AM in Receivables - EBS (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center