SYSADMIN Responsibility is not visible in front -end

Sometimes after cloning such issues appear,after login to front-end.After login with SYSADMIN,System Administrator Responsibility is not seen in the form page.We do usually below steps to re-set.

Updating wf_local_user_roles and wf_USER_ROLE_ASSIGNMENTS resolves this issue.

SQL> select effective_end_date from wf_local_user_roles where user_name = 'SYSADMIN';

EFFECTIVE_END_D

---------------

01-JAN-79

01-JAN-79

01-JAN-79

.....

.....

01-JAN-79

01-JAN-79

01-JAN-79

74 rows selected.

SQL> select TO_CHAR(effective_end_date, 'dd-mon-yyyy') from wf_local_user_roles where user_name = 'SYSADMIN';

TO_CHAR(EFFECTIVE

-----------------

01-jan-1979

01-jan-1979

01-jan-1979

01-jan-1979

.......

.......

01-jan-1979

01-jan-1979

01-jan-1979

74 rows selected.

SQL> select TO_CHAR(effective_end_date, 'dd-mon-yyyy') from wf_USER_ROLE_ASSIGNMENTS where user_name = 'SYSADMIN';

TO_CHAR(EFFECTIVE

-----------------

01-jan-1979

01-jan-1979

01-jan-1979

01-jan-1979

01-jan-1979

01-jan-1979

01-jan-1979

74 rows selected.

SQL> create table wf_user_role_assignments_bkp as select * from wf_user_role_assignments;

Table created.

SQL> create table wf_local_user_Roles_mar as select * from wf_local_user_Roles;

Table created.

SQL> 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');  

Enter value for username: SYSADMIN

old   6:  where user_name=upper('&username')

new   6:  where user_name=upper('SYSADMIN')

74 rows updated.

SQL> 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'); 

Enter value for username: SYSADMIN

old   5:  where user_name=upper('&username')

new   5:  where user_name=upper('SYSADMIN')

74 rows updated.

SQL> commit;

Commit complete.

SQL> select TO_CHAR(effective_end_date, 'dd-mon-yyyy') from wf_USER_ROLE_ASSIGNMENTS where user_name = 'SYSADMIN';

TO_CHAR(EFFECTIVE

-----------------

31-dec-4712

31-dec-4712

31-dec-4712

31-dec-4712

..........

..........

31-dec-4712

31-dec-4712

31-dec-4712

74 rows selected.

SQL> select effective_end_date from wf_local_user_roles where user_name = 'SYSADMIN';

EFFECTIVE_END_D

---------------

31-DEC-12

31-DEC-12

31-DEC-12

31-DEC-12

.......

.......

31-DEC-12

31-DEC-12

31-DEC-12

74 rows selected.

SQL> commit;

Commit complete.

Now login to front-end check ,you might get the responsibility.