My Oracle Support Banner

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.

Symptoms



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



ERROR
-----------------------
APP-WIP-25305: Could not lock row because it has been already locked by another user

STEPS
-----------------------
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




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.