CRM Error: FRM-40654: How To Troubleshoot And Resolve Service Request And Task Locking Issues
(Doc ID 748144.1)
Last updated on JULY 21, 2020
Applies to:Oracle Teleservice - Version 11.5.10 and later
Information in this document applies to any platform.
Users within the system are typically getting locking errors on Service Requests and Tasks.
Sometimes these appear to valid locks (ie. a user is actually within a Service Request performing an edit), but other times there may be other reasons for a lock to occur -- contention, user has left for the day and forgot to clear or close application, etc.
What are recommended methods for determining additional information about the locks such as:
a) What user is locking the record?
b) How long has the lock been in effect?
c) What row or record is being locked?
d) What object is locked?
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
|The below queries and notes discuss the best practices for a user or DBA to garner additional information about the locks and locked objects.|