Retropay By Element Error with: ORA-01403: no data found pay_input_values_f (Doc ID 1360523.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When attempting to run retropay by element, the following error occurs.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 520
TABLE_NAME pay_input_values_f
APP-PAY-06881: Error ORA-01403: no data found
has occurred in table pay_input_values_f at location 520

Cause: an oracle error has occurred. The failure was reported on table pay_input_values_f at location 520 with the error text ORA-01403: no data found
.

Action: Please contact your support representative.

 
-- Steps
The issue can be reproduced at will with the following steps.
1. Run Retropay
2. Get error as described

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