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.
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;
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
1 CLOSED ERROR
40 CLOSED SENT
1 OPEN ERROR
1131 OPEN MAIL
3101 OPEN SENT
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.