My Oracle Support Banner

Fusion Payroll: Payroll Calculation Errors For The Employee After The Hire Date Is Retroactively Changed (Doc ID 2753430.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.10.0 version, Global Payroll

When attempting to process payroll,
the following error occurs.

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

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Hire an employee
2. Complete Payroll for first period
3. Hire date changed to next period
4. Run Retropay process
5. Run Payroll process

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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