How to Run Carryover Process for One Employee (PTO Carry Over)

Oracle has come up with a work around solution to run PTO Carry over for one or specific employee(s). Kindly follow the below said note ID as provided by Oracle

Oracle Note ID: How to Run and Debug the Carryover Process for One Employee (Doc ID 261617.1)

Steps to Run "PTO Carry Over" for Specific Employee

Package Name: PAY_US_PTO_CO_PKG.PTO_CARRY_OVER_FOR_PLAN

1) Take a backup of the package PAY_US_PTO_CO_PKG

2) Find the cursor csr_get_assignment  and hard code the assignment_id for one employee.

cursor csr_get_assignment is

select distinct pee.assignment_id assignment_id, asg.assignment_number

from pay_element_entries_f pee,

pay_element_links_f pel,

per_all_assignments_f asg

where pel.element_type_id = p_plan_ele_type_id

and pel.element_link_id = pee.element_link_id

and pee.assignment_id = asg.assignment_id

and asg.period_of_service_id is not null

and (p_accrual_term = 'PTO_CURRENT' or

(p_accrual_term = 'PTO_PREVIOUS' and

asg.effective_start_date < p_calculation_date));

In the above cursor, add the following condition 

AND asg.assignment_id = <assignment_id>

alter package PAY_US_PTO_CO_PKG compile

alter package PAY_US_PTO_CO_PKG compile body

commit;

Run "PTO Carry Over" à Check LOG