Translate this Page

 

After we assigning some responsibilities to a user in Oracle E-Business Suite. Unfortunately when user login to the system, he can’t found the responsibilities that he want in the web navigator. This problem usually happen after upgrading or patching.

To solve this problem :

1. Set the role_end_date to null in the wf_local_user_roles.
The sql used will depend on the responsibility missing. For example for the System Administrator responsibility, type in the following:

UPDATE wf_local_user_roles
 SET role_end_date = NULL
 WHERE user_name LIKE 'SYSADMIN%'
 AND role_name = 'FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD';

or

2. Update both the wf_local_user_roles and wf_user_role_assignments tables with null values for the roles.

If we know the username then run these queries :

UPDATE wf_user_role_assignments
 SET user_end_date = NULL,
 role_end_date = NULL,
 assigning_role_end_date = NULL,
 effective_end_date = TO_DATE ('31-12-4712', 'dd-mm-yyyy')
 WHERE user_name = UPPER ('&username');

UPDATE wf_local_user_roles
 SET user_end_date = NULL,
 role_end_date = NULL,
 effective_end_date = TO_DATE ('31-12-4712', 'dd-mm-yyyy')
 WHERE user_name = UPPER ('&username');

Or if we know the rolename then run these queries :

UPDATE wf_user_role_assignments
 SET user_end_date = NULL,
 role_end_date = NULL,
 assigning_role_end_date = NULL,
 effective_end_date = TO_DATE ('31-12-4712', 'dd-mm-yyyy')
 WHERE role_name = UPPER ('&rolename');

UPDATE wf_local_user_roles
 SET user_end_date = NULL,
 role_end_date = NULL,
 effective_end_date = TO_DATE ('31-12-4712', 'dd-mm-yyyy')
 WHERE role_name = UPPER ('&rolename');

Once the wf_user_Role_Assignments table is updated with null end dates, even if wf_local_user_Roles is summarized from it, then end date values would remain null and the problem should not re-occur.

Reference : NOTE. 334439.1

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

   
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha