My Oracle Support Banner

EGL 9.2: When Deleting a Journal in DB2 z/OS Error is Received: " IBM][CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "SYNCDTTM". SQLSTATE=42821" (Doc ID 2886114.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


When deleting a journal an error is received as noted below

ERROR from the appplication log as reported by customer:

Please note the errors provided above from the user perspective is what Oracle Support got when replicating the issue.  For the customer who reported the issue - they said the user just got kicked out and didn't any of the errors that Oracle Support got. 

1) Go to General Ledger -.> Journals -> Create Journals -> Add/Update Journal Entries
2) Search for a journal that has not been posted and pull it up
3) Delete journal - get error




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

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