My Oracle Support Banner

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.

Symptoms



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



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:

1. Do WIP Move Transactions on line


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.