SQL & PL/SQL

Hi All,

Problem:

We are trying to VOID a cheque which was already accounted for some reason. We are unable to do that. The VOID option is there, but when we go to that option and give Check date and GL Date, system says it will void. On clicking OK in this screen, another message comes saying VOIDED..Requery to see changes... But when we requery we are unable to see the voided check. Still the check status is Negotiable.

Solution:

Usually happens when there is a database lock on that partucular check.
Some payment bacth of adjustment session had selected this particluar check but has not released it .

Pls ask ur dba to have it checked and if it is indeed locked , either try to release it or kill that session.


Now my query is how can I find out the locks via V$LOCK table.

Thanks
Shivank