ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Please see from v$lock if the object is being used by other sessions for below query

select obect_id1,object_id2 from dba_objects where owner='schemanname' and object_name='table_name';

1) select sid from v$lock where id1='id1_obtained from previous query' and id2='obtained from previous query';

2)select serial# from v$session where sid='sid obtained from previous query';

3) select lo.session_id,lo.oracle_username,lo.os_user_name,

lo.process,do.object_name,

decode(lo.locked_mode,0, 'None',1, 'Null',2, 'Row Share (SS)',

3, 'Row Excl (SX)',4, 'Share',5, 'Share Row Excl (SSX)',6, 'Exclusive',

to_char(lo.locked_mode)) mode_held

from v$locked_object lo, dba_objects do

where lo.object_id = do.object_id

order by 1,5

SID Oracle_User OS_User Process Object_name

442 APPS applmgr 22539 FND_CONCURRENT_REQUESTS

1199 APPS applmgr 23004 FND_CONCURRENT_QUEUES

Kill those sessions or wait until user complete those sessions

alter system kill session 'serial#,sid';

ORACLE DBA