oracle.apps.wf.notification.cancel ready didn't exist in wf_deferred table
HI experts
I do the following test.
1.Stop concurrent manager adcmctl stop apps/apps
2.sqlplus apps/apps
Declare
cursor c_item_keys is
select act.item_key from wf_item_activity_statuses act ,wf_notifications n ,wf_items itm where act.notification_id = n.notification_id and act.item_type = itm.item_type and act.item_key = itm.item_key and itm.end_date is null and act.item_type = 'WFERROR' and act.activity_status in ('ERROR','NOTIFIED') and n.status = 'OPEN' and act.assigned_user = 'SYSADMIN';
counter number;
Begin
counter := 1 ;
for item in c_item_keys loop wf_engine.abortprocess('WFERROR',item.item_key);