When User Clicks on the Prompt Button For the 'Field Name' in the 'First Row Fields' Section on "Define Header Configuration" Page, "Incorrect syntax near the keyword 'WHERE'" Error Occurs
(Doc ID 3050041.1)
Last updated on DECEMBER 03, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
The issue is specific to Microsoft SQLServer Database.
Symptoms
When user clicks on the prompt button for the "Field Name" in the "First Row Fields" section on "Define Header Configuration" page, "Incorrect syntax near the keyword 'WHERE'" error occurs.
File: C:\PT859P23B........SQL error. Stmt #: 709 Error Position: 0 Return: 8601 - [Microsoft][ODBC
Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'WHERE'
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Executing SQL directly; no cursor. (SQLSTATE 01000) 16954
Failed SQL stmt: SELECT HR_EH_FIELDNAME
Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'WHERE'
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Executing SQL directly; no cursor. (SQLSTATE 01000) 16954
Failed SQL stmt: SELECT HR_EH_FIELDNAME
The issue can be reproduced at will with the following steps:
1. Navigate to: Menu > Set Up HCM > Common Definitions > Employee Header Configuration > Define Header Configuration
2. Search and open the "DEFAULT_HEADER"
3. Click on the prompt button for the "First Row Fields" field name.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |