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

Last updated on JANUARY 05, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-OCT-2014***


ConcurrentProgram:RETROELE - RetroPay By Element


Symptoms

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.



STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps.

Submit the Retropay by Element process
  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms