Programs to Synchronize Workflow Roles

Resend Failed/Error Workflow Notifications 

Workflow notifications fail to be sent for multiple reasons.  The workflow mailer can hang due to server issues.  The email address can be incorrect.   The recipient’s mailbox may be full. The Resend Failed/Error Workflow Notifications will send any notifications based on the parameters selected where the mail_status = ‘MAIL.’  The risk is that old notifications may be sent for workflows that are no longer valid. The user must carefully enter parameters to resend notifications only for a specific day or a specific  workflow item.  Alternatively, execute a SQL statement to set the mail_status to null where the status = ‘CLOSED’ or ‘CANCELLED’ prior to running this concurrent program

Workflow Directory Services User/Role Validation 

This concurrent program is a data fix for user/role associations in the table WF_LOCAL_ROLES and fixes two common issues.  If this table is missing information, users will often not receive emails.  It also can result in missing responsibilities.  This program must be run twice with a different combination of parameters.  This is explained in detail in MetaLink Doc Id: 418765.1.  The first time, set she parameters Fix Dangling User/Roles=Yes and Add Missing User/Role assignments=No.  This removes the association from WF_LOCAL_USER_ROLES if the corresponding user or corresponding role is missing.  The second time, these parameters are flipped to add missing associations to WF_LOCAL_USER_ROLES to have corresponding user/role assignments in WF_USER_ROLE_ASSIGNMENTS

Synchronize Workflow Roles 

This concurrent program is specifically related to CRM modules.  If a workflow errors with the message “’x’ is not a valid role or user name”, this concurrent program will synchronize the attributes and records in the WF_LOCAL_* table with mismatching records in the Resource manager tables to eliminate this error

Synchronize WF LOCAL tables 

If a user is not receiving emails, I typically will immediately run this concurrent program as a first step.  This program synchronizes application data from specific modules with the WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES tables.  There are a lot of problems with directory services corruption prior to 11.5.10.2 RUP4.  If you are on an earlier release, then schedule this program to run nightly.