EBS responsibilities are not displaying.

 Sometimes even though post running.

1) SYNC workflow data into WF local tables

2) SYNC workflow local roles.

3)  Workflow directory user role validation

select role_name, EFFECTIVE_END_DATE  from wf_local_user_roles where user_name='OHRID'

 

SELECT  DISTINCT frt.RESPONSIBILITY_NAME, furg.end_date

FROM

         fnd_user_resp_groups furg,

         FND_RESPONSIBILITY fr,

         fnd_responsibility_tl frt,

         fnd_user fu

WHERE fu.user_name = 'OHRID'

AND   fu.user_id = furg.user_id

AND   furg.responsibility_id = fr.RESPONSIBILITY_ID

AND   frt.responsibility_id = fr.RESPONSIBILITY_ID

AND frt.LANGUAGE='US'

ORDER BY 1;

 

 

 

Action planè

 

SQL> select count(*) from wf_local_user_roles where user_name=' OHRID ' and role_name=’XXXXX’;

 

  COUNT(*)

----------

         1

 

SQL> select count(*) from wf_local_user_roles where user_name=' OHRID ' and role_name=’YYYYYY’;

 

  COUNT(*)

----------

         1

 

 

 

SQL> update wf_local_user_roles set effective_end_date='01-JAN-9999' where effective_end_date='20-MAY-2010' and user_name=' OHRID ' and role_name=’XXXXXXX';

 

1 row updated.

 

 

SQL> update wf_local_user_roles set effective_end_date='01-JAN-9999' where effective_end_date='20-MAY-2010' and user_name='OHRID' and role_name=’YYYYYYY’;

 

1 row updated.