Wednesday, February 25, 2015

Update Workflow Administrator Role in Oracle Applications 11i/R12 from backend

For looking at workflow details that are owned by other users or status diagram in Oracle Applications use the following update statement to update.

By default (in 11i & R12) this role is set to user sysadmin (In old versions 11.5.8 or prior, it used to set to *)

UPDATE wf_resources
   SET text = ’ * ’
 WHERE NAME = ’wf_admin_role’;