My Oracle Support Banner

E-PPR: Error "SQL close:SQL error closing bulk mode: [Microsoft][ODBC Driver 17 for SQL Server]Datetime field overflow" When Searching For Voucher With Invoice Date In Microsoft SQL Server Database In 8.60.02 Tools Release. (Doc ID 2917270.1)

Last updated on JANUARY 13, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Information in this document applies to any platform.


After upgrading to 8.60.02 tools, when searching for the voucher using the regular entry page with the invoice date, below error shows up. This error is specific to Microsoft SQL Server Database.


“SQL close: SQL error closing bulk mode: [Microsoft][ODBC Driver 17 for SQL Server]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding. (SQLSTATE 22008) 0 (2,298) PTS_CFG_CL_WRK.PTS_SRCH_BTN.FieldFormula Name:AddToRecentSearches PCPC:58403 Statement:983
Called from:PTS_CFGSRCH_CL.StandardSearch.OnExecute Name:RunSearch Statement:144
Called from:PTS_CFG_CL_WRK.PTS_SRCH_BTN.FieldChange Statement:9

When closing an SQL object, the closing of bulk mode has reported the noted error. This error can arise because of previous Delete, Insert or Update SQL executions during the bulk mode, which are only completed when the bulk mode is closed.

The issue can be replicated with the following steps:
1. Navigate Menu > Accounts Payables > Vouchers> Add/ Update > Regular entry.
2. Search for vouchers.
3. Error occurs


Issue started after upgrading to 8.60.02 tools release and specific to Microsoft SQL Server Database.


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.