Fusion UK Payroll - FPS Process Ends With Error: You Must Enter The Normal Hours Worked For HMRC Payroll ID (Doc ID 2942536.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR  
---------------
When running the FPS (Full Payment Submission) for some employees, the process end with error message:

ERROR
---------------
ORA-20001: You must enter the normal hours worked for HMRC Payroll ID ****** and employee *** *****.
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2178
ORA-06512: at "FUSION.HRX_GB_FPS_ARCH", line 545
ORA-06512: at "FUSION.HRX_GB_FPS_ARCH_2023", line 7353
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 629
ORA-06512: at "FUSION.HRX_GB_FPS_ARCH_2023", line 7320
ORA-06512: at "FUSION.HRX_GB_FPS_ARCH", line 536
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2159
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the FPS process.
2. The process end with error.

Details:
- User tried marking respective employees via Statutory Deductions calculation card, PAYE component, PAYE details, as "Irregular employment payment".
- Also via same Statutory Deductions calculation card, PAYE component, PAYE details, under "Number of Hours Worked", set up as "E: Other" (for irregular employees with 0 working hours), but it still doesn't work.

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.