1 Reply Latest reply on Sep 10, 2018 4:40 PM by stejac

    cant find record in fnd_user_resp_groups for user_id

    stejac

      Hi group

      cant find record in fnd_user_resp_groups for user_id

      no responsibility visible for id 1112 nothing returned by the sql

      for user id 1125 i have all my access and see my data in sql

       

      select

      select distinct fu.USER_NAME,

                      furg.responsibility_id,

                      furg.responsibility_application_id,

                      furg.security_group_id,

                      furg.start_date,

                      furg.end_date

        from fnd_user_resp_groups furg, fnd_responsibility fr, fnd_user fu

      where furg.user_id in(1112,1125)

         and furg.user_id = fu.USER_ID

         and furg.responsibility_id = fr.responsibility_id

         and furg.responsibility_application_id = fr.application_id

      order by fu.user_name,

                furg.responsibility_id,

                furg.responsibility_application_id,

                furg.security_group_id;

       

      runned those concurrent request :

      Workflow Directory Services User/Role Validation

      Synchronize WF Local Tables

       

      and i have cleared the cache in Functional Administrator responsibility

       

      any idea