My Oracle Support Banner

Datafix for FPS Error: Taxable Pay to Date for assignment XXXX must be greater than or equal to zero (Doc ID 2330149.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.


Problem Statement:
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:

paa.assignment_action_id),16)) p_bal_act_id,
max(paaf.assignment_id) p_asg_id,
max(paaf.person_id) p_person_id
FROM per_all_assignments_f paaf,
pay_assignment_actions paa,
pay_payroll_actions pact
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.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.