COBRA Administration Error: "Invalid Datatype Specified"
(Doc ID 1076240.1)
Last updated on APRIL 25, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 8.3 to 9.2 [Release 8.3 to 9]Information in this document applies to any platform.
Symptoms
The COBRA COBOL process is failing with the following error message.
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 : PSPCOBRA_S_PERDATA
ERROR
-----------------------
Event Maintenance Scheduling Started at 15:58:13.28.
Application Program Failed
Action Type : SQL FETCH
In Pgm Section : SQLRT: DA000-FETCH
With Return Code: 09003
Error Message : A numeric string contains non-numeric data
ERROR
-----------------------
Remote program PSPBARUN failed with return code: 8003. Reason: Invalid SELECT item number.
In Section: SQLRT: PROCESS-SETUP(SELECT)-PARTIC-COST(2,-1) BENEF_PB_WRK.ODEM_SCHED_ACTY_PB.FieldDefault
Name: ODEM_RemoteCall PCPC:335 Statement:4
Called from BENEF_PB_WRK.ODEM_PREP_OPTN_PB.FieldChange Statement:4
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 |