Below listed are the ways of assigning a role to view all workflows in
Oracle Applications
Note: A role is created automatically when a new user or a
responsibility is defined in Oracle Applications. These roles are available in
the table wf_local_roles which is consolidate in the view wf_roles.
1)
From Oracle Applications, Workflow Administrator
responsibility
a.
Navigate to the responsibility à Administration tab à Workflow Configuration
and select the Workflow System Administrator value from the LOV field. b. Set to ‘*’ if all users are given access to view all workflows
2) Using
Backend (database) Update
a.
Get the role at the level which the access needs
to be provided
User Level
In order to assign
workflow admin access to view all workflows in Oracle then select the role for
the user created in Oracle Applications from the view wf_roles, this is stored
in the column ‘NAME’ of the view.
Example: SYSADMIN (or) PATRICK
Responsibility Level
In order to assign
workflow admin access to view all workflows for all users through a
responsibility in Oracle then select the role for the responsibility created in
Oracle Applications from the view wf_roles, this is stored similar to above in the
column ‘NAME’ of the view.
FORMAT: FND_RESP|FND|<RESP_SHORT_NAME>|STANDARD
UPDATE WF_RESOURCESSET TEXT=<ROLE_NAME>WHERE NAME = 'WF_ADMIN_ROLE';COMMIT;
3)
Default
using AUTOCONFIG
When autoconfig
is run, the default admin role defined in the CONTEXT file is picked and
configured. This context file is specific to application server and stores most
of the default configuration variables. The value for wfadmin is stored in the
variable 's_wf_admin_role'. Once you ahve sourced the environment file you can
echo the context file location using $CONTEXT_FILE variable and then search for
the variable in the file. The value from this file will be considered when the
next autoconfig is run.
Example:<username oa_var="s_wf_admin_role">FND_RESP|FND|FNDWF_ADMIN_WEB|STANDARD</username>Running Autoconfig$OAD_TOP/admin/scripts/$CONTEXT_NAME/adautocfg.sh (11i)$ADMIN_SCRIPTS_HOME/adautocfg.sh (R12)
