Wednesday, April 01, 2015

Oracle workflow : Set Workflow System Administrator privileges to all users.

You can do it by login to application using SYSADMIN user name, or do the following


Login to Oracle application database using apps/@

Execute following update statement

SQL>select text from wf_resources 
  2 where name = 'WF_ADMIN_ROLE';
 
TEXT
--------------------------------------------------------------------
SYSADMIN
Result will be SYSADMIN, Update it to *.

Run the following update statement:

SQL> update wf_resources set text  = '*' 
  2  where name = 'WF_ADMIN_ROLE';



Screen 1 : No Admin Privilege to all users to run workflow from front end.

Screen 2 : After updating WF_ADMIN_ROLE to * we will get RUN button.

Screen 3 : Execution and parameter entry screen when we will click on run button.

No comments: