My Oracle Support Banner

UK: Retropay Fails with ORA-01403 When Processing Postgraduate Loan (Doc ID 2556983.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle HRMS (UK) - Version 12.2 HRMS RUP13 and later
Information 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.

object type: [FF] object id: [<FORMULA_ID>]
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:

  1.  Login as UK HRMS Manager responsibility
  2.  Create element entry "Postgraduate Loan" before 1-APR-2019.
  3.  Submit Quick Retropay(Enhanced)
  4.  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


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