QuickPay Errors: APP-PAY-51119: Error was encountered when processing Element Type, HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01403: no data found (Doc ID 2270747.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

Running QuickPay errors out with the following:

HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 1031638
APP-PAY-51118: Error was encountered when processing assignment [####]
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME [element name]
APP-PAY-51119: Error was encountered when processing Element Type [element name]
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 


Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Run a Quickpay process for any employee

2. Observe it error out

3. Observe the errors in a GMZEFT log

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