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 APRIL 04, 2019

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

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

ERROR
-----------------------
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  


STEPS
-----------------------
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.

Changes

 

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
Changes
Cause
Solution


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