My Oracle Support Banner

ECM: Bank Reconciliation (BNK_RECON) Abends at Step BNK_RECON.240-INST.STEP01 on DB2 With an Error, "The syntax of the string representation of a datetime value is incorrect." (Doc ID 2815028.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


After applying Image 39 on a DB2 database, the Bank Reconciliation (BNK_RECON) process is abending at Step BNK_RECON.240-Inst.Step01 with an error in the Message Log.

It appears that Bug 32127767 - ENH: EFFICIENT BANK STATEMENT PROCESSING, which was included in Image 39, added the new Step of BNK_RECON.240-Inst.Step01 which does not have the correct syntax for the DTTM_STAMP_SEC field on a DB2 database.

SQL Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007

1. Apply Image 39 on a DB2 database
2. Navigate to Bank > Reconcile Statements > Process Bank Reconciliation
3. Run the Bank Recon (BNK_RECON) process
4. Process will abend at Step BNK_RECON.240-Inst.Step01 with the above error


 Applying Image 39, which added the new Step of BNK_RECON.240-Inst.Step01.


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.