Fusion Global Payroll: Prepayments Error: A system error ORA-01400: cannot insert NULL into (???) ORA-06512: at "FUSION.HR_PRE_PAY", line 772 (Doc ID 2955108.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Symptoms

Fusion Payroll Prepayments process error out. While running Prepayments process in Production we are getting below error for around 55 employees:

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payroll Submit a Flow and Select the Calculate Payroll > AE LDG.
Provide the parameters and Payroll process completed > Total 209 records processed in Payroll Run.
2. Run Calculate Prepayments and enter the parameters.
3. Error occurs, Prepayments process completed with errors > 55 records failed.

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.