Purging of Old pending Notification & workflow data
Posted: 21 July 2006 04:08 AM   [ Ignore ]
Newbie
Rank
Total Posts:  24
Joined  2006-06-30

Hi,

We have oracle application 11.5.10 version and create a clone instance call T661 from production.

We are getting problem of Purging of Old pending Notification & workflow data. After doing below step still it is sending the old notification messages to user which was production messages.

Problem we are facing is how to Purge Old pending Notification & workflow data of production after cloning.

We have done below steps for purging but no result

1- As per metalink Note:144806.1 we Submit the Purge Obsolete Workflow Runtime Data concurrent request (FNDWFPR) for all items, still the same problem. user getting the old notification.

2- As per metalink note Note:165316.1 we run bde_wf_data.sql Workflow Purge Script and get the status of pending workflow data.

The above script create a statement as below for run to purge data.

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

SQL> select count(*),status from wf_notifications group by status;
COUNT(*) STATUS
---------- --------
1530 CANCELED
1627 CLOSED
15266 OPEN

SQL> select count(*),status, MAIL_STATUS from wf_notifications group by
2 status, MAIL_STATUS order by status;

COUNT(*) STATUS MAIL_STA
---------- -------- --------
5 CANCELED ERROR
1031 CANCELED MAIL
427 CANCELED SENT
67 CANCELED
1 CLOSED ERROR
40 CLOSED SENT
1586 CLOSED
1 OPEN ERROR
1131 OPEN MAIL
3101 OPEN SENT
11033 OPEN

still there are 15266 open notification is pending out of which there are 1131 email_status is mail.

Can you please help us how to purge old workflow and notification data.

You help is highly appreciated.

Profile
 
 
Posted: 24 July 2006 08:36 PM   [ Ignore ]   [ # 1 ]
Newbie
Rank
Total Posts:  1
Joined  2006-07-21

Hi,
Look at $FND_TOP/sql/wfrmitms.sql (to delete status information in Oracle Workflow runtime tables for a particular item type),
$FND_TOP/sql/wfrmitt.sql (to delete all data in all Oracle Workflow design time and runtime tables for a particular item type).
and $FND_TOP/sql/wfrmall.sql (to delete all data in all Oracle Workflow design time and runtime tables for all item type).

Alternatively, you could stop notification service on the second environment and change user’s preference to not receive email

Profile