My Oracle Support Banner

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 JULY 05, 2024

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
SQLERRMC1999631.1
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

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
References


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