Inventory Management - EBS (MOSC)

MOSC Banner

How To Delete Notifications from Worklist for Specific users in 11i?

Request to provide the steps to delete all the notifications. (EBS version: 11.5.10.2)

1. Ran Purge Obsolete Workflow Runtime Data with parameter as INV: Move Order Approval.

But it didn't purge any notification record. Count is same before and after the program.

2, Ran the following update script but it didn't delete any notification record.

begin

wf_purge.items( itemtype => 'INVTROAP',

itemkey => null,

enddate => sysdate,

docommit => TRUE,

force => TRUE,

purgesigs => 1);

end;


*********Total count on following query -> 169,327

select count(1) from wf_notifications wn, wf_items wt

where wn.item_key = wt.item_key

and wt.item_type = 'INVTROAP'

and wn.end_date is not null;

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