Search This Blog

Tuesday, September 3, 2013

Retropay by Element Errors: APP-PAY-06881: Error ORA-01403: no data found has occurred in table PER_TIME_PERIODS

Problem Statement:
When attempting to run the RetroPay by Element process the following error occurs


ERROR
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
SQL_NO 3076
TABLE_NAME PER_TIME_PERIODS
APP-PAY-06881: Error ORA-01403: no data found has occurred in table PER_TIME_PERIODS at location 3076
Cause: an oracle error has occurred. The failure was reported on table
PER_TIME_PERIODS at location 3076 with the error text ORA-01403: no data found
Action: Please contact your support representative.

Solution:
To implement the solution, please execute the following steps:
1. Change the definition of the assignment set, choosing the correct payroll.
2. Submit the Retropay by Element process using the redefined assignment set.
3. If the issue is resolved, please migrate the solution as appropriate to other environments

Ref - 401208.1