Core Workflow - EBS (MOSC)

MOSC Banner

oracle.apps.wf.notification.cancel ready didn't exist in wf_deferred table

edited Jun 10, 2014 12:00PM in Core Workflow - EBS (MOSC) 25 commentsAnswered

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center