ETL9.x: PSPLDTL1 Processing Error - Specified Row Does Not Exist, Store Stmt PSPPARRY_S_PRIMDED. (Doc ID 1947066.1)

Last updated on APRIL 22, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Goal

When the T&L Load process was running, at the same time Customer has had delivered Benefit App Engine Job started BN_BEN500_AE and it went to success but the PSPLDTL1 was failed which the following error

Error Message   : ORA-08005: specified row does not exist
Stored Stmt     : PSPPARRY_S_PRIMDED
Check Time and Labor Errors in Payroll Error Messages

Application Program Failed
Action Type     : SQL SELECT
In Pgm Section  : SQLRT: EXECUTE-STMT                                
With Return Code: 08005
Error Message   : ORA-08005: specified row does not exist
Stored Stmt     : PSPPARRY_S_PRIMDED
SQL statement text not available.
   See the SQL trace for statement text
   when this cursor was last compiled.

Application Program Failed
In Pgm Section  : LOAD-PRIMARY-JOB-DED(SELECT)                        
With Return Code: 08005
Error Message   : ORA-08005: specified row does not exist


Application Program Failed
In Pgm Section  : GET-EE-PAY-DATA(PSPLDTL2)                          
With Return Code: 08005
Error Message   : ORA-08005: specified row does not exist


Application Program Failed
In Pgm Section  : PSPLDTL2                                            
With Return Code: 08005
Error Message   : ORA-08005: specified row does not exist

Solution

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