Move Transactions Lock Issue
(Doc ID 2788718.1)
Last updated on JULY 08, 2021
Applies to:Oracle Work in Process - Version 12.2.9 and later
Information in this document applies to any platform.
WIP Move Transactions has locking issue
Customer upgraded Oracle R12.2.9 and experience some locking issues. This is one of the issues. When trying to do move transactions from the current operation to the next one, got error message " APP-WIP-25305: Could not lock row because it has been already locked by another user".
This happens occasonily and cannot be reproduced at will
Workaround is to clear all the sessions, so users can move on, which is unacceptable
APP-WIP-25305: Could not lock row because it has been already locked by another user
The issue can be reproduced at will with the following steps:
1. Do WIP Move Transactions on line
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