Long Delay When Trying To Edit sales and purchase orders - Locked By User
I have in issue could anyone of you help me out in clearing the issue.
When a user attempts to edit a document (Sales Order, Purchase Order,Delivery) that has just been created, they are told that they cannot because the document is locked by themselves (same user who has *created the document).
After a variable delay (30 seconds - many minutes), the lock is cleared and the user is allowed to edit.
The frequency of the issue is increasing. We are now seeing user complaints on a daily basis which is having a negative impact on production.
It does not appear to be related to excessive system activity as we have had this issue occur with a single user active on the system.
Even v have upgraded the kernel to latest one and increased
the profile parameter enque/table_size to 10MB.But still the error occurs in the system.
My feeling is that this is either a profile parm or DB configuration issue.
I would be greatful if anyone could please look into the issue and help m eout at the earliest.
Thanks & Regards,