EEX 9.2: Error "Incorrect syntax near ')' " In Expense History When Viewing In Other Than Base Language
(Doc ID 3063343.1)
Last updated on DECEMBER 13, 2024
Applies to:
PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
On : 9.2.49 version, Expense Report
Error in Expense History when viewing in other than base language.
ERROR
---------
SQL error. Function: SQLExec
Error Position: 0
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cu
Statement: SELECT FILL.DESCR FROM PS_EX_PURPOSE_LNG FILL WHERE FILL.SETID = :1 AND FILL.BUSINESS_PURPOSE = :2 AND FILL.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EX_PURPOSE_LNG B WHERE B.SETID = FILL.SETID AND B.BUSINESS_PURPOSE = FILL.BUSINESS_PURPOSE AND B.EFFDT <= :3) AND B.LANGUAGE_CD = FILL.LANGUAGE_CD) AND FILL.LANGUAGE_CD = :4
Original Statement: SELECT FILL.DESCR FROM PS_EX_PURPOSE_LNG FILL WHERE FILL.SETID = :1 AND FILL.BUSINESS_PURPOSE = :4 AND FILL.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EX_PURPOSE_LNG B WHERE B.SETID = FILL.SETID AND B.BUSINESS_PURPOSE = FILL.BUSINESS_PURPOSE AND Útein(B.EFFDT) <= Útein(:2)) AND B.LANGUAGE_CD = FILL.LANGUAGE_CD) AND FILL.LANGUAGE_CD = :3
---------
SQL error. Function: SQLExec
Error Position: 0
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cu
Statement: SELECT FILL.DESCR FROM PS_EX_PURPOSE_LNG FILL WHERE FILL.SETID = :1 AND FILL.BUSINESS_PURPOSE = :2 AND FILL.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EX_PURPOSE_LNG B WHERE B.SETID = FILL.SETID AND B.BUSINESS_PURPOSE = FILL.BUSINESS_PURPOSE AND B.EFFDT <= :3) AND B.LANGUAGE_CD = FILL.LANGUAGE_CD) AND FILL.LANGUAGE_CD = :4
Original Statement: SELECT FILL.DESCR FROM PS_EX_PURPOSE_LNG FILL WHERE FILL.SETID = :1 AND FILL.BUSINESS_PURPOSE = :4 AND FILL.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EX_PURPOSE_LNG B WHERE B.SETID = FILL.SETID AND B.BUSINESS_PURPOSE = FILL.BUSINESS_PURPOSE AND Útein(B.EFFDT) <= Útein(:2)) AND B.LANGUAGE_CD = FILL.LANGUAGE_CD) AND FILL.LANGUAGE_CD = :3
The issue can be reproduced at will with the following steps:
1. Login with a different language other than base language (on the login page, change the language)
2. Open Expense Report History
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 |