My Oracle Support Banner

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


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.