Table Validation Report Fails With Error 'SQL0180N The syntax of the string representation of a datetime value is incorrect.'
Last updated on JANUARY 10, 2018
Applies to:PeopleSoft Enterprise CS Student Financials - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
Table Validation Report run in Update Mode on a db2/Linux or Unix environment will fail for some students.
Running Table Validation in Report mode for these same students will finish successfully.
SFTBLVAL.SQR, insert-item-due-dt, Insert, PS_ITEM_DUE_SF
SQL Status = -180, SQL Error = SQL0180N The syntax of the string representation of a datetime value is
The issue can be reproduced at will with the following steps:
On the specified platform, perform the following steps:
1. Navigate to Student Financials, Charges and Payments, Validate Tables;
2. Select a run control;
3. Populate the run control as follows:
Select Option = Individual Only
Run Option = Update
Enter the Student Financials Business Unit
Check All Boxes ON in the 'Detail Options' Group Box
Check All Boxes ON in the Item Details Group Box
Click Commit At End in the Commit Options group box
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms