Datafix for FPS Error: Taxable Pay to Date for assignment XXXX must be greater than or equal to zero
Last updated on NOVEMBER 20, 2017
Applies to:Oracle HRMS (UK) - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.
If the following error occurs in Full Payment Submission report:
The Taxable Pay to Date for assignment XXXX must be greater than or equal to zero
and SOE shows Taxable Pay is a positive figure, then run the following scripts to confirm missing data in pay_gb_fps_details:
Replace the p_person_id in the first query with the person_id of the each affected employees.
1. Execute below query:
FROM per_all_assignments_f paaf,
WHERE paaf.person_id = p_person_id
AND pact.effective_date between paaf.effective_start_date and
AND paa.assignment_id = paaf.assignment_id
AND paa.payroll_action_id = pact.payroll_action_id
AND pact.action_type = 'B'
AND paa.action_status IN ('C','S')
AND pact.effective_date BETWEEN to_date p_start_date AND p_end_date;
p_start_date and p_end_date are from the previous month
2. Execute the below query by replacing the values from the Query1 results as appropriate:
select * from pay_gb_fps_details
where assignment_id = p_asg_id
and person_id = p_person_id
and payroll_asg_act_id = p_bal_act_id;
If Query2 returns no records that means the respective balance adjustments were not processed in FPS and the datafix must be ran.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms