My Oracle Support Banner

Error - "Error Position: 0 Return: 8601 - [CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target" When Running The AE For Post Data Conversion -PODC35093693 (Doc ID 2978556.1)

Last updated on JANUARY 26, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running change assistant step - "Run Post Data Conversion AE - PODC35093693" while applying updates from HCM 9.2 PUM 47 on DB2 database, the following error occurs.

2023-09-20 14:15:38.564 - [Step - Run Post Data Conversion AE - PODC35093693] Failed
2023-09-20 14:15:38.571 - #embed step execution error/warn log: E:\PUMS\47\UPDATEDIRS\Output\softwareupdateHCM47GETCURRENT{HR92U047-HR92DEV}IP20230919141358\PODC35093693_PODCPODC35093693_out.log
PeopleTools 8.59.09 - Application Engine
Copyright (c) 1988-2023 Oracle and/or its affiliates.
All Rights Reserved
File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821
 (SQLSTATE 22005) -408
Failed SQL stmt: UPDATE PS_HCSC_ANNOUNCE SET HCSC_NOT_SENT_DTTM = (SELECT HCSC_LAST_RUN_DATE FROM PS_HCSC_NOTIF WHERE PS_HCSC_ANNOUNCE.HCSC_NOTIF_TRNS_ID = PS_HCSC_NOTIF.HCSC_NOTIF_TRNS_ID)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [][CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821



Steps to reproduce the issue:
-------------------------------------
1. Run task in change assistant Post Data Conversion AE - PODC35093693.

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
References


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