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.
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