1 Reply Latest reply: Jun 20, 2013 4:14 AM by User463450-OC RSS

    Users Access Payslip in SSHR

    1010809

      Hi All,

       

      We have a requirement to report list of users,who have accessed their payslips in Oracle SSHR in certain period of date/time.

      Has anyone implemented similar thing before.Any inputs will be useful.

       

      Regards,

      Saurabh

        • 1. Re: Users Access Payslip in SSHR
          User463450-OC

          Dear Saurabh,

           

          hope below query will helps your requirement.

           

          u can also add payroll period name by using arguments of CP from fnd_concurrent_requests.

           

          SELECT papf.employee_number

            FROM fnd_concurrent_requests fcr,

                 fnd_concurrent_programs_vl fcp,

                 fnd_user fu,

                 per_all_people_f papf

          WHERE fcr.concurrent_program_id = fcp.concurrent_program_id

             AND fcp.user_concurrent_program_name = 'Rail SSHR Payslip Report'

             AND fcr.requested_by = fu.user_id

             AND papf.person_id = fu.employee_id

             AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

             AND TO_CHAR (fcr.request_date, 'MON') = 'JUN'

           

          let us know for any details.

           

          Thx,

          Balaji