Recruitment Process Through Core HR

View Online Payslip of Employee from Manager Self Service

1. Use Responsibility System Administrator
2. Navigation: Application > Function
3. Query on Function = PAY_MGR_EMP_SEARCH
4. Click on the Form tab you should see parameters = pCalledFrom=PAY_MGR_EMP_SEARCH&pDestination=PAY_MGR_PAYSLIP_SS&pEnableTerms=Y&pCallfromMgr=Y&pManagrEnabled=N
5. If the parameter &pCallfromMgr=Y is not there then add it to the end of the list
6. Save the changes
7. Add This Function to your custom Manager Self Service Responsibility.

Note: This Function Shows online payslip for all employees

Oracle Time and Labor Release Notes for Release 12.2.6

Oracle HRMS for Saudi Arabia Release Notes for Release 12.2.6

Oracle BI Publisher for Beginners Guide

Query to get Pending Leave Request in Oracle Self Service

/*****Open Leave Requests In - Progress Workflows Oracle SSHR*****/

select papf.employee_number "Emp No.",
       papf.full_name "Employee Name",
       wf.status,
       paat.name "Leave Type",
       hrs.information1 "Start Date",
       hrs.information2 "End Date",
       DECODE(hrs.information5,80,hrs.information7 ||' Hrs',hrs.information8 || ' Days') "Duration",
       wf.begin_date "Applied on",
       wf.due_date "Due Date",
       wf.from_user "Last Approver",
       fnd.user_name,
       wf.to_user "Pending With",
       wf.subject,
       wf.from_role,
       wf.recipient_role,
       wf.original_recipient,
       hra.item_key     
  from wf_notifications             wf,
       hr_api_transactions          hra,
       hr_api_transaction_steps     hrs,
       per_absence_attendance_types paat,
       fnd_user                     fnd,
       per_people_x                 papf
where wf.item_key = hra.item_key
   and hrs.transaction_id = hra.transaction_id
   and paat.absence_attendance_type_id = hrs.information5
   AND fnd.employee_id = hra.creator_person_id
   AND papf.PERSON_ID = fnd.employee_id
   AND WF.MESSAGE_TYPE = 'HRSSA'
   AND WF.MESSAGE_TYPE = 'HRSSA'
   AND WF.STATUS IN ('OPEN', 'CANCELLED')
   AND Wf.subject like '%Leave%'
   AND wf.subject not like 'Application%Error%'
   AND wf.from_user not like 'SYSADMIN'
order by wf.begin_date

Query to get employee payment method in oracle hrms

SELECT pap.employee_number, pap.full_name, pap.person_id, paf.assignment_id,
       pam.org_payment_method_name, pay.percentage, pay.priority,
       pea.segment1 bank_name, pea.segment2 branch, pea.segment3 account_type,
       pea.segment4 iban, pea.segment5 ACCOUNT
  FROM pay_personal_payment_methods_f pay,
       pay_org_payment_methods_f pam,
       pay_external_accounts pea,
       per_all_assignments_f paf,
       per_all_people_f pap
 -- Hr_lookups hrl
WHERE  pay.org_payment_method_id = pam.org_payment_method_id
   AND paf.assignment_id = pay.assignment_id
   AND paf.person_id = pap.person_id
   AND TRUNC (SYSDATE) BETWEEN pap.effective_start_date AND pap.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN pay.effective_start_date AND pay.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN pam.effective_start_date AND pam.effective_end_date
   AND paf.primary_flag = 'Y'
   AND pea.external_account_id = pay.external_account_id