Move Transactions Lock Issue
(Doc ID 2788718.1)
Last updated on SEPTEMBER 07, 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. 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 sometimes 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:
This can be done by any Responsibility that can do WIP Move Transactions
Navigation: Work in Process > Move Transactions> Move Transactions
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