http://fixedasstets.blogspot.com/2016/08/app-ofa-48232-another-transaction-is.html
Solution:
The issue is caused by existing lock sessions on FA objects.
Due to the locks, other locks for update cannot be obtained.
Please execute the following statement to verify if there are locked sessions in the FA tables:
select a. session_id, b.object_name
from V$locked_object a, dba_objects b
where a.OBJECT_ID=b.OBJECT_ID and b.object_name like 'FA%' and b.object_type='TABLE';
If yes, ask your DBA to release the lock and then try again.
Error:
APP-OFA-48232 Another transaction is already being performed on this asset when trying to perform a transaction.
Solution:
Due to the locks, other locks for update cannot be obtained.
Please execute the following statement to verify if there are locked sessions in the FA tables:
select a. session_id, b.object_name
from V$locked_object a, dba_objects b
where a.OBJECT_ID=b.OBJECT_ID and b.object_name like 'FA%' and b.object_type='TABLE';
If yes, ask your DBA to release the lock and then try again.
Once the locks are released, the user can perform the transactions
No comments:
Post a Comment