EEX9.2: SQL Error When Opening An Expense Report Via Approve Transactions For Multi-lingual db. (Doc ID 2226004.1)

Last updated on MARCH 13, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When logged in with a non-base language of Canadian French - (Multi-lingual), after navigating to Travel and Expenses > Approve Transactions > Approve Transactions and clicking on an Expense Report to approve, users receive a SQL Error.

Replication Steps:
---------------------

1. This issue happens only in MS SQL server DB Multi Lingual 9.2 database.
2. Log in as Expense user into a non-base language of Canadian French pick ENG from drop down.
3. Navigate to Travel and Expenses > Approve Transactions > Approve Transactions.
4. Change language to Canadian French and click on an Expense Report to approve.
5. A SQL Error: Error Position: 0 is displayed

ERROR
-----------------------
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241
Statement: SELECT FILL.SETID,FILL.EXPENSE_TYPE,(CONVERT(CHAR(10),FILL.EFFDT,121)),FILL.LANGUAGE_CD,FILL.DESCR,FILL.DESCRSHORT FROM PS_EX_TYPES_LNG FILL WHERE FILL.SETID = :1 AND FILL.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EX_TYPES_LNG B WHERE B.SETID = FILL.SETID AND B.EXPENSE_TYPE = FILL.EXPENSE_TYPE AND B.EFFDT <= :2 AND B.LANGUAGE_CD = FILL.LANGUAGE_CD) AND FILL.LANGUAGE_CD = :3 AND NOT EXISTS (SELECT 'X' FROM PS_EX_ROLE_EXP_TYP C, PS_EX_EE_ORG_DTA D WHERE C.SETID = FILL.SETID AND C.EX_ROLE = D.EX_ROLE AND D.EMPLID = :4 AND C.EFFDT = (SELECT MAX(E.EFFDT) FROM PS_EX_ROLE_TBL E WHERE E.SETID = C.SETID AND E.EX_ROLE = C.EX_ROLE AND E.EFFDT <= :5) AND C.EFF_STATUS = 'A' AND C.EXPENSE_TYPE = FILL.EXPENSE_TYPE)

Please see Replication Steps document for more details.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms