Return Code 08006 "Invalid datatype specified" Error When Running A Cobol Process
(Doc ID 2110658.1)
Last updated on AUGUST 15, 2024
Applies to:
PeopleSoft Enterprise CS Student Financials - Version 9 to 9.2 [Release 9]PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise CS Financial Aid - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Goal
Return Code: 08006 - "Invalid datatype specified" error occurs when running various Cobol processes.
Below is an example from an Inventory process.
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08006
Error Message : Invalid datatype specified
Stored Stmt : INPSPROC_S_TPRC
SQL Statement : SELECT INF.BUSINESS_UNIT , INF.INV_LOT_ID , INF.CONTAINER_ID
, INF.INV_ITEM_ID , INF.SERIAL_ID , INF.RECEIVER_ID , INF.R
ECV_LN_NBR , INF.STAGED_NUM , INF.SOURCE_BUS_UNIT , INF.RECV
_SHIP_SEQ_NBR , INF.DISTRIB_LINE_NUM , INF.DISTRIB_SEQ_NUM ,
TPRC.COST_ELEMENT , TPRC.TRANSFER_COST , TPRC.TRANSFER_COST
_DEST FROM PS_IN_DEMAND_TPRC TPRC, PS_STAGED_ITEM_INV INF WH
ERE INF.PROCESS_INSTANCE=:1 AND INF.BUSINESS_UNIT =:2 AND IN
F.STAGING_ID =:3 AND INF.INTERUNIT_ID = TPRC.INTERUNIT_ID AN
D INF.INTERUNIT_LINE = TPRC.INTERUNIT_LINE AND INF.RECEIPT_T
YPE = 'IUT'
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08006
Error Message : Invalid datatype specified
Stored Stmt : INPSPROC_S_TPRC
SQL Statement : SELECT INF.BUSINESS_UNIT , INF.INV_LOT_ID , INF.CONTAINER_ID
, INF.INV_ITEM_ID , INF.SERIAL_ID , INF.RECEIVER_ID , INF.R
ECV_LN_NBR , INF.STAGED_NUM , INF.SOURCE_BUS_UNIT , INF.RECV
_SHIP_SEQ_NBR , INF.DISTRIB_LINE_NUM , INF.DISTRIB_SEQ_NUM ,
TPRC.COST_ELEMENT , TPRC.TRANSFER_COST , TPRC.TRANSFER_COST
_DEST FROM PS_IN_DEMAND_TPRC TPRC, PS_STAGED_ITEM_INV INF WH
ERE INF.PROCESS_INSTANCE=:1 AND INF.BUSINESS_UNIT =:2 AND IN
F.STAGING_ID =:3 AND INF.INTERUNIT_ID = TPRC.INTERUNIT_ID AN
D INF.INTERUNIT_LINE = TPRC.INTERUNIT_LINE AND INF.RECEIPT_T
YPE = 'IUT'
How to resolve it?
Solution
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
| Goal |
| Solution |
| References |