1 Reply Latest reply on Jun 20, 2013 9:14 AM by User463450-OC

    Users Access Payslip in SSHR


      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.




        • 1. Re: Users Access Payslip in SSHR

          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.