UK: Retropay Fails with ORA-01403 When Processing Postgraduate Loan
(Doc ID 2556983.1)
Last updated on OCTOBER 22, 2023
Applies to:
Oracle HRMS (UK) - Version 12.2 HRMS RUP13 and laterInformation in this document applies to any platform.
This note provides a brief overview of
Symptoms
Problem Statement:
When attempting to run Quick Retropay (Enhanced), the following error occurs.
In { pycfind
object not found
Out } pycfind
Out } pyccret
In { pyclff
Oracle error occurred
Table=ff_formulas_f
sqlno=521
ORA-01403: no data found
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Postgraduate Loan
APP-PAY-51119: Error was encountered when processing Element Type Postgraduate Loan
In { pyxipmt
message text = Error was encountered when processing Element Type Postgraduate L
oan
message level = F,F
payroll_id text = <PAYROLL_ID>
source_id text = 10,<RETROPAY ASSIGNMENT_ACTION_ID>
line_text = 68, Error was encountered when processing Element Type Postgraduate
Loan
Out } pyxipmt
In { pylogpop
Out } pylogpop
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
SQL_NO 521
TABLE_NAME ff_formulas_f
APP-PAY-06881: Error ORA-01403: no data found
has occurred in table ff_formulas_f at location 521
Cause: an oracle error has occurred. The failure was reported on table ff_formulas_f at location 521 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:
- Login as UK HRMS Manager responsibility
- Create element entry "Postgraduate Loan" before 1-APR-2019.
- Submit Quick Retropay(Enhanced)
- Error occurs
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 |
Cause |
Solution |
References |