My Oracle Support Banner

Retro Benefit Load To Paysheet Error: Invalid datatype specified Stored Stmt: PSPRDPS1_S_EEDATA (Doc ID 2526298.1)

Last updated on JULY 06, 2023

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When running the Load Retro Deductions to Paysheet process, the system is failing with:

Application Program Failed
Action Type     : SQL SELECT                    
In Pgm Section  : SQLRT: EXECUTE-STMT                                                                                                                                        
With Return Code: 08006
Error Message   : Invalid datatype specified
Stored Stmt     : PSPRDPS1_S_EEDATA  

The issue can be reproduced at will with the following steps:
1. Run the Load Retro Deds to Paysheets process.  Navigation: Payroll for North America -> Retroactive Payroll -> Retro Benefits Deductions -> Process and Review Requests -> Load Retro Deds to Paysheets
2. Note that the process ends in error.




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

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