Dear Experts, Kindly note that i have noticed that OEOL workflow table is having more than 1,78,000 Records. I have executed the below query for purgeing the purgeable records. exec WF_PURGE.TOTAL (‘OEOL’,NULL,SYSDATE,FALSE,FALSE); After 3 days i have noticed that the above command is still running on my production instance. But i have noticed that the records it is showing.
WF_PURGE.TOTAL – purge both item data and activity data. The other auxiliary routines purge only certain tables or classes of data, and can be used in circumstances where a full purge is not desired. The complete list of purge APIs are as follows:, execute wf_purge.Total (itemtype =>’Test’,itemkey => 23); Posted by Oracle HCM Consultant at 13:41. Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. Labels: workflows. 1 comment: Smith 28 January 2020 at 21:40.
12/21/2017 · If you don’t want to keep 30 days WFERROR notifications then find out total number using below query.
9/7/2014 · exec wf_purge . total ( itemtype => ‘HRSSA’ , itemkey => ‘336232’ );, WF_PURGE.TOTAL – purge both item data and activity design data. The other auxiliary routines purge only certain tables or classes of data, and can be used in circumstances where a full purge is not desired. The complete list of purge APIs is as follows: Items. Activities. Notifications. Total. TotalPERM. Directory, WF_PURGE.TOTAL – purge both item data and activity design data. The other auxiliary routines purge only certain tables or classes of data, and can be used in circumstances where a full purge is not desired. The complete list of purge APIs is as follows: Items. Activities. Notifications. Total. TotalPERM. Directory, One such script is wf_purge.total . Below, I give an example of using wf_purge.total to item_types where the PARENT_ITEM_TYPE is null. I also write about two methods to purge notifications, wf_purge.notifications and manually updating the wf_notifications table and set status=’CLOSED’, mail_status=’SENT’, and END_DATE=sysdate-1.
WF_PURGE.TOTAL package. This script deletes obsolete runtime data which includes: Items, Item activity status, Notifications, Expired activity versions. SQL> execute wf_purge.total . WFRMITT.sql script. This script deletes all definitions for an Item. For OWB versions up to 10.2: Windows: SQL> @ wfadminsqlwfrmitt.sql. Linux/Unix:, 11/5/2010 · exec wf_purge.items(‘xdpwfstd’,null,sysdate,false); Even after running above script for all item, still mailer is sending old notification (which is production notification) to user. when we run count(*) from wf_notifications as shown below
