Enhanced Retropay Error: ORA-01403: no data found has occurred in table per_assignments_f at location 1857 (Doc ID 2188069.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, RetroPay Issue

When attempting to run Retropay (Enahnced) the following error occurs

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR

SQLERRMC ORA-01403: no data found
SQL_NO 1857
TABLE_NAME per_assignments_f

APP-PAY-06881: Error ORA-01403: no data found has occurred in table per_assignments_f at location 1857

STEPS

-----------------------
The issue can be reproduced at will with the following steps:
1. Login to HRMS Manager Responsibility
2. Navigate to View > Submit Request
3. Run Retro Notification Report Enhanced -PDF
4. Run  Retropay (Enhanced)

Changes

 

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