COBRA Administration Error: "Invalid Datatype Specified" (Doc ID 1076240.1)

Last updated on OCTOBER 12, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 8.3 to 9.1 [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

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