How To Resolve the Error "Invalid datatype specified" Isued by Stored Statement INPSPROC_S_TPRC when Running the 'Load Staged Items' Process (INPSSTGE) (Doc ID 1668270.1)

Last updated on AUGUST 03, 2023

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

The below error occurs when running the 'Load Staged Items' process (INPSSTGE) (navigation: Inventory, Putaway Stock, Load Staged Items):

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'

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

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

How To Resolve the Error "Invalid datatype specified" Isued by Stored Statement INPSPROC_S_TPRC when Running the 'Load Staged Items' Process (INPSSTGE) (Doc ID 1668270.1)

Applies to:

Goal

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!