Work Flow Administrator

Workflow System Administrator

http://appsdbainfo.com/notes/workflow/wfmailer_workflow.html

http://tenthsense.blogspot.in/2014/12/how-to-assign-workflow-administrator.html

 

How to assign Oracle Workflow Administrator privileges to users

The workflow administrator privilege can be assigned to a particular user, responsibility or to everyone. The setup is done using the Administration function. Navigate to ‘Workflow Administrator (Responsibility) => Administrator Workflow (Menu) => Administration (Function).

 

In the field ‘Workflow System Administrator’ set the value to which you want to assign the workflow administrator privilege.

 

· To make ‘SYSADMIN’ user the workflow system administrator set the value as ‘SYSADMIN’

 

 

 

 

· To make all users workflow system administrators set the value as ‘*’.

 

 

 

·        To make all users having a particular responsibility as workflow system administrators choose the responsibility using the torch button. Generally, the responsibility ‘Workflow Administrator Web (New)’ is chosen for this purpose.

 

847889.1 - Stop Workflow Notification Emails During Clone

Stop Workflow Notification Emails During Clone (Doc ID 847889.1)

To Bottom

---

In this Document Goal   Solution   References Applies to: Oracle Workflow Cartridge - Version 11.5.9 to 12.0.6 [Release 11.5 to 12] Information in this document applies to any platform. Workflow Java Mailer Goal   NOTE: This document has been consolidated into Note 562551.1. Please reference that document for the latest revisions. How do you prevent emails from being sent during a cloning operation? Solution First of all, Never use a truncate command on the WF_NOTIFICATIONS table if you can help it.  There are several simple and easy to use methods to ensure that you don't send out unwanted emails... They're all safe and won't corrupt your data: 1.  Shut off the mailer.  Use the OAM workflow manager console and stop the workflow mailer service component . To ensure that it doesn't automatically start up again, set the startup mode to 'Manual'. this is done from the workflow configuration wizard (Edit) 2.  Use the override address feature: this automatically routes all outbound messages to one address so that the users are never bombarded with test messages during a testing cycle.  This will not affect any messages already enqueued into WF_NOTIFICATION_OUT.  3.  You can also set the mailer outbound threads to 0.   This prevents the mailer from sending mail to the smtp server.  To do this:              a.   Logon to Oracle Applications Manager as SYSADMIN              b.  Navigate  to workflow manager,               c.  Select the workflow notifications icon and then the edit button for the mailer.              d.  Select Advanced and then proceed to page 2.   Change the outbound threads to 0                   then finish and save.   4.   If you still have unwanted outbound notifications in the WF_NOTIFICATIONS_OUT queue,  then you will want to temporarily disable your notification.send business events then rebuild your queue.   This method removes the data from the outbound queue and since it refreshes it from the data in the WF_NOTIFICATIONS table,  it is safe to do.  You can use the Throughput: Agent Activity page from the OAM Workflow manager console to monitor the volume in the outbound queue.       a.  DISABLE wf.notification.send events:       Login via Oracle Applications Workflow Administrator Web Applications      responsibility      Navigate to Find Event Subscriptions      Enter for Event "oracle.apps.wf.notification" then hit the LOV button and      select one      of the Events one by one, then hit the FIND button      If there are any subscriptions enabled, then disable them      select e.name, e.type, e.status event_status, e.GENERATE_FUNCTION, e.OWNER_NAME, s.SOURCE_TYPE, s.RULE_FUNCTION, s.STATUS subscription_status, s.WF_PROCESS_NAME, s.WF_PROCESS_TYPE, s.DESCRIPTION from wf_events e, WF_EVENT_SUBSCRIPTIONS s where e.GUID=s.EVENT_FILTER_GUID and e.name like 'oracle.apps.wf.notification%'   b.   Verify the list of Events (ENABLED) and Subscription Statuses (DISABLED)       for notification send events: SQL>    select e.name, e.type, e.status event_status, e.GENERATE_FUNCTION,e.OWNER_NAME,s.SOURCE_TYPE, s.RULE_FUNCTION, s.STATUS subscription_status,s.WF_PROCESS_NAME, s.WF_PROCESS_TYPE, s.DESCRIPTION from wf_events e, WF_EVENT_SUBSCRIPTIONS s where e.GUID=s.EVENT_FILTER_GUID and e.name like 'oracle.apps.wf.notification%' c.   Disable ALL the APPS:oracle.apps.wf.notification.send event subscriptions:      Login via Oracle Applications Workflow Administrator Web Applications responsibility.       Navigate to Find Event Subscriptions.      Enter for Event "oracle.apps.wf.notification" then hit the LOV button.      Select one of the Events one by one, then hit the FIND button      If there are any subscriptions enabled, then disable them Disable :   d.   Verify the list of Events (ENABLED) and Subscription Statuses (DISABLED) using the SQL in (b) e.  Rebuild the WF_NOTIFICATION_OUT queue:      Ensure that the mailer is not running using the OAM Workflow manager console.       Run the script $FND_TOP/patch/115/sql/wfntfqup.sql script.  This will dequeue the old      messages from WF_NOTIFICATION_OUT queue and it will rebuild it with any messages in  WF_NOTIFICATIONS which are in status OPEN and mail_status MAIL.  Since the event would be disabled you will end up with no messages in either and your data in WF_NOTIFICATIONS is nicely closed for you.  f.   When you are finished,   you may want to remember to re-enable the event and turn the mailer back on.

 

How can we check , whether workflow notification are stopped or not?

 

Note: 736508.1 - How to Cancel Email Notifications for Particular Workflow Type
Note: 372933.1 - How to purge e-mail notifications from the workflow queue so the e-mail is not sent

select notification_id, begin_date, recipient_role, message_type, message_name, status, mail_status

     from wf_notifications

     Where Status In ('SENT');

     --And Mail_Status In ('MAIL', 'INVALID');

 

    

    

     update WF_NOTIFICATIONS set mail_status = 'SENT'

     where mail_status in ('MAIL','INVALID')

     and Status In ('OPEN', 'CANCELED');

    

    

     select notification_id, begin_date, recipient_role, message_type, message_name, status, mail_status

     from wf_notifications

     Where Status In ('OPEN');

    

    

     select count(mail_status) from wf_notifications Where mail_status In ('SENT');

    

     select count(mail_status) from wf_notifications Where Status In ('OPEN');

 

 

Changes Introduced in Alerts Post RUP4 and its Impact [ID 422782.1]
How to Disable all Workflow related Email Notifications Except for the Ones Sent from Oracle Alerts? [ID 463777.1]