After modifying Workflow Package getting below error ORA-00054: resource busy and acquire with NOWAIT

After modifying Workflow Package getting below error ORA-00054: resource busy and acquire with NOWAIT

After modifying any workflow package, while approving or acting on the notification getting below error.

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

ORA-06512: at "APPS.WF_NOTIFICATION", line 5137 ORA-06512: at line 1

It is due to the old state of the existing code creating this error.

Resolution:

1. Clear the old session locking up the old objects.

a. Search the session


select s.* 

from gv$access a, gv$session s 

where object IN  ('AP_WORKFLOW_PKG')

and a.inst_id=s.inst_id 

and a.sid=s.sid 


order by logon_time;



b. Kill the session ( Restart workflow and OPMN, will clear most of them )



2. Bounce the database