Fusion Global Payroll: ORA-01403 no data found occurred in table pay_element_types_f at location 5077 Error in Recalculate Payroll For Retroactive Changes (Doc ID 2966337.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

When attempting to run Recalculate Payroll for Retroactive Changes, the following error occurs for multiple employees.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 5077
TABLE_NAME pay_element_types_f
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01403: no data found occurred in table pay_element_types_f at location 5077. Contact your help desk.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Recalculate Payroll for Retroactive Changes.
2. Error occurs.

Cause

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