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 MARCH 20, 2025

Applies to:

Symptoms

Problem Statement:
If the following error occurs in Full Payment Submission report:

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.

Changes

Cause

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