Please provide more details.
What do you mean by failing?
Have you reviewed the workflow mailer log?
in fact you need to set the mailer preference from disabled to HTML mail. (Doc ID 578574.1)
I have backed up table wf_local_roles
create table wf_local_roles_bk as select * from wf_local_roles. How can I restore the table from wf_local_roles_bk to wf_local_roles?
I tried to rename wf_local_roles to wf_local_roles_bk2 and rename wf_local_roles_bk to wf_local_roles , it says table already exists
Why are you trying to restore the backup table?
Try backing up the current one, delete the rows in it and insert the rows from the first backup table.