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 NOVEMBER 20, 2017

Applies to:

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

Symptoms

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:

SELECT
to_number(substr(max(lpad(paa.action_sequence,15,'0')||
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
paaf.effective_end_date
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.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms