Many WorkFlow notifications

[big]

Hi,
Recently we installed a R12.2.9 test system DB 19c on AIX.

It is not used by user. Just me as admin.

As son as we start Workflow mailer and sent a test mail, we receive many many notifications until we stop WorkFlow mailer and system.

How to stop this? Any table or Queue to purge ?
Or any other action?

Thanks.

[ErmanArslansOracleBlog]

Check the wf_notifications table.. Probably, there are some old notifications generated by previous workflow activities, and their mail status is MAIL. That's why when you start the mailer, it sees them and sends them all.. You may update those records accordingly and get rid of the problem.

[big]

Thank you.
I ran:

update wf_notifications  set mail_status =’ERROR’  where mail_status=’MAIL’ ;

Everything is ok.

Regards.

[big]

Hi,
After the following:

update wf_notifications  set mail_status =’ERROR’  where mail_status=’MAIL’ ;

It was good for some days but several days after it begins to send the notifications with differenr subjet for example:

Action Required: OM Error in Workflow Order Typ

Actually we have:
Select distinct message_type from apps.WF_NOTIFICATIONS
where BEGIN_DATE > sysdate - 5
MESSAGE_TYPE
--------
WFERROR
OKCAUKAP
OMERROR
APEXP

They are created "automatically" and not by any human being.
Any way to stop them?

Thanks and regards.

[ErmanArslansOracleBlog]

You need to check them with your functional admins / workflow admins. These are the result of your workflow.. Some errors are produced as the message_type(s) suggest. WFERROR, OMERROR..

APEXP are the result of your APEXP Workflow and OKCAUKAP is related with Service Contracts..

Check them with your functionals.

[big]

Hi,
Thank you.
There is no functional or Workflow admi.
I am the only one and installed as a sand box for me.

How to know which exact program has sent Workflow notification ?

Regards.

[ErmanArslansOracleBlog]

You have to read workflow admin guide.. your concern is a generic one..